Oracle 10g em manager fault Case Analysis

 

After you modify the computer name or the configuration of Oracle when using the Oracle 10g Database, the Oracle Enterprise Manager fails, causing the Database Control Service to fail to start normally, this will cause a lot of trouble. The re-configuration method of EM is described below.

Microsoft Windows 2000 [version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

Step 1: Tell the operating system the specified Oracle SID

C: \ Documents ents and Settings \ Administrator> set oracle_sid = keymen

C: \ Documents ents and Settings \ Administrator> CD \

Step 2: try to create the archive used by em

 

C: \> emca-repos create

Emca started at 16:27:10
Em configuration assistant 10.2.0.1.0 official version
Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:
Database Sid: keymen
Listener port: 1521
Sys user password:
Sys User Password: SysAdmin

Continue? [Yes (y)/NO (n)]:
Continue? [Yes (y)/NO (n)]: Y
2009-6-20 16:27:31 oracle. sysman. emcp. emconfig perform
Information: this operation is logged to c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ keymen \ emca_2009-06-20_04-27-10-Afternoon. log.
16:27:32 oracle. sysman. emcp. emreposconfig createrepository
Information: creating the EM archives (this operation may take some time )...
16:27:32 oracle. sysman. emcp. emreposconfig invoke
Severe: An error occurred while creating the archive.
16:27:32 oracle. sysman. emcp. emreposconfig invoke
Information: For more information, see log files in c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ keymen \ emca_repos_create _ <date>. log.
2009-6-20 16:27:32 oracle. sysman. emcp. emconfig perform
Severe: An error occurred while creating the archive.
For more information, see log files in c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ keymen \ emca_2009-06-20_04-27-10-Afternoon. log.
Configuration cannot be completed. For more information, see log files in c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ keymen \ emca_2009-06-20_04-27-10-Afternoon. log.

Step 3: If creation fails, delete the archive and recreate it !!!

C: \> emca-repos drop

Emca started at 16:27:48
Em configuration assistant 10.2.0.1.0 official version
Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:
Database Sid: keymen
Listener port: 1521
Sys user password:
Sys User Password: SysAdmin

Continue? [Yes (y)/NO (n)]: Y
2009-6-20 16:27:59 oracle. sysman. emcp. emconfig perform
Information: this operation is logged to c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ keymen \ emca_2009-06-20_04-27-48-Afternoon. log.
2009-6-20 16:28:00 oracle. sysman. emcp. emreposconfig droprepository
Information: deleting the EM archives. This operation may take some time )...
16:29:45 oracle. sysman. emcp. emreposconfig invoke
Information: The archive has been deleted successfully.
The Enterprise Manager configuration has been completed successfully.
Emca ended at 16:29:45

Step 4: re-establish

C: \> emca-repos create

Emca started at 16:30:03
Em configuration assistant 10.2.0.1.0 official version
Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:
Database Sid: keymen
Listener port: 1521
Sys user password:
Sys User Password: SysAdmin

Continue? [Yes (y)/NO (n)]: Y
2009-6-20 16:30:17 oracle. sysman. emcp. emconfig perform
Information: this operation is logged to c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ keymen \ emca_2009-06-20_04-30-03-Afternoon. log.
16:30:18 oracle. sysman. emcp. emreposconfig createrepository
Information: creating the EM archives (this operation may take some time )...
16:32:49 oracle. sysman. emcp. emreposconfig invoke
Information: You have created a Data Archiving database.
The Enterprise Manager configuration has been completed successfully.
Emca ended at 16:32:50

Step 5: Set oracle_name = keymen

 

C: \> set oracle_name = keymen

Step 6: recreate the Oracle em control service

C: \> emca-config dbcontrol DB

Emca started at 16:35:15
Em configuration assistant 10.2.0.1.0 official version
Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:
Database Sid: keymen
Database Control configured for the database keymen
You have selected to configure Database Control to manage database keymen
This operation will remove the existing configuration and default settings, and re-execute the configuration
Continue? [Yes (y)/NO (n)]: Y
Listener port: 1521
Sys user password:
Dbsnmp user password:
Password of the sysman User:
Password of the sysman User: email address of the notification (optional ):
Notification sending (SMTP) server (optional ):
-----------------------------------------------------------------

The following settings have been specified:

Database ORACLE_HOME ...... c: \ oracle \ product \ 10.2.0 \ db_1

Database Host Name ...... ST14
Listener port number ...... 1521
Database Sid ......
Email Address of the notification ...............
Notification sending (SMTP) server ...............

-----------------------------------------------------------------
Continue? [Yes (y)/NO (n)]: Y
2009-6-20 16:35:38 oracle. sysman. emcp. emconfig perform
Information: this operation is logged to c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ keymen \ emca_2009-06-20_04-35-15-Afternoon. log.
2009-6-20 16:35:39 oracle. sysman. emcp. util. dbcontrolutil stopoms
Information: The Database Control is being stopped (this operation may take some time )...
2009-6-20 16:35:45 oracle. sysman. emcp. util. dbcontrolutil startoms
Information: Starting Database Control (this operation may take some time )...
16:36:25 oracle. sysman. emcp. emdbpostconfig configure mconfiguration
Information: The Database Control has been started successfully.
16:36:25 oracle. sysman. emcp. emdbpostconfig configure mconfiguration
Warning: The Database Control shortcut cannot be created.
16:36:25 oracle. sysman. emcp. emdbpostconfig configure mconfiguration
Information: >>>>>>>>>> Database Control URL is http: // ST14: 5501/EM <
The Enterprise Manager configuration has been completed successfully.
Emca ended at 16:36:25

C: \>

Step 7:

After successful creation, you can log on to the system using the Database Control URL http: // ST14: 5501/em url.