Oracle10g provides a web-based management tool dbcontrol, which is similar to the OEM tool of Oracle9i, but has greatly improved its functionality. When creating a database instance
Oracle 10 Gb provides a web-based management tool db control, which is similar to Oracle 9i OEM tools, but has greatly improved its functionality. When creating a database instance
Oracle 10 Gb provides a web-based management tool db control, which is similar to Oracle 9i OEM tools, but has greatly improved its functionality.
A management tool is created when you create a database instance. However, this tool is closely related to the Host Name of the machine. This causes some trouble in the HA environment.
The following describes how to configure the db control tool in the HA environment.
Delete original db control information
$> Emca-deconfig dbcontrol db-repos drop
Enter information as prompted.
Delete database objects related to db control
SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
Create a new db control environment
Create a virtual host name when creating a new db control. Use export ORACLE_HOSTNAME = . We recommend that you configure this variable to the environment variable and the/etc/hosts file. It is best to bind the Virtual Host Name and floating IP address.
Create a new environment
$> Export ORACLE_HOSTNAME = HOST_LISTEN
$ Emca-config dbcontrol db-repos create
Enter the required information as prompted.
Synchronize the configuration file (the basic software is placed on the shared disk. skip this step)
Synchronize the created configuration file to the backup service. The configuration files to be synchronized include:
$ ORACLE_HOME/
$ ORACLE_HOME/Solaris/j2ee/OC4J_DBConsole _
In this example, the directory is HOST_LISTEN_ora10, Which is packaged and sent to the backup service for decompression.
Start db control
Switch the database to the backup server and start db control.
$> Emctl start dbcontrol
After the database is started successfully, the url for accessing the Database control is displayed. If an error occurs, follow the prompts in the log file to solve the problem.