Oracle 10.2 reconstruction em

When the machine on which Oracle is installed changes the machine name or IP address. Then the original dbconsole cannot start.

Or an error is reported when running emctl start dbconsole in DOS. Solution:

 

1. Modify the Dbsnmp password:

To reconfigure the dbconsole, you need to enter the Dbsnmp password, but any password will display an error and must be modified in advance.

SQL> alter user Dbsnmp identified by XXX;

 

2. delete users created on the early dbconsole:

SQL> drop role mgmt_user;

SQL> drop user mgmt_view cascade;

SQL> drop user sysman cascade;

 

3. Delete the objects created on the early dbconsole:

SQL> drop public synonym mgmt_target_blackouts;

SQL> drop public synonym setemviewusercontext;

 

4. Recreate dbconsole:

[Windows] input at the command prompt:

C:/> emca-config dbcontrol DB-repos create

 

Enter the following information:

Database Sid: orcl

Listener port number: 1521

Assword for sys User:

Password for Dbsnmp User:

Password for sysman User:

Email Address for communications (optional ):

Outgoing mail (SMTP) server for communications (optional ):

----------------------------------------------------------------------

 

Enter the following information database for the database to be configured

Sid: according to the actual listening program port: 1521

Dbsnmp password: XXX (SQL> alter user Dbsnmp identified by XXX ;)

Sysman password: Enter one by yourself

Sys password: based on facts

Email Address of the notification: Optional

Email Gateway for notification: Optional

If the reconstruction is successful, the following information is displayed:

 

Info: >>>>>>>>>>> the Database Control URL is http: // 192.168.120.128: 5501/EM <Enterprise Manager Configuration completed successfully finished emca at Jan 7, 2011 6:05:35 PM 5.

 

PS: When you create an EM instance, the prompt port number should be the instance's disconnected slogan, such as 1521, not the EM port number (such as 1158)

The EM port number can be found in this file 10.2.0db _ 1sysmanconfigemca. Properties

 

6: After the creation is successful, check the status command emctl status dbconsole

You can also see the following reconstruction information:

C:/> emctl status dbconsole

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 copyright (c) 1996,200 5 Oracle Corporation.

All rights reserved. http: // 192.168.120.128: 5501/EM/console/aboutapplication Oracle Enterprise Manager 10g is running. ---------------------------------------------------------------- logs are generated in directory c:/Oracle/product/10.2.0/db_1/192.168.120.128 _ or CL/sysman/log:

 

7. The service has been started. To manually restart: emctl stop dbconsole emctl start dbconsole

 

PS: Open the browser and enter http: // machine name: Port/EM or Use http: // ip: Port/em to access

If http: // machine name: Port/EM is unavailable, you need to change the hosts file of the Local Machine and add IP ing.