Oracle® Enterprise Manager Grid Control Installation and Basic Configuration
10g Release 1 (10.1)
Part No. B12012-03
In addition to using Oracle Enterprise Manager Database Control or Grid Control to manage an Oracle Database 10g database, you can also use the Oracle Enterprise Manager Java Console to manage databases from this release or previous releases. The Java Console is installed by the Administrator installation type.
Note:Oracle recommends that you use Grid Control or Database Control in preference to the Java Console when possible. All Java Console functionality will be migrated to Grid Control in future releases. The Java Console will no longer be available once functionality migration is complete.
Set the ORACLE_HOME environment variable to specify the Oracle home directory where you installed Oracle Client.
Depending on your platform, set the shared library path environment variable for your system to include the following directories:
|Platform||Environment Variable||Required Setting|
Enter the following command to start the Java Console:
$ $ORACLE_HOME/bin/oemapp console
$ $ORACLE_HOME/bin/oemapp dbastudio
The Change Manager application is the Oracle Change Management Pack central interface. Change Manager gives you direct or indirect access to all of the Oracle Change Management Pack operations (in cases where Change Manager cannot directly perform an operation, such as capturing or comparing object definitions, Change Manager starts the application that performs that operation). All change management information is stored in the standalone repository.
When connected to the standalone repository:
Change Manager provides access to the Oracle Change Management Pack objects in the standalone repository. Because the standalone repository contains only objects that you created, the Change Manager navigator tree displays only your Change Management Pack objects.
You have full access to your objects, but no access to any other objects.
Other Change Management Pack applications started from Change Manager also run standalone.
You cannot submit change plan scripts as jobs using the Oracle Enterprise Manager job system, but you can execute scripts interactively.
The first time Change Manager is accessed, you will be prompted to create a database user who will own the standalone repository schema or you will be prompted to specify a username and password if you have already created the user.
Because this database user must have certain roles and privileges, Oracle recommends creating a new database user to own the standalone repository schema. In addition, because certain tablespace attributes are required for the standalone repository, you should also create a new tablespace. Once the user and tablespace have been created, you can supply the user's username and password, and the standalone application will automatically create the standalone repository for you.
If you do not want to be prompted with the standalone Repository Login dialog every time you start your Change Manager, select the Save password and automatically log into repository next time option to save the credentials for future use.
Before creating a standalone repository
Make sure the database used for the repository is supported.
Create a tablespace for the standalone repository.
Create a database user for the standalone repository.
The following database releases are supported for the standalone repository:
Enterprise Edition or Standard Edition Release 10.1.x
Enterprise Edition or Standard Edition Release 9.2.x
Enterprise Edition or Standard Edition Release 9.0.1.x
You must ensure that the database in which the repository will be placed has object support. If it does not, repository creation will fail. Either select another database that has object support, or install and enable object support on the chosen database.
Note:Object support is installed and enabled by default for database releases 10.1.x, 9.2.x, 9.0.1.x, and 8.1.7.x.
Create a tablespace with the following attributes:
Storage attributes: for Extent Management, use Locally managed
For 2 Kb blocks: 16 MB
For 4 Kb blocks: 24 MB
For 8 Kb blocks: 32 MB
For sizes above 8 KB: 64 MB
Reuse Existing File: Yes
AUTOEXTEND increment: 5MB
AUTOEXTEND maximum: 2000MB
To create a tablespace for the standalone repository, first select the database in which you want to place the standalone repository, ensuring it meets the requirements outlined. Then, follow the procedure described in this section:
Start the Oracle Enterprise Manager Java Console.
On Windows: You can start the standalone Console from the Windows Start Menu.
On UNIX: You can start the standalone Console from the command line using the command:
Click the + next to Databases to display the list of databases under the Databases.
Double-click the database node in the Navigator and connect to the database as a user with the NORMAL privilege.
Choose Create from the Object menu. The Create Object List dialog appears.
Expand the database node in the Create Object List dialog and select Tablespace. Then click Create. The Create Tablespace property sheet appears.
In the Create Tablespace Property Sheet's General page,
Enter the name of the new tablespace, OEM_REPOSITORY.
Specify that the tablespace will be used to hold permanent database objects.
In the Datafile section, enter the size of the new datafile. The File Name and File Directory columns should already contain default entries. The datafile is called OEM_REPOSITORY.dbf or OEM_REPOSITORY.ora depending on the version of the database.
Right-click the + next to OEM_REPOSITORY.dbf and choose Edit. The Create Datafile property sheet appears.
In the Create Datafile's General page, select the Reuse Existing File box.
In the Create Datafile's Storage page, fill the appropriate attributes
Select the Automatically extend datafile when full (AUTOEXTEND) option so that the datafile will automatically increase in size when more space is needed in the database.
Specify 5 MB as the Increment.
Specify 2000 MB as the Maximum Size.
Click OK in the Create Datafile property sheet.
In the Create Tablespace Property Sheet's Storage page, select the Locally Managed option as the method of space management.
Click Create in the Create Tablespace Property Sheet.
A standalone repository is owned by a database user. A database user, in other words, a repository schema user, who will own the repository must be created before the standalone repository can be created by Enterprise Manager.
Add required privileges
To create a database user who will own the standalone repository, follow the procedure described in this section:
Start the standalone Console.
Click the + next to Databases to display the list of databases under the Databases.
Double-click the database node in the Navigator and connect to the database as a user with the NORMAL role.
Choose Create from the Object menu. The Create Object List dialog appears. Expand the database node in the Create Object List dialog and select User. Then click Create. The Create User property sheet appears.
In the General page, provide the name of the user and its password and select OEM_REPOSITORY as the default tablespace and TEMP as the temporary tablespace.
In the Role page, grant the CONNECT and SELECT_CATALOG_ROLE roles to the repository user.
In the System Privileges page grant the CREATE PROCEDURE, CREATE TRIGGER, CREATE TYPE, EXECUTE ANY PROCEDURE, EXECUTE ANY TYPE, SELECT ANY DICTIONARY (for 9i), and SELECT ANY TABLE, privileges to the repository user.
In the Quota page, specify unlimited for OEM_REPOSITORY and TEMP.
Click Create in the Create User property sheet.
Once you have a tablespace and a repository user, start a standalone application which requires a standalone repository.
When the dialog appears informing you that certain features of Enterprise Manager require a standalone repository and you must create a new database user to own the standalone repository schema, click OK to close the dialog since you have already created the user.
Supply the user's username and password for the repository login and click OK. The standalone application will automatically create the standalone repository for you.
You can start the Change Manager application in any of the following ways:
From the Oracle Enterprise Manager Java Console, use any of these methods:
Select a database in the navigator panel, click the right mouse button, point to the Related Tools menu option, then click Change Manager
On the Tools menu, point to Change Management Pack, then click Change Manager.
Click the Change Management Pack drawer, then click the Change Manager icon.
On UNIX or in a DOS window on an NT machine, set default to the ORACLE_HOME/bin directory (where ORACLE_HOME is the directory in which Oracle Enterprise Manager is installed), then enter the following in lowercase characters at the command line prompt:
On the Windows Start menu, point to Programs, then to the Oracle Home where Oracle Enterprise Manager is installed, then to Change Management Pack, then click Change Manager.