OracleDBConsoleSID 与 VC服务

今天又遇到Oracle DB Console服务无法启动导致VC无法启动的事情。

 

以前我clone VC 的时候，修改了主机名和IP，但是通过复制db_1/oc4j/j2ee下的DB Console的目录就可以解决这个错误的，不过这次看到的却有点不同，最后没办法，通过EMCA 命令重建DB Console来解决，不知道有谁对这块有更多了解不。

 

解决日志：

C:\Documents and Settings\Administrator>emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.

The OracleDBConsolevpx service is not started.

More help is available by typing NET HELPMSG 3521.

C:\Documents and Settings\Administrator>set ORACLE_SID=[My SID]

C:\Documents and Settings\Administrator>emca -config dbcontrol db -repos recreat
e

STARTED EMCA at Aug 16, 2010 8:53:42 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: [SID]
Database Control is already configured for the database [SID]
You have chosen to configure Database Control for managing the database [SID]
This will remove the existing configuration and the default settings and perform
 a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: [PORT]
Password for SYS user: ******
Password for DBSNMP 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 ................ D:\oracle\product\10.2.0\db_1

Database hostname ................ [HOSTNAME]
Listener port number ................ [PORT]
Database SID ................ [SID]
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 16, 2010 8:55:34 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\vpx\emca_2010-08-16_08-53-42-PM.log.
Aug 16, 2010 8:55:43 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5540 is already in use.
Aug 16, 2010 8:55:43 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5520 is already in use.
Aug 16, 2010 8:55:43 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 1158 is already in use.
Aug 16, 2010 8:55:43 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Aug 16, 2010 8:55:48 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Aug 16, 2010 8:57:25 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 16, 2010 8:57:26 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 16, 2010 9:01:34 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 16, 2010 9:01:45 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 16, 2010 9:02:12 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 16, 2010 9:02:12 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 16, 2010 9:03:02 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 16, 2010 9:03:03 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is <<<<<<<
<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 16, 2010 9:03:03 PM

C:\Documents and Settings\Administrator>