Results for WITH


1 to 20 of 19354 results. Prev  Next
Results per page:   20  | 40 | 60


2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Managing Templates with DBCAformat in another file with a.dfj extension. The corresponding.dfj file's location is stored in … . Creating Templates Using DBCA The Template Management page provides you with the option of creating or

2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

Undo Management with Enterprise ManagerWith Enterprise Manager, you can access the Undo Management page from the database Administration … automatic extension of the undo tablespace with automatically tuned undo retention, you can ensure that

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Performing and Scheduling Backups with Enterprise ManagerWhole Database Backup with Oracle Enterprise Manager Whole backups of a database are based on backing up … , archived redo log and server parameter file. With this set of files, the database can be recovered

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

3 Getting Started with Oracle Enterprise ManagerThis chapter introduces you to the Oracle Enterprise Manager, the Web-based interface for managing an Oracle database. Understanding this tool is essential to managing the Oracle database as described in the rest of this book. This chapter contains the following topics: Introduction to the Oracle Enterprise Manager Starting the Oracle Enterprise Manager Console Accessing the Oracle Enterprise Manager

2 Day DBA, 10g Release 1 (10.1)

1 Introduction

How to Use this Book with Related MaterialThis book is part of comprehensive set of learning material for administering an Oracle Database, which includes a 2 Day DBA Oracle by Example (OBE) series, available on the Web, and an Oracle University instructor-led class. Every chapter in Oracle Database 2 Day DBA has an associated Oracle By Example lesson. The OBE steps through all tasks in the chapter and includes annotated screen shots. In

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Setting Preferred CredentialsYou can have Enterprise Manager automatically fill in host and database login credentials for you, such as when you schedule jobs and tasks to perform administrative operations like backup and recovery. For security, Oracle stores preferred credentials in encrypted mode. To set preferred credentials for the database, do the following: From the home page, click Preferences at the top of the page. The

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Navigational Featuresto perform tasks associated with backing up and maintaining your data. Figure 3-1 Database Home Page

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Starting i SQL*Plusi SQL*Plus is the Web version of SQL*Plus. Before you can connect to it with a URL, you must start … start After the server is started, you can connect to i SQL*Plus with a URL such as http

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Starting dbconsole in WindowsServices page appears. Oracle services begin with Oracle. The dbconsole service is listed as

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Introduction to the Oracle Enterprise ManagerWhen you install an Oracle database, the Oracle Universal Installer also installs the Oracle Enterprise Manager. The Web-based Database Control serves as the primary tool for managing your Oracle database and sets a new standard in ease-of-use. The following topics introduce you to the Oracle Enterprise Manager Database Control: Database Management Features Online Help Navigational Features

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Granting Database Control Administrative PrivilegesWhen you log in to the Oracle Enterprise Manager using the SYS or SYSTEM user account, you are logging in as the Oracle Enterprise Manager super user. These are the only accounts that are automatically granted the roles and privileges required to access all the management functionality provided the Database Control. To grant management access to other database users, use the following procedure: Start

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

SQL Statements and Other Management Tools: SQL*Plus and i SQL*PlusEnterprise Manager is a Web-based graphical interface that enables you to perform management operations on the database like startup and shutdown, object creation, and schema management. The underlying operations are performed using Structured Query Language (SQL) statements. SQL is an English-like computer programming language for accessing and manipulating data contained in a database. It is an

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Database Management FeaturesFrom the Oracle Enterprise Manager, you can perform administrative tasks such as creating schema objects (tablespaces, tables, and indexes), managing user security, backing up and recovering your database, and importing and exporting data. You can also view performance and status information about your database instance.

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Accessing the Oracle Enterprise ManagerAt the end of a successful database creation, Oracle Enterprise Manager is automatically launched and the database is started. At other times, provided the dbconsole process is running on the server, you can navigate to your Database Control from your client browser as follows: Point your Web browser to the following URL: http://hostname:portnumber/em For example, if you installed the database on

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Starting SQL*Plusissue these statements interactively or in batch. SQL*Plus comes with your Oracle installation and is

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Getting Started: Oracle by Example Seriesfamiliar with your database. They are presented as links to the chapters that contain information about … . Populate tables with data. See Chapter 8, "Managing Schema Objects". Review a backup strategy for the

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Online HelpYou can access context sensitive online Help by clicking Help displayed on every page. In addition to viewing the help specific to the task at hand, there is a View Contents link that takes you to top level Help where you can view a table of contents and link to topics. A search facility enables you to search the contents of Help.

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Setting Up Enterprise Manager PreferencesEnterprise Manager enables you to set up preferences that help you manage the database. These include the following: Notification— These are settings that enable Oracle to email you alert notifications. Alerts are notifications of when a database is in an undesirable state and needs your attention. By default, the Enterprise Manager home page lists all alerts. However, set up is required for e-mail

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Defining Blackout Time PeriodsWhen you plan to bring your database down for maintenance, you can indicate that you do not want alert notifications to be sent to you. Alerts are notifications of when the database is in an undesirable state and needs your attention. For more information about alerts, see "Alerts". To define a blackout time period, follow these steps From the home page, click Setup at the top of the page. The Setup

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Starting the Oracle Enterprise Manager ConsoleTo access the Oracle Enterprise Manager Console from a client browser, the dbconsole process needs to be running on the server. This process is automatically started after installation. However, if the process is not running because of a system restart or other event, you can manually start it at the command line. To start the dbconsole process: Navigate into your $ORACLE_HOME/bin directory Run the


Was this page helpful?