当前位置:  数据库>oracle

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

    来源: 互联网  发布时间:2017-06-11

    本文导语:   TZ set to PRC [oracle@bak j2ee]$ ll drwxr-x--- 15 oracle oinstall 4096 Aug 22 16:29 home drwxr-x---  5 oracle oinstall 4096 Aug 22 16:24 OC4J_DBConsole 既然提示文件找不到,很显然是因为主机名变更的缘故,那么把名字变一下,用mv命令 [oracle@bak j2ee]$ ll drwxr-x-...

之前在自己的测试环境上做了个异机恢复,原来的库上是配置过EM的,但是在恢复的库上去启动EM就报错了,下面看具体解决过程:
PS:原主机名为zlm,恢复出来的主机名为bak
 
[root@bak ~]# su - Oracle
[oracle@bak ~]$ 
TZ set to PRC
OC4J Configuration issue. /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/ not found. 
[oracle@bak ~]$ cd /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/
[oracle@bak j2ee]$ ll
total 24
-rw-r--r--  1 oracle oinstall  256 Aug 22 16:42 deploy_db.ini
drwxr-x--- 15 oracle oinstall 4096 Aug 22 16:29 home
drwxr-x---  9 oracle oinstall 4096 Aug 22 16:24 isqlplus
drwxr-x---  3 oracle oinstall 4096 Aug 22 16:24 oc4j_applications
drwxr-x---  5 oracle oinstall 4096 Aug 22 16:24 OC4J_DBConsole
 
既然提示文件找不到,很显然是因为主机名变更的缘故,那么把名字变一下,用mv命令
 
[oracle@bak j2ee]$ 
[oracle@bak j2ee]$ ll
total 24
-rw-r--r--  1 oracle oinstall  256 Aug 22 16:42 deploy_db.ini
drwxr-x--- 15 oracle oinstall 4096 Aug 22 16:29 home
drwxr-x---  9 oracle oinstall 4096 Aug 22 16:24 isqlplus
drwxr-x---  3 oracle oinstall 4096 Aug 22 16:24 oc4j_applications
drwxr-x---  5 oracle oinstall 4096 Aug 22 16:24 OC4J_DBConsole
drwxr-x---  7 oracle oinstall 4096 Oct 20 10:58 OC4J_DBConsole_bak_ora10g
[oracle@bak j2ee]$ 
TZ set to PRC
EM Configuration issue. /u01/app/oracle/product/10.2.0/db_1/ not found. 
[oracle@bak j2ee]$ cd /u01/app/oracle/product/10.2.0/db_1/
[oracle@bak db_1]$ ll
total 260
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:24 assistants
drwxr-xr-x  2 oracle oinstall 12288 Aug 22 16:42 bin
drwxr-x---  3 oracle oinstall  4096 Aug 22 16:33 cdata
drwxr-x---  6 oracle oinstall  4096 Aug 25 11:08 cfgtoollogs
drwxr-x---  4 oracle oinstall  4096 Aug 22 16:24 clone
drwxr-x---  2 oracle oinstall  4096 Aug 22 16:33 config
drwxr-x---  6 oracle oinstall  4096 Aug 22 16:24 crs
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:33 css
drwxr-x--- 10 oracle oinstall  4096 Aug 22 16:33 ctx
drwxr-x---  2 oracle oinstall  4096 Oct 20 09:17 dbs
drwxr-x---  3 oracle oinstall  4096 Aug 22 16:24 demo
drwxr-x---  3 oracle oinstall  4096 Aug 22 16:24 diagnostics
drwxr-x---  3 oracle oinstall  4096 Aug 22 16:24 has
drwxr-x---  6 oracle oinstall  4096 Aug 22 16:42 hs
drwxr-x---  5 oracle oinstall  4096 Aug 25 11:27 install
-rw-r-----  1 oracle oinstall    37 Aug 22 16:24 install.platform
drwxr-x--- 12 oracle oinstall  4096 Aug 22 16:42 inventory
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:24 javavm
drwxr-x---  4 oracle oinstall  4096 Aug 22 16:31 jdbc
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:32 jdk
drwxr-x---  2 oracle oinstall  4096 Aug 22 16:32 jlib
drwxr-x---  3 oracle oinstall  4096 Aug 22 16:24 jre
drwxr-x--- 13 oracle oinstall  4096 Aug 22 16:33 ldap
drwxr-x---  3 oracle oinstall 12288 Aug 22 16:42 lib
drwxr-x--T  3 oracle oinstall  4096 Aug 25 11:24 log
drwxr-x---  6 oracle oinstall  4096 Aug 22 16:24 md
drwxr-x---  2 oracle oinstall  4096 Aug 22 16:25 mesg
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:32 mgw
drwxr-x--- 11 oracle oinstall  4096 Aug 22 16:42 network
drwxr-x---  6 oracle oinstall  4096 Aug 22 16:24 nls
drwxr-x--- 15 oracle oinstall  4096 Aug 22 16:42 oc4j
drwxr-x---  6 oracle oinstall  4096 Aug 22 16:24 odbc
drwxr-x---  5 oracle oinstall  4096 Aug 22 16:24 olap
drwxr-x---  4 oracle oinstall  4096 Aug 22 16:32 OPatch
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:32 opmn
drwxr-x---  4 oracle oinstall  4096 Aug 22 16:24 oracore
-rw-r--r--  1 oracle oinstall    63 Aug 22 16:22 oraInst.loc
drwxr-x---  8 oracle oinstall  4096 Aug 22 16:24 ord
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:32 oui
drwxr-x---  4 oracle oinstall  4096 Aug 22 16:24 owm
drwxr-x---  6 oracle oinstall  4096 Aug 22 16:24 perl
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:25 plsql
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:24 precomp
drwxr-x---  7 oracle oinstall  4096 Aug 22 16:33 racg
drwxr-x--- 13 oracle oinstall  4096 Aug 22 16:42 rdbms
drwxr-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.old
drwxr-x---  3 oracle oinstall  4096 Aug 22 16:24 slax
drwxr-x---  3 oracle oinstall  4096 Aug 22 16:24 sqlj
-rw-r-----  1 oracle oinstall  9338 Aug 25 11:42 sqlnet.log
drwxr-x---  9 oracle oinstall  4096 Aug 22 16:33 sqlplus
drwxr-x--- 12 oracle oinstall  4096 Aug 22 16:33 srvm
drwxr-x--- 12 oracle oinstall  4096 Aug 22 16:33 sysman
drwxr-x---  4 oracle oinstall  4096 Aug 22 16:24 uix
drwxr-x---  3 oracle oinstall  4096 Aug 22 16:24 wwg
drwxr-x---  6 oracle oinstall  4096 Aug 22 16:30 xdk
 
