Skip Headers

Oracle® Database 2 Day DBA
10g Release 1 (10.1)

Part Number B10742-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

3 Getting Started with Oracle Enterprise Manager

This 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

When 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

From 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.

Online Help

You 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.

Navigational Features

Navigational features of Oracle Enterprise Manager include the following:

Starting the Oracle Enterprise Manager Console

To 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:

  1. Navigate into your $ORACLE_HOME/bin directory

  2. Run the following statement:

    ./emctl start dbconsole
    
    

Additionally, you can stop the process and view its status.

To stop the dbconsole process:

./emctl stop dbconsole

To view the status of the dbconsole process:

./emctl status dbconsole

Starting dbconsole in Windows

In Windows, in addition to using the command line, you can start the dbconsole process as a service.

To start dbconsole as a service:

  1. Click Start->Control Panel->Administrative Tools->Services. The Services page appears.

  2. Oracle services begin with Oracle. The dbconsole service is listed as Oracle<oracle_home><SID>DBConsole. The status of this process is listed in the Status column, either Started or Stopped. Double click the service. The property page appears.

  3. In the properties page, ensure that the Startup Type is either Manual or Automatic and not Disabled. Click Start, if the process is not already started. Click OK.

You can also use the Services page to stop the process.

Accessing the Oracle Enterprise Manager

At 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:

  1. Point your Web browser to the following URL:

    http://hostname:portnumber/em

    For example, if you installed the database on a host computer named comp42, and the installer indicated that your Enterprise Manager Console HTTP port number is 5500 (also recorded in the $ORACLE_HOME/install/portlist.ini file), enter the following URL:

    http://comp42:5500/em

    If the database is up, Enterprise Manager displays the Database Control Login page.

    If the database is down and needs to be re-started, Enterprise Manager displays the Startup/Shutdown and Perform Recovery page. If this is the case, click Startup/Shutdown. You are then prompted for the host and target database login usernames and passwords, which you must enter. For the database user and password, use SYS and the password you specified during installation.

    Click OK to start the database. In the Confirmation screen, click YES to start the database in open mode.

  2. Log in to the database using a username that is authorized to access the Database Control. This initially could be SYS or SYSTEM. Use the password you specified for the account during the database installation.

    Enterprise Manager displays the Database Home page (Figure 3-4).

    The property pages across the top of the page enable you to access performance, administration, and maintenance pages for managing your database. The functionality provided by these pages is discussed in other chapters of this book.

    The various sections of the Database Home page, and related links, provide a wealth of information about the database's environment and health. For example, the Alerts, Related Alerts, and Performance Analysis sections warn you of errors and performance problems that are impacting the operation of your database. You can click the provided links to see more detail about the problem area, and even to obtain recommendations for resolving the problem. This is all discussed in Chapter 10, "Monitoring and Tuning the Database".


Granting Database Control Administrative Privileges

When 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:

  1. Start your Web browser and log in to the Database Control as the SYS or SYSTEM database user.

  2. Click Setup at the top of the Database Home page.

  3. Click Administrators in the left navigation bar.

    If you need to create a new administrator, you must first create the user and then assign administrative privileges as described in this section. To create a new user, see "Administering Database Users"

  4. Click Create to create a new Enterprise Manager user by assigning the management privileges to an existing database user.

  5. Click the flashlight icon next to the Name field and select an existing database user from the pop-up window.

  6. Enter the password for the selected user and click Finish.

Enterprise Manager assigns the management privileges to the selected user. The selected database user is now included in the list of management users on the Setup Administrators page. All the users shown on this page can log in to the Database Control and perform database management tasks.

Setting Up Enterprise Manager Preferences

Enterprise Manager enables you to set up preferences that help you manage the database. These include the following:

Defining Blackout Time Periods

When 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

  1. From the home page, click Setup at the top of the page. The Setup page appears.

  2. Click Blackouts in the left hand pane. The Blackouts page appears.

  3. Click Create. This starts the Create Blackout wizard. On the Properties page, name your blackout, and select the target that has planned downtime. Click Next.

  4. On the Schedule page, enter the start time of your planned blackout, or choose immediately if you are bringing the database down now. Also select the duration of the blackout, either as indefinite, as a length or time, or until a time in the future. Under Repeating, accept the default of Do Not Repeat. If you want to repeat the blackout periodically, you can select a repeat frequency in the pull down menu. Click Next.

  5. The review page appears. Review what you have entered, and if satisfied, click Finish. If not, you can click Back to change a setting.

