10g异机恢复后EM无法启动故障处理一例

之前在自己的测试环境上做了个异机恢复，原来的库上是配置过EM的，但是在恢复的库上去启动EM就报错了，下面看具体解决过程：PS：原主机名为zlm，恢复出来的主机名为bak [root@bak ~]# su – oracle[oracle@bak ~]$ emctl status dbconsole TZ set to PRCOC4J C

之前在自己的测试环境上做了个异机恢复，原来的库上是配置过EM的，但是在恢复的库上去启动EM就报错了，下面看具体解决过程：PS：原主机名为zlm，恢复出来的主机名为bak
[root@bak ~]# su – oracle[oracle@bak ~]$ emctl status dbconsole
TZ set to PRCOC4J Configuration issue. /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_bak_ora10g not found. [oracle@bak ~]$ cd /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/[oracle@bak j2ee]$ lltotal 24-rw-r–r– 1 oracle oinstall 256 Aug 22 16:42 deploy_db.inidrwxr-x— 15 oracle oinstall 4096 Aug 22 16:29 homedrwxr-x— 9 oracle oinstall 4096 Aug 22 16:24 isqlplusdrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 oc4j_applicationsdrwxr-x— 5 oracle oinstall 4096 Aug 22 16:24 OC4J_DBConsoledrwxr-x— 7 oracle oinstall 4096 Aug 25 11:25 OC4J_DBConsole_zlm_ora10g
既然提示文件找不到，很显然是因为主机名变更的缘故，那么把名字变一下，用mv命令
[oracle@bak j2ee]$ mv -r OC4J_DBConsole_zlm_ora10g/ OC4J_DBConsole_bak_ora10g/[oracle@bak j2ee]$ lltotal 24-rw-r–r– 1 oracle oinstall 256 Aug 22 16:42 deploy_db.inidrwxr-x— 15 oracle oinstall 4096 Aug 22 16:29 homedrwxr-x— 9 oracle oinstall 4096 Aug 22 16:24 isqlplusdrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 oc4j_applicationsdrwxr-x— 5 oracle oinstall 4096 Aug 22 16:24 OC4J_DBConsoledrwxr-x— 7 oracle oinstall 4096 Oct 20 10:58 OC4J_DBConsole_bak_ora10g[oracle@bak j2ee]$ emctl status dbconsole
TZ set to PRCEM Configuration issue. /u01/app/oracle/product/10.2.0/db_1/bak_ora10g not found. [oracle@bak j2ee]$ cd /u01/app/oracle/product/10.2.0/db_1/
[oracle@bak db_1]$ lltotal 260drwxr-x— 7 oracle oinstall 4096 Aug 22 16:24 assistantsdrwxr-xr-x 2 oracle oinstall 12288 Aug 22 16:42 bindrwxr-x— 3 oracle oinstall 4096 Aug 22 16:33 cdatadrwxr-x— 6 oracle oinstall 4096 Aug 25 11:08 cfgtoollogsdrwxr-x— 4 oracle oinstall 4096 Aug 22 16:24 clonedrwxr-x— 2 oracle oinstall 4096 Aug 22 16:33 configdrwxr-x— 6 oracle oinstall 4096 Aug 22 16:24 crsdrwxr-x— 7 oracle oinstall 4096 Aug 22 16:33 cssdrwxr-x— 10 oracle oi本文来源gao@!dai!ma.com搞$$代^@码5网@nstall 4096 Aug 22 16:33 ctxdrwxr-x— 2 oracle oinstall 4096 Oct 20 09:17 dbsdrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 demodrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 diagnosticsdrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 hasdrwxr-x— 6 oracle oinstall 4096 Aug 22 16:42 hsdrwxr-x— 5 oracle oinstall 4096 Aug 25 11:27 install-rw-r—– 1 oracle oinstall 37 Aug 22 16:24 install.platformdrwxr-x— 12 oracle oinstall 4096 Aug 22 16:42 inventorydrwxr-x— 7 oracle oinstall 4096 Aug 22 16:24 javavmdrwxr-x— 4 oracle oinstall 4096 Aug 22 16:31 jdbcdrwxr-x— 7 oracle oinstall 4096 Aug 22 16:32 jdkdrwxr-x— 2 oracle oinstall 4096 Aug 22 16:32 jlibdrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 jredrwxr-x— 13 oracle oinstall 4096 Aug 22 16:33 ldapdrwxr-x— 3 oracle oinstall 12288 Aug 22 16:42 libdrwxr-x–T 3 oracle oinstall 4096 Aug 25 11:24 logdrwxr-x— 6 oracle oinstall 4096 Aug 22 16:24 mddrwxr-x— 2 oracle oinstall 4096 Aug 22 16:25 mesgdrwxr-x— 7 oracle oinstall 4096 Aug 22 16:32 mgwdrwxr-x— 11 oracle oinstall 4096 Aug 22 16:42 networkdrwxr-x— 6 oracle oinstall 4096 Aug 22 16:24 nlsdrwxr-x— 15 oracle oinstall 4096 Aug 22 16:42 oc4jdrwxr-x— 6 oracle oinstall 4096 Aug 22 16:24 odbcdrwxr-x— 5 oracle oinstall 4096 Aug 22 16:24 olapdrwxr-x— 4 oracle oinstall 4096 Aug 22 16:32 OPatchdrwxr-x— 7 oracle oinstall 4096 Aug 22 16:32 opmndrwxr-x— 4 oracle oinstall 4096 Aug 22 16:24 oracore-rw-r–r– 1 oracle oinstall 63 Aug 22 16:22 oraInst.locdrwxr-x— 8 oracle oinstall 4096 Aug 22 16:24 orddrwxr-x— 7 oracle oinstall 4096 Aug 22 16:32 ouidrwxr-x— 4 oracle oinstall 4096 Aug 22 16:24 owmdrwxr-x— 6 oracle oinstall 4096 Aug 22 16:24 perldrwxr-x— 7 oracle oinstall 4096 Aug 22 16:25 plsqldrwxr-x— 7 oracle oinstall 4096 Aug 22 16:24 precompdrwxr-x— 7 oracle oinstall 4096 Aug 22 16:33 racgdrwxr-x— 13 oracle oinstall 4096 Aug 22 16:42 rdbmsdrwxr-x— 4 oracle oinstall 4096 Aug 22 16:31 relnotes-rwxr-xr-x 1 oracle oinstall 9522 Aug 22 16:42 root.sh-rwxr-xr-x 1 oracle oinstall 0 Jun 7 2005 root.sh.olddrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 slaxdrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 sqlj-rw-r—– 1 oracle oinstall 9338 Aug 25 11:42 sqlnet.logdrwxr-x— 9 oracle oinstall 4096 Aug 22 16:33 sqlplusdrwxr-x— 12 oracle oinstall 4096 Aug 22 16:33 srvmdrwxr-x— 12 oracle oinstall 4096 Aug 22 16:33 sysmandrwxr-x— 4 oracle oinstall 4096 Aug 22 16:24 uixdrwxr-x— 3 oracle oinstall 4096 Aug 22 16:24 wwgdrwxr-x— 6 oracle oinstall 4096 Aug 22 16:30 xdkdrwxr—– 3 oracle oinstall 4096 Aug 25 11:25 zlm_ora10g
这次是找不到zlm_ora10g目录，同样的，也mv为bak_ora10g
[oracle@bak db_1]$ mv zlm_ora10g bak_ora10g[oracle@bak db_1]$ emctl status dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://zlm:1158/em/console/aboutApplicationOracle Enterprise Manager 10g is not running. ——————————————————————Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log [oracle@bak j2ee]$ emctl start dbconsole
TZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://zlm:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ……………………………. started. ——————————————————————Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log
无法启动，看到url里的信息是原主机zlm，分析一下提示的错误日志
[oracle@bak j2ee]$ cd /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log
[oracle@bak log]$ lltotal 1656-rw-r—– 1 oracle oinstall 180 Aug 25 11:28 emagentfetchlet.log-rw-r—– 1 oracle oinstall 180 Aug 25 11:28 emagentfetchlet.trc-rw-r—– 1 oracle oinstall 500 Oct 20 11:06 emagent.log-rw-r—– 1 oracle oinstall 42010 Oct 20 11:14 emagent.trc-rw-r—– 1 oracle oinstall 9816 Oct 20 11:05 emdb.nohup-rw-r—– 1 oracle oinstall 4096 Oct 20 11:05 emdb.nohup.lr-rw-r—– 1 oracle oinstall 0 Aug 25 11:25 emdctl.log-rw-r—– 1 oracle oinstall 7330 Oct 20 11:14 emdctl.trc-rw-r—– 1 oracle oinstall 802261 Aug 25 11:45 emoms.log-rw-r—– 1 oracle oinstall 802261 Aug 25 11:45 emoms.trc[oracle@bak log]$ cat emoms.log
2014-08-25 11:26:23,952 [Orion Launcher] WARN jdbc.ConnectionCache _getConnection.303 – Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying2014-08-25 11:26:23,991 [Orion Launcher] WARN jdbc.ConnectionCache _getConnection.306 – Io exception: The Network Adapter could not establish the connectionjava.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:493) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:164) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:767) at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:324) at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:114) at oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection(OracleConnectionCacheImpl.java:694) at oracle.jdbc.pool.OracleConnectionCacheImpl.getPooledConnection(OracleConnectionCacheImpl.java:540) at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:346) at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:324) at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:296) at oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:423) at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:156) at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:605) at oracle.sysman.emSDK.svc.conn.ConnectionService.getRepositoryVersionAndMode(ConnectionService.java:368) at oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepositoryEx(ConnectionService.java:395) at oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepository(ConnectionService.java:450) at oracle.sysman.eml.app.ContextInitializer.contextInitialized(ContextInitializer.java:174) at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:807) at com.evermind.server.http.HttpApplication.(HttpApplication.java:533) at com.evermind.server.Application.getHttpApplication(Application.java:886) at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:688) at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:570) at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:263) at com.evermind.server.http.HttpServer.setSites(HttpServer.java:259) at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:160) at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2330) at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1503) at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:93) at java.lang.Thread.run(Thread.java:534)2014-08-25 11:26:23,999 [Orion Launcher] ERROR conn.ConnectionService verifyRepositoryEx.433 – Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection2014-08-25 11:26:26,673 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.ias.ias.IASIntegration2014-08-25 11:26:27,386 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration2014-08-25 11:26:27,676 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration2014-08-25 11:26:27,915 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg2014-08-25 11:26:27,918 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg2014-08-25 11:26:27,932 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.webdb.admin.em.PortalIntegration2014-08-25 11:26:27,934 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.webdb.admin.em.SSOIntegration2014-08-25 11:26:27,937 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.reports.em.RepIntg2014-08-25 11:26:27,940 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsEmailIntegration2014-08-25 11:26:27,945 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOidIntegration2014-08-25 11:26:27,948 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOvfIntegration2014-08-25 11:26:27,970 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWebconfIntegration2014-08-25 11:26:27,975 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWirelessIntg2014-08-25 11:26:27,978 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsCalGrpIntegration
刷屏了，中间省略相同错误一堆，按Ctrl+C才终止的
2014-08-25 11:29:24,713 [HttpRequestHandler-23603795] ERROR conn.ConnectionService verifyRepositoryEx.433 – Invalid Connection Pool. ERROR = Io exception: The Network Adapt
怀疑是否是因为监听没起来的缘故，先启动监听
[oracle@bak log]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 20-OCT-2014 11:15:26
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused[oracle@bak log]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 20-OCT-2014 11:15:29
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 10.2.0.1.0 – ProductionLog messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bak)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER————————Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 – ProductionStart Date 20-OCT-2014 11:15:29Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.logListening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bak)(PORT=1521)))The listener supports no servicesThe command completed successfully[oracle@bak log]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 20-OCT-2014 11:16:17
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER————————Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 – ProductionStart Date 20-OCT-2014 11:15:29Uptime 0 days 0 hr. 0 min. 48 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.logListening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bak)(PORT=1521)))Services Summary…Service “ora10g” has 1 instance(s). Instance “ora10g”, status READY, has 1 handler(s) for this service…Service “ora10gXDB” has 1 instance(s). Instance “ora10g”, status READY, has 1 handler(s) for this service…Service “ora10g_XPT” has 1 instance(s). Instance “ora10g”, status READY, has 1 handler(s) for this service…The command completed successfully[oracle@bak log]$ emctl status dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://zlm:1158/em/console/aboutApplicationOracle Enterprise Manager 10g is not running. ——————————————————————Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log
显然，EM启动不了不是监听的问题，那么重新配置一下EM是否会有效呢？
[oracle@bak log]$ emca -config dbcontrol db
STARTED EMCA at Oct 20, 2014 11:22:43 AMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information: –注意，此处信息需要手动输入Database SID: ora10gDatabase Control is already configured for the database ora10gYou have chosen to configure Database Control for managing the database ora10gThis will remove the existing configuration and the default settings and perform a fresh configurationDo you wish to continue? [yes(Y)/no(N)]: yListener port number: 1521Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Password for SYSMAN user: oEmail address for notifications (optional): Invalid email.Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): —————————————————————–
You have specified the following settings
Database ORACLE_HOME ……………. /u01/app/oracle/product/10.2.0/db_1
Database hostname ……………. bakListener port number ……………. 1521Database SID ……………. ora10gEmail address for notifications …………… Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–Do you wish to continue? [yes(Y)/no(N)]: yOct 20, 2014 11:24:36 AM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ora10g/emca_2014-10-20_11-22-43-AM.log.Oct 20, 2014 11:24:49 AM oracle.sysman.emcp.util.DBControlUtil stopOMSINFO: Stopping Database Control (this may take a while) …Oct 20, 2014 11:25:53 AM oracle.sysman.emcp.ParamsManager getLocalListenerWARNING: Error retrieving listener for bakOct 20, 2014 11:26:15 AM oracle.sysman.emcp.EMConfig performSEVERE: Cannot start Database Control. The following ports are already in use: [EM agent port:3938].Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ora10g/emca_2014-10-20_11-22-43-AM.log for more details.Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ora10g/emca_2014-10-20_11-22-43-AM.log for more details.[oracle@bak log]$ cat /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ora10g/emca_2014-10-20_11-22-43-AM.log
发现也是一堆报错，其中有一段是这样的，显示地主机命名还是之前旧的信息（原来的主机名为zlm，现在的为bak）：
CONFIG: emdProps: /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/config/emd.properties url: http://zlm:1158/emOct 20, 2014 11:24:49 AM oracle.sysman.emcp.EMDBPreConfig isDBControlSecureCONFIG: isDbcSecure: falseOct 20, 2014 11:24:49 AM oracle.sysman.emcp.ParamsManager setFlagCONFIG: Flag ‘IS_DBCONSOLE_SECURED’ set to falseOct 20, 2014 11:24:49 AM oracle.sysman.emcp.util.DBControlUtil stopOMSINFO: Stopping Database Control (this may take a while) …Oct 20, 2014 11:24:49 AM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArrayCONFIG: New Env List: [DISPLAY=, NEED_EXIT_CODE=1, ORACLE_SID=ora10g, PATH=/usr/sbin:/u01/app/oracle/product/10.2.0/db_1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/mysql/bin:/usr/local/mysql/bin:/home/oracle/bin, TZ=]Oct 20, 2014 11:24:49 AM oracle.sysman.emcp.util.PlatformInterface executeCommandCONFIG: Starting execution: /u01/app/oracle/product/10.2.0/db_1/bin/emctl stop dbconsole Oct 20, 2014 11:25:43 AM oracle.sysman.emcp.util.PlatformInterface executeCommandCONFIG: Exit value of 0Oct 20, 2014 11:25:43 AM oracle.sysman.emcp.util.PlatformInterface executeCommandCONFIG: Execution of /u01/app/oracle/product/10.2.0/db_1/bin/emctl stop dbconsole completed successfullyOct 20, 2014 11:25:43 AM oracle.sysman.emcp.util.PlatformInterface executeCommandCONFIG: TZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://zlm:1158/em/console/aboutApplicationStopping Oracle Enterprise Manager 10g Database Control … … Stopped.
看来仅仅重新配置一下EM资料库是不行的，需要重建一下（先删除，后创建）
[oracle@bak log]$ emca -repos recreate shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directoryError occurred during initialization of VMjava.lang.Error: Properties init: Could not determine current working directory.
该错误表示 getcwd 命令无法定位到当前工作目录。一般来说是因为 cd 到了某个目录之后又rm 了这个目录
这时去执行某些命令就会报 getcwd 错误?，只需要 cd 到任何一个实际存在的目录下在执行命令即可。
出现这种现象的原因还有，当前用户没有当前目录的可执行权限，如没有正确设置ORACLE_SID环境变量，我这里属于这种情况。
[oracle@bak log]$ set ORACLE_SID=ora10g[oracle@bak log]$ emca -repos recreate
STARTED EMCA at Oct 20, 2014 11:49:36 AMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:Database SID: ora10gListener port number: 1521Password for SYS user: Password for SYSMAN user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: yOct 20, 2014 11:49:59 AM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ora10g/emca_2014-10-20_11-49-36-AM.log.Oct 20, 2014 11:50:01 AM oracle.sysman.emcp.EMReposConfig dropRepository –删除INFO: Dropping the EM repository (this may take a while) …Oct 20, 2014 11:54:25 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully droppedOct 20, 2014 11:54:25 AM oracle.sysman.emcp.EMReposConfig createRepository –创建INFO: Creating the EM repository (this may take a while) …Oct 20, 2014 11:59:58 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdEnterprise Manager configuration completed successfullyFINISHED EMCA at Oct 20, 2014 11:59:58 AM
可以看到3个successfully，重建后并把em配置也重新刷了一遍
[oracle@bak log]$ emctl status dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://bak:1158/em/console/aboutApplication –重建EM资料库后，现在的主机名已经更正为“bak”了Oracle Enterprise Manager 10g is not running.
再次重新启动EM
[oracle@bak log]$ emctl start dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://bak:1158/em/console/aboutApplicationAgent Version : 10.1.0.4.1OMS Version : UnknownProtocol Version : 10.1.0.2.0Agent Home : /u01/app/oracle/product/10.2.0/db_1/bak_ora10gAgent binaries : /u01/app/oracle/product/10.2.0/db_1Agent Process ID : 29136Parent Process ID : 28566Agent URL : http://zlm:3938/emd/main –agent还是有原主机残留信息，没有更新，不过不影响登陆EMStarted at : 2014-10-20 11:05:11Started by user : oracleLast Reload : 2014-10-20 11:05:11Last successful upload : (none)Last attempted upload : (none)Total Megabytes of XML files uploaded so far : 0.00Number of XML files pending upload : 40Size of XML files pending upload(MB) : 5.84Available disk space on upload filesystem : 5.14%Agent is already started. Will restart the agent Stopping agent … stopped.Starting Oracle Enterprise Manager 10g Database Control …….. started. ——————————————————————Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log [oracle@bak log]$ emctl status dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://bak:1158/em/console/aboutApplicationOracle Enterprise Manager 10g is running. ——————————————————————Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log [oracle@bak log]$
通过重建EM后，就可以用web浏览器登陆EM管理界面了，新的url为：http://bak:1158/em
总结：
遇到各种原因造成的EM无法登陆的问题，通常是因为旧的EM资料库配置有问题，或者是因为改变了主机或IP地址所造成，可以使用emca -repos recreate重建，就能直接解决问题，仅仅通过emca -config dbconsole db来重新配置是不够彻底的，因为还会有之前错误信息的残留，除了这几个命令外，emca还有很多其他参数，可以通过emca –help查看，这里就不列举了。

喜欢 (0)赏

[搞代码]

分享 (0)