这次是找不到zlm_ora10g目录,同样的,也mv为bak_ora10g
 
[oracle@bak db_1]$ 
[oracle@bak db_1]$ 
TZ set to PRC
Oracle 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/aboutApplication
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log 
[oracle@bak j2ee]$ 
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Starting Oracle Enterprise Manager 10g Database Control .................................. started. 
------------------------------------------------------------------
 
无法启动,看到url里的信息是原主机zlm,分析一下提示的错误日志
 
[oracle@bak j2ee]$ cd /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log
[oracle@bak log]$ ll
total 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.trc
[oracle@bak log]$ 
2014-08-25 11:26:23,952 [Orion Launcher] 
2014-08-25 11:26:23,991 [Orion Launcher] 
java.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 connection
2014-08-25 11:26:26,673 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ias.ias.IASIntegration
2014-08-25 11:26:27,386 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration
2014-08-25 11:26:27,676 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration
2014-08-25 11:26:27,915 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg
2014-08-25 11:26:27,918 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg
2014-08-25 11:26:27,932 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.webdb.admin.em.PortalIntegration
2014-08-25 11:26:27,934 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.webdb.admin.em.SSOIntegration
2014-08-25 11:26:27,937 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.reports.em.RepIntg
2014-08-25 11:26:27,940 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsEmailIntegration
2014-08-25 11:26:27,945 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOidIntegration
2014-08-25 11:26:27,948 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOvfIntegration
2014-08-25 11:26:27,970 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWebconfIntegration
2014-08-25 11:26:27,975 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.271 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWirelessIntg
2014-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. 
 
怀疑是否是因为监听没起来的缘故,先启动监听
 