Setting Preferred Credentials

You 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:

  1. From the home page, click Preferences at the top of the page. The Preferences page appears.

  2. Click Preferred Credentials in the left hand pane. The Preferred Credentials page appears. For the Database target, click the icon under Set Credentials. The Database Preferred Credentials page appears.

  3. For your database, enter the credentials for Normal Username/Password, SYSDBA Username/Password, and Host Username/Password.

  4. Click Test to test your credentials. You should get a confirmation message if your credentials can be verified.

  5. Click Apply to apply the changes.

SQL Statements and Other Management Tools: SQL*Plus and iSQL*Plus

Enterprise 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 industry-standard language for accessing databases, including those provided by vendors other than Oracle.

The following is an example of a SQL query:

SELECT COUNTRY_ID, COUNTRY_NAME FROM HR.COUNTRIES;

SQL is a powerful language and can be used to perform a variety of database administrative tasks. While performing these tasks, you can click Show SQL to see the underlying SQL statements being issued.

For more details on this language, see Oracle Database SQL Reference.

In addition to Enterprise Manager, you can use other Oracle tools to issue SQL statements such as SQL*Plus and its Web version iSQL*Plus. These tools enable you to perform the same database management operations, as well as to query, insert, update or delete data directly in the database.

Starting SQL*Plus

SQL*Plus is a command line program you use to issue SQL statements to an Oracle database. You can issue these statements interactively or in batch. SQL*Plus comes with your Oracle installation and is located in your $ORACLE_HOME/bin directory.

To start SQL*Plus, enter the following at the command line on all platforms:

sqlplus username/password

You can use the SYS administrative user and password you set up during installation. SQL*Plus starts and connects you to the default database. At the SQL prompt, you can enter statements that perform administrative tasks such as database startup and shutdown. You can also query, insert, update and delete data.

On Windows, you can use the SQL*Plus Windows GUI. To start this, select Start->Programs->Oracle-OraHomeName->Application Development->SQL*Plus.

For more information about SQL*Plus, see SQL*Plus User's Guide and Reference.

For more information about SQL statements, see Oracle Database SQL Reference.

Starting iSQL*Plus

iSQL*Plus is the Web version of SQL*Plus. Before you can connect to it with a URL, you must start the iSQL*Plus application server. To do so, enter the following at the command line:

isqlplusctl start

After the server is started, you can connect to iSQL*Plus with a URL such as

http://machine_name:5560/isqlplus

Alternatively, you can connect to iSQL*Plus using Enterprise Manger. To do so from the home page, click iSQL*Plus under Related Links.

For more information about iSQL*Plus, see SQL*Plus User's Guide and Reference.

Managing Your Database: A Roadmap

The following are some specific tasks to perform to become familiar with your database. They are presented as links to the chapters that contain information about these tasks and other related database management tasks.

  1. Start up your instance and open the database. At the end of installation, your instance is already started and your database is open. In the future there will be times, perhaps for doing database maintenance or because of a power or media failure, that you shut down your database or instance and later restart it. See "Shutting Down and Restarting the Instance and Database".

  2. Optionally configure the network environment to enable clients to connect to your database. See Chapter 4, "Configuring the Network Environment".

  3. Review your database storage structure: tablespaces and datafiles, redo log files, and control files. See Chapter 6, "Managing Database Storage Structures".

  4. Review, unlock, and reset passwords as necessary for initial database users. Create new users and assign privileges and roles to them. See Chapter 7, "Administering Users and Security".

  5. Create users and necessary schema objects, including tablespaces and tables. Populate tables with data. See Chapter 8, "Managing Schema Objects".

  6. Review a backup strategy for the database and back up the database. See Chapter 9, "Performing Backup and Recovery".

  7. Enable archiving of redo logs, if not already done. See "Configuring Your Database for Basic Backup and Recovery".

  8. Monitor database performance, diagnose performance problems and tune the database as necessary. See Chapter 10, "Monitoring and Tuning the Database".

Getting Started: Oracle by Example Series

Oracle by Example (OBE) has a series on the Oracle Database 2 Day DBA book. This OBE steps you through the tasks in this chapter, and includes annotated screen shots.

To view the Getting Started OBE, point your browser to the following location:

http://otn.oracle.com/obe/2day_dba/gettingstarted/gettingstarted.htm