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.
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.
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.
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.
|
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.
|
3. |
The Startup/Shutdown:Confirmation page is displayed. Click Yes to start the instance and open the database.
|
4. |
The Startup/Shutdown:Activity page is displayed.
|
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.
|
6. |
The Database home page is displayed.
|
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.
|
3. | The Startup/Shutdown:Specify Host
and Target Database Credentials page appears. Enter the host credentials
and database credentials. Click OK.
|
4. | The Startup/Shutdown:Confirmation
page appears. Click Yes to perform the shutdown operation.
|
5. | The Startup/Shutdown:Activity Information
page appears. Click Refresh.
|
6. | You can now restart your instance
or perform recovery.
|
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.
|
2. |
Click All Initialization Parameters in the Database Configuration section.
|
3. |
The Initialization Parameters page appears. Click Database to return to the Database Home page.
|
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.
|
2. |
Click Memory Parameters in the Database Configuration section.
|
3. |
The Memory Parameters page appears. Click Database to return to the Database Home page.
|
Move your mouse over this icon to hide all screenshot