[oracle@bak log]$ 
 
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))
[oracle@bak log]$ 
 
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 - Production
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bak)(PORT=1521)))
 
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                20-OCT-2014 11:15:29
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bak)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@bak log]$ 
 
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                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                20-OCT-2014 11:15:29
Uptime                    0 days 0 hr. 0 min. 48 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bak)(PORT=1521)))
Services Summary...
 has 1 instance(s).
  ", 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]$ 
TZ set to PRC
Oracle 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/aboutApplication
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/bak_ora10g/sysman/log 
 
显然,EM启动不了不是监听的问题,那么重新配置一下EM是否会有效呢?
 
[oracle@bak log]$ 
 
STARTED EMCA at Oct 20, 2014 11:22:43 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Enter the following information:   
Database Control is already configured for the database ora10g
You have chosen to configure Database Control for managing the database ora10g
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: 1521
Password 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 ................ bak
Listener port number ................ 1521
Database SID ................ ora10g
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 
 
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2014 11:24:36 AM 
INFO: 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 
INFO: Stopping Database Control (this may take a while) ...
Oct 20, 2014 11:25:53 AM 
Oct 20, 2014 11:26:15 AM 
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
 
发现也是一堆报错,其中有一段是这样的,显示地主机命名还是之前旧的信息():
 
CONFIG: emdProps: /u01/app/oracle/product/10.2.0/db_1/
Oct 20, 2014 11:24:49 AM oracle.sysman.emcp.EMDBPreConfig isDBControlSecure
CONFIG:  isDbcSecure: false
Oct 20, 2014 11:24:49 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_DBCONSOLE_SECURED' set to false
Oct 20, 2014 11:24:49 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Oct 20, 2014 11:24:49 AM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
CONFIG: 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 executeCommand
CONFIG: 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 executeCommand
CONFIG: Exit value of 0
Oct 20, 2014 11:25:43 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Execution of /u01/app/oracle/product/10.2.0/db_1/bin/emctl stop dbconsole  completed successfully
Oct 20, 2014 11:25:43 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Stopping Oracle Enterprise Manager 10g Database Control ... 
 ...  Stopped. 
 
看来仅仅重新配置一下EM资料库是不行的,需要重建一下(先删除,后创建)
 
[oracle@bak log]$ 
shell-init: error retrieving current directory: 
java.lang.Error: Properties init: Could not determine current working directory.
 
该错误表示 getcwd 命令无法定位到当前工作目录。一般来说是因为 cd 到了某个目录之后又rm 了这个目录
这时去执行某些命令就会报 getcwd 错误​,只需要 cd 到任何一个实际存在的目录下在执行命令即可。
出现这种现象的原因还有,当前用户没有当前目录的可执行权限,如没有正确设置ORACLE_SID环境变量,我这里属于这种情况。
 
[oracle@bak log]$ 
[oracle@bak log]$ 
 
STARTED EMCA at Oct 20, 2014 11:49:36 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Enter the following information:
Database SID: ora10g
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  
Password for SYSMAN user:  
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2014 11:49:59 AM 
INFO: 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    
INFO: Dropping the EM repository (this may take a while) ...
Oct 20, 2014 11:54:25 AM oracle.sysman.emcp.EMReposConfig invoke
Oct 20, 2014 11:54:25 AM    
INFO: Creating the EM repository (this may take a while) ...
Oct 20, 2014 11:59:58 AM oracle.sysman.emcp.EMReposConfig invoke
FINISHED EMCA at Oct 20, 2014 11:59:58 AM
 
可以看到3个successfully,重建后并把em配置也重新刷了一遍
 
[oracle@bak log]$ 
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
   
 
再次重新启动EM
 
[oracle@bak log]$ 
TZ set to PRC
Oracle 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
Agent Version     : 10.1.0.4.1
OMS Version       : Unknown
Protocol Version  : 10.1.0.2.0
Agent Home        : /u01/app/oracle/product/10.2.0/db_1/bak_ora10g
Agent binaries    : /u01/app/oracle/product/10.2.0/db_1
Agent Process ID  : 29136
Parent Process ID : 28566
Started at        : 2014-10-20 11:05:11
Started by user   : oracle
Last Reload       : 2014-10-20 11:05:11
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far :     0.00
Number of XML files pending upload           :       40
Size of XML files pending upload(MB)         :     5.84
Available 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 dbconsole
TZ set to PRC
Oracle 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
------------------------------------------------------------------
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为:
 
总结:
 
遇到各种原因造成的EM无法登陆的问题,通常是因为旧的EM资料库配置有问题,或者是因为改变了主机或IP地址所造成,可以使用emca -repos recreate重建,就能直接解决问题,仅仅通过emca -config dbconsole db来重新配置是不够彻底的,因为还会有之前错误信息的残留,除了这几个命令外,emca还有很多其他参数,可以通过emca --help查看,这里就不列举了。

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2


    
 
 

您可能感兴趣的文章:

  • 关于oracle816数据库启动故障问题
  • Linux下Oracle RAC一个节点宕机导致共享存储无法挂载的故障排除
  • Oracle 11G 无法连接到数据库实例故障排除
  • 一次Oracle故障处理过程
  • Oracle数据库系统紧急故障处理方法
  • Oracle数据库恢复后心得
  • 关于系统重装后Oracle数据库完全恢复的解决办法
  • oracle drop table(表)数据恢复方法
  • Oracle数据库备份和恢复工具 RMan
  • oracle备份恢复的具体方法
  • oracle中误删除表后恢复语句(FLASHBACK)
  • oracle冷备份恢复和oracle异机恢复使用方法
  • 在Oracle 10gR2中设定指定的恢复点实现轻松闪回
  • Oracle重做日志文件损坏或丢失后的恢复
  • Oracle11g备份和恢复功能的提高
  • 实战Oracle数据库备份与恢复
  • Oracle数据库冷备份的异地恢复
  • oracle下实现恢复一个丢失的数据文件的代码
  • 详解通过Backup Exec来实施Oracle灾难恢复
  • Oracle的恢复管理器及DBMS_JOB包分析
  • Oracle数据库文件恢复以及备份思路
  • Oracle数据库备份恢复最佳实践
  • oracle如何恢复被覆盖的存储过程
  • rman恢复方案和oracle异机恢复
  • oracle数据库创建备份与恢复脚本整理
  •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • 修改oracle用户的.bash_profile之后无法正常登陆
  • 安装oracle9时,安装界面的字体无法正确显示,怎么解决啊???
  • 64位win7下pl/sql无法连接oracle解决方法
  • 安装oracle9的时候字符无法显示??
  • Linux下Oracle数据库,dbstart持续不动,数据库无法启动解决
  • linux新建oracle用户无法登陆系统 大家帮帮忙
  • 解决Linux下Oracle无法关闭数据库的问题
  • AS3安装Oracle 9.2.0前,打补丁出错,导致系统无法引导.大侠们帮忙
  • oracle9i安装时.installer启动后,界面无法显示中文.
  • Oracle数据库无法加载_OraMTS_的解决方法
  • 我想配一个编程平台windowsXP+VisualStudio.net或者+Jbuilder,或Linux+oracle,用来做开发,我的电脑已经远远无法满足其要求,,不值
  • oracle修改SGA后无法启动问题分析及解决方法
  • Oracle用户密码含有特殊字符导致无法登陆解决方法
  • 关于Oracle启动无法启动netmgr问题的解决
  • Oracle 10g的DBA无法登录解决方案
  • 修改计算机名或IP后Oracle10g服务无法启动的解决方法
  • oracle 9i Linux 下安装时出现 无法建立inventory目录,你可能没有相应权限,请高手帮忙,100分,在线等!
  • PDO取Oracle lob大字段,当数据量太大无法取出的问题的解决办法
  • VM6系统linuxAS5,未装VM tools, 无法安装oracle10g
  • 红旗Asianux3下Oracle 10g无法启动解决
  • Oracle 12c发布简单介绍及官方下载地址
  • 在linux下安装oracle,如何设置让oracle自动启动!也就是让oracle那个服务自动启动,不是手动的
  • oracle 11g最新版官方下载地址
  • 请问su oracle 和su - oracle有什么不同?
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • 虚拟机装Oracle R12与Oracle10g
  • Oracle数据库(Oracle Database)体系结构及基本组成介绍
  • Oracle 数据库开发工具 Oracle SQL Developer
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • Oracle EBS R12 支持 Oracle Database 11g
  • Oracle 10g和Oracle 11g网格技术介绍


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,