Oracle Enterprise Manager (OEM) rebuild

Environment

Win7+oracle 11gR2

Remove EM Configuration

C:\users\administrator>emca-deconfig Dbcontrol DB EMCA started on 2018-6-12 14:19:10 EM Configuration Assistant, 11.2.0.0.2 official version Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID:ORCL Do you want to continue? [Yes (Y)/No (N)]: Y 2018-6-12 14:19:23 Oracle.sysman.emcp.EMConfig Perform Info: This operation is being logged to D:\Oracle\cfgtoollogs\emca\orcl\emca_2018_06_12_14_19_09.log. 2018-6-12 14:19:23 Oracle.sysman.emcp.util.DBControlUtil stopoms Info: Stopping Database Control (This operation may take some time) ... 2018-6-12 14:19:55 Oracle.sysman.emcp.EMReposConfig Stopdbmsjobs Warning: An error occurred while initializing the SQL connection. Unable to execute SQL operation 2018-6-12 14:19:55 Oracle.sysman.emcp.EMReposConfig Invoke Warning: Unable to remove DBMS job. Configuration of Enterprise Manager completed successfully EMCA ended on 2018-6-12 14:20:24 C:\users\administrator>emca-repos Drop EMCA started on 2018-6-12 14:20:53 EM Configuration Assistant, 11.2.0.0.2 official version Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID:ORCL Listener Port number: 1521 SYS User's password: Sysman User's password: Sysman User's password: Do you want to continue? [Yes (Y)/No (N)]: Y 2018-6-12 14:21:38 Oracle.sysman.emcp.EMConfig Perform Info: This operation is being logged to D:\Oracle\cfgtoollogs\emca\orcl\emca_2018_06_12_14_20_53.log. 2018-6-12 14:21:38 Oracle.sysman.emcp.ParamsManager Checklistenerstatusfordbcontrol Warning: An error occurred while initializing the SQL connection. Unable to execute SQL operation 2018-6-12 14:21:38 Oracle.sysman.emcp.EMReposConfig Invoke Info: Removing the EM Data archive (this may take some time) ... 2018-6-12 14:25:49 Oracle.sysman.emcp.EMReposConfig Invoke Info: The repository was deleted successfully Configuration of Enterprise Manager completed successfully EMCA ended on 2018-6-12 14:25:49

Rebuilding EM

C:\users\administrator>emca-config Dbcontrol Db-repos Create EMCA started on 2018-6-12 15:38:47 EM Configuration Assistant, 11.2.0.0.2 official version Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID:ORCL Listener Port number: 1521 Listener Oracle_home [D:\Oracle\product\11.2.0\dbhome_1]: SYS User's password: DBSNMP User's password: Sysman User's password: Sysman User's password: e-mail address of the notification (optional): Outgoing (SMTP) server for notifications (optional): ----------------------------------------------------------------- The following settings have been specified The database is oracle_home ..... ..... D:\Oracle\product\11.2.0\dbhome_1 Local host name .......... 192.168.1.112 The listener is oracle_home ...... ..... D:\Oracle\product\11.2.0\dbhome_1 Listener port number ...... ....... 1521 Database SID ..... ORCL----- The e-mail address of the notification ..... Notification of the outgoing (SMTP) server ..... ..... ----------------------------------------------------------------- Do you want to continue? [Yes (Y)/No (N)]: Y 2018-6-12 15:39:05 Oracle.sysman.emcp.EMConfig Perform Info: Logging This action to D:\Oracle\cfgtoollogs\emca\orcl\emca_2018_06_12_15_38_4 7.log. 2018-6-12 15:39:07 Oracle.sysman.emcp.EMReposConfig createrepository Info: Creating an EM Data archive (this operation may take a while) ... 2018-6-12 15:47:51 Oracle.sysman.emcp.EMReposConfig Invoke Info: The repository was created successfully 2018-6-12 15:47:59 Oracle.sysman.emcp.EMReposConfig uploadconfigdatatorepository Info: Uploading configuration data to the EM data archive (this operation may take some time) ... 2018-6-12 15:48:40 Oracle.sysman.emcp.EMReposConfig Invoke Info: The configuration data was uploaded successfully 2018-6-12 15:48:49 Oracle.sysman.emcp.util.DBControlUtil Configuresoftwarelib Info: The software library has been configured successfully. 2018-6-12 15:48:49 Oracle.sysman.emcp.EMDBPostConfig configuresoftwarelibrary Info: Provisioning profile is being deployed ... 2018-6-12 15:49:27 Oracle.sysman.emcp.EMDBPostConfig configuresoftwarelibrary Info: Provisioning file deployment was successful. 2018-6-12 15:49:27 Oracle.sysman.emcp.util.DBControlUtil Securedbconsole Info: Protecting Database Control (This operation may take some time) ... 2018-6-12 15:49:36 Oracle.sysman.emcp.util.DBControlUtil Securedbconsole Info: Database Control has been successfully protected. 2018-6-12 15:49:36 Oracle.sysman.emcp.util.DBControlUtil startoms Info: Starting Database Control (This operation may take some time) ... 2018-6-12 15:51:12 Oracle.sysman.emcp.EMDBPostConfig performconfiguration Info: The Database Control was successfully started 2018-6-12 15:51:14 Oracle.sysman.emcp.EMDBPostConfig performconfiguration Info: >>>>>>>>>>> Control URL for Https://192.168.1.112:5500/em <<< <<<<< <<< 2018-6-12 15:51:24 Oracle.sysman.emcp.EMDBPostConfig Invoke Warning: WARNING ************************ The management repository is placed in safe mode, in which Enterprise Manager data is encrypted. The encryption key has been placed in the file D:/oracle/product/11.2.0/dbhome_1/192.168.1.112_orcl/sysman The/config/emkey.ora. Be sure to back up this file, because if this file is lost, the encrypted data will not be available. *********************************************************** Configuration of Enterprise Manager completed successfully EMCA ended on 2018-6-12 15:51:24

Detects if the EM service is started

C:\users\administrator>emctl Status Dbconsole environment variable oracle_unqname not defined. Please set Oracle_unqname to Da Tabase unique name. C:\users\administrator>Set ORACLE_UNQNAME=ORCL C:\users\administrator>emctl Status Dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, Oracle Corporation. All rights reserved. Https://192.168.1.112:5500/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------ Logs is generated in directory d:\oracle\product\11.2.0\dbhome_1/192.168.1.112_ Orcl/sysman/log

Set Oracle_unqname= $ORACLE _sid

This parameter is ORACLE11GR2 new. Therefore, this variable must be set before installation.

Console setting TEMP environment variable: set oracle_unqname= $ORACLE _sid (e.g. ORCL)

Note: The port of EM after the rebuild is 5500.

EM access

The user name and password here need to be noted that the user name and password in the EM environment are not the password to install Oracle.

Specific reference: 50999670

The above solutions can be resolved. But I suspect it's a matter of authority.

After you have modified your password, you can log in.

Shutting down and starting the ORACLEDBCONSOLEORCL service

The ORACLEDBCONSOLEORCL service is used to support EM access. You can manually start and close the service.

c:\users\administrator>emctl Stop Dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, Oracle Corporation. All rights reserved.
Https://192.168.1.112:5500/em/console/aboutApplication
ORACLEDBCONSOLEORCL service is stopping .....
The ORACLEDBCONSOLEORCL service has stopped successfully.

C:\users\administrator>emctl start Dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, Oracle Corporation. All rights reserved.
Https://192.168.1.112:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ... Oracledbconsoleorcl
The service is starting ...... .....
The ORACLEDBCONSOLEORCL service has started successfully.

Oracle Enterprise Manager (OEM) rebuild