Oracle EM Cannot access

zwt2001267 Original Oracle EM cannot access

1. cmd Control start em:

C:\users\administrator>emctl Start Dbconsole
environment variable oracle_unqname not defined. Please set Oracle_unqname to database unique name.

C:\users\administrator>Set ORACLE_UNQNAME=ORCL (db instance name)

C:\users\administrator>emctl start Dbconsole

Cannot start, reported error code 2.

No way to rebuild EM:

Here is the process of EMCA creating EM, which is a rough demonstration:

1. Delete the build failed EM archive

C:\Documents and Settings\administrator>emca-deconfig dbcontrol db-repos drop
EMCA started on 2009-7-23 11:19:18
EM Configuration Assistant, 11.1.0.5.0 official version
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database Sid:verafzy
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

2009-7-23 11:19:40 Oracle.sysman.emcp.EMConfig Perform
Info: Logging This action to E:\app\Administrator\cfgtoollogs\emca\verafzy\emca_2009
_07_23_11_19_17.log.
2009-7-23 11:19:42 Oracle.sysman.emcp.util.DBControlUtil stopoms
Info: Stopping Database Control (This operation may take some time) ...
2009-7-23 11:20:23 Oracle.sysman.emcp.EMReposConfig Invoke
Info: Removing the EM Data archive (this may take some time) ...
2009-7-23 11:24:42 Oracle.sysman.emcp.EMReposConfig Invoke
Info: The repository was deleted successfully
Configuration of Enterprise Manager completed successfully
EMCA ended on 2009-7-23 11:24:56

2. Re-create the EM archive

C:\Documents and Settings\administrator>emca-config Dbcontrol db-repos Create

EMCA started on 2009-7-23 11:26:55
EM Configuration Assistant, 11.1.0.5.0 official version
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database Sid:verafzy
Listener Port number: 1521
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 ..... ..... E:\app\Administrator\product\11.1.0\db_1
Local host name .......... PC-200901030636
Listener port number ...... ....... 1521
Database SID ..... verafzy-----
The e-mail address of the notification .....
Notification of the outgoing (SMTP) server ..... .....
Do you want to continue? [Yes (Y)/No (N)]: Y
009-7-23 11:27:13 Oracle.sysman.emcp.EMConfig Perform
Info: Logging This action to E:\app\Administrator\cfgtoollogs\emca\verafzy\emca_2009
07_23_11_26_55.log.
009-7-23 11:27:15 Oracle.sysman.emcp.EMReposConfig createrepository
Info: Creating an EM Data archive (this operation may take a while) ...
009-7-23 11:39:46 Oracle.sysman.emcp.EMReposConfig Invoke
Info: The repository was created successfully
009-7-23 11:39:59 Oracle.sysman.emcp.EMReposConfig uploadconfigdatatorepository
Info: Uploading configuration data to the EM data archive (this operation may take some time) ...
009-7-23 11:41:42 Oracle.sysman.emcp.EMReposConfig Invoke
Info: The configuration data was uploaded successfully
009-7-23 11:41:47 Oracle.sysman.emcp.util.DBControlUtil Configuresoftwarelib
Info: The software library has been configured successfully.
009-7-23 11:41:47 Oracle.sysman.emcp.EMDBPostConfig configuresoftwarelibrary
Info: Provisioning profile is being deployed ...
009-7-23 11:42:02 Oracle.sysman.emcp.EMDBPostConfig configuresoftwarelibrary
Info: Provisioning file deployment was successful.
009-7-23 11:42:03 Oracle.sysman.emcp.util.DBControlUtil Securedbconsole
Info: Protecting Database Control (This operation may take some time) ...
2009-7-23 11:42:19 Oracle.sysman.emcp.util.DBControlUtil Securedbconsole
Info: Database Control has been successfully protected.
2009-7-23 11:42:19 Oracle.sysman.emcp.util.DBControlUtil startoms
Info: Starting Database Control (This operation may take some time) ...
2009-7-23 11:46:29 Oracle.sysman.emcp.EMDBPostConfig performconfiguration
Info: The Database Control was successfully started
2009-7-23 11:46:34 Oracle.sysman.emcp.EMDBPostConfig performconfiguration
Info: >>>>>>>>>>> Control URL for Https://PC-200901030636:1158/em <<< <<<
<<<<<
2009-7-23 11:47:10 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 E:\app\Administrator\product\11.1.0\db_1\PC-200901030636_ve

The Rafzy\sysman\config\emkey.ora. Be sure to back up this file, because if this file is lost, the number of encryption

The data will not be available.



***********************************************************

Configuration of Enterprise Manager completed successfully

EMCA ended on 2009-7-23 11:47:13





Ok! Build success, you can go to the browser under the Login EM management platform!

I landed at this address in IE8: Https://localhost:1158/em/console/logon/logon view as follows, EM formally established success, there may be security aspects of the problem of verification, as long as the import certificate, restart the next OK!

Last success!

Oracle EM Cannot access