Chapter 5: Managing the Oracle Instance

Purpose

This chapter focuses on the tasks involved in managing your instance. In this chapter, you will learn how to use the property pages in the Instance region of the Administration page of Enterprise Manager.

Topics

This chapter discusses the following:

Using Enterprise Manager to Start Up and Shut Down the Oracle Instance
Viewing Initialization Parameters
Managing Memory Parameters

Move your mouse over this icon to show all screenshots. You can also move your mouse over each individual icon to see only the screenshot associated with it.

 

Using Enterprise Manager to Start Up and Shut Down the Instance

Back to Topic List

The instance is idle until it is started. When the instance is started, an initialization parameter file is read and the instance is configured accordingly. After the instance is started and the database is opened, users can access the database. In this section, you will examine the following tasks:

Starting the Instance
Shutting Down the Instance

Note: If your instance is already started, you may perform the Shutting Down the Instance task before the Starting the Instance task.

Starting the Instance

Back to Topic List

You can use Enterprise Manager to start the instance and open the database by performing the following steps:

1.

Invoke Enterprise Manager from your browser. The Database page is displayed indicating that the instance is down. Click Startup to start the instance.

Move your mouse over this icon to see the image

 

2.

The Startup/Shutdown:Specify Host and Target Database Credentials page is displayed. Enter the host credentials and database credentials. Select Save as Preferred Credentials. Click OK.

Move your mouse over this icon to see the image

 

3.

The Startup/Shutdown:Confirmation page is displayed. Click Yes to start the instance and open the database.

Move your mouse over this icon to see the image

 

4.

The Startup/Shutdown:Activity page is displayed.

Move your mouse over this icon to see the image

 

5.

After the instance is started and the database is open, the Login page is displayed. Enter the username and password to log in to Enterprise Manager Database Control. Click Login.

Move your mouse over this icon to see the image

 

6.

The Database home page is displayed.

Move your mouse over this icon to see the image

 

Shutting Down the Instance

Back to Topic List

You can use Enterprise Manager to shut down the instance and close the database by performing the following steps:

1.

Log in to Enterprise Manager Database Console by opening your browser and specifying the SYS username and password.

Click Login.

 

2. Click Shutdown on the Database Home page.

Move your mouse over this icon to see the image

 

3. The Startup/Shutdown:Specify Host and Target Database Credentials page appears. Enter the host credentials and database credentials. Click OK.

Move your mouse over this icon to see the image

 

4. The Startup/Shutdown:Confirmation page appears. Click Yes to perform the shutdown operation.

Move your mouse over this icon to see the image

 

5. The Startup/Shutdown:Activity Information page appears. Click Refresh.

Move your mouse over this icon to see the image

 

6. You can now restart your instance or perform recovery.

Move your mouse over this icon to see the image

 

 

Back to Topic List

The initialization parameter file contains a list of configuration parameters for the instance and database. The Oracle database server reads these parameters at database startup and monitors them while the database is running. The values of the parameters are stored in memory and many can be changed dynamically.

Follow the steps below to view the values of the initialization parameters for your database:

1.

Click Administration on the Database Home page to access the Administration property page.

Move your mouse over this icon to see the image

 

2.

Click All Initialization Parameters in the Database Configuration section.

Move your mouse over this icon to see the image

 

3.

The Initialization Parameters page appears. Click Database to return to the Database Home page.

Move your mouse over this icon to see the image

 

Back to Topic List

In this section you learn how to view the values of the memory parameters in your database. Memory parameters are the initialization parameters that determine the total size of the system global area (SGA) and its sub-components, and the program global area (PGA). The values of the memory parameters can affect the performance of your database.

If the Oracle server advises you of a performance problem relating to the size of the SGA or PGA, you can use the memory advisor to help you determine appropriate new settings. The memory advisor can model the effect of parameter changes. Refer to Chapter 10 for information on using the memory advisors.

Perform the steps listed below to view the values of the memory parameters:

1.

Click Administration on the Database Home page to access the Administration property page.

Move your mouse over this icon to see the image

 

2.

Click Memory Parameters in the Database Configuration section.

Move your mouse over this icon to see the image

 

3.

The Memory Parameters page appears. Click Database to return to the Database Home page.

Move your mouse over this icon to see the image

 

Move your mouse over this icon to hide all screenshot