Oracle 入門之EM配置

Oracle 11g R2 64位啟動em,出現如下錯誤:
[root@localhost ~]# su - Oracle
[Oracle@localhost ~]$ emctl start dbconsole
Environment variable Oracle_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
-
 

[Oracle@localhost ~]$ export ORACLE_UNQNAME=online
[Oracle@localhost ~]$ emctl start dbconsole
OC4J Configuration issue. /u01/app/Oracle/oc4j/j2ee/OC4J_DBConsole_localhost.localdomain_online not found.
問題原因為em資料庫配置不正確，或者是dbcontrol沒有配置好

1：重建EM資料
[Oracle@localhost ~]$ emca -repos recreate

STARTED EMCA at Sep 6, 2010 4:42:53 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: online
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y
Sep 6, 2010 4:43:30 PM Oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/cfgtoollogs/emca/online/emca_2010_09_06_16_42_52.log.
Sep 6, 2010 4:43:31 PM Oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Sep 6, 2010 4:46:23 PM Oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Sep 6, 2010 4:46:24 PM Oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 6, 2010 4:53:00 PM Oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 6, 2010 4:53:00 PM

2：配置dbcontrol
[Oracle@localhost ~]$ emca -config dbcontrol db

STARTED EMCA at Sep 6, 2010 5:02:57 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: online
Listener port number: 1521
Listener Oracle_HOME [ /u01/app/oracle ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database Oracle_HOME ................ /u01/app/oracle

Local hostname ................ localhost.localdomain
Listener Oracle_HOME ................ /u01/app/oracle
Listener port number ................ 1521
Database SID ................ online
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 6, 2010 5:03:34 PM Oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/cfgtoollogs/emca/online/emca_2010_09_06_17_02_56.log.
Sep 6, 2010 5:03:39 PM Oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Sep 6, 2010 5:04:45 PM Oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Sep 6, 2010 5:04:46 PM Oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for localhost.localdomain
Sep 6, 2010 5:04:49 PM Oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Sep 6, 2010 5:04:49 PM Oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Sep 6, 2010 5:05:22 PM Oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Sep 6, 2010 5:05:22 PM Oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Sep 6, 2010 5:06:17 PM Oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Sep 6, 2010 5:06:17 PM Oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 6, 2010 5:07:00 PM Oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 6, 2010 5:07:00 PM Oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://localhost.localdomain:1158/em <<<<<<<<<<<
Sep 6, 2010 5:07:04 PM Oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:

可以看到em已經啟動：
[Oracle@localhost ~]$ netstat -ntpl |grep 1158
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp        0      0 :::1158                     :::*                        LISTEN      11125/java         
[Oracle@localhost ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://localhost.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/Oracle/localhost.localdomain_online/sysman/log
************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has

been placed in the file: /u01/app/Oracle/localhost.localdomain_online/sysman/config/emkey.ora.   Please ensure this file is

backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 6, 2010 5:07:04 PM

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]