Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

7

主题
1#
发表于 2014-7-30 13:54:13 | 查看: 3816| 回复: 14
环境:Linux 5.2 32 bit, gc 10.2.0.5,repository db 11.1.0.7,agent 10.2.0.5
问题描述:在Oracle Linux 5.2 下通过静默安装gc 10.2.0.1.1版本,然后再升级至10.2.0.5,OMR的数据库版本是11.1.0.7。通过gc添加database报错:404 Not Found Resource /em/database/config/discoveryProgress.jsp/page/internalError not found on this server,oms和oma状态如下:

OMS:
[oracle@ocm2 ~]$ /u01/app/oracle/product/oms10g/bin/emctl status oms all
Oracle Enterprise Manager 10g Release 5 Grid Control  
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
Oracle Management Server is Up.

[oracle@ocm2 ~]$ /u01/app/oracle/product/oms10g/opmn/bin/opmnctl status

Processes in Instance: EnterpriseManager0.ocm2
-------------------+--------------------+---------+---------
ias-component      | process-type       |     pid | status  
-------------------+--------------------+---------+---------
DSA                | DSA                |    6045 | Alive   
HTTP_Server        | HTTP_Server        |    6044 | Alive   
LogLoader          | logloaderd         |    6042 | Alive   
dcm-daemon         | dcm-daemon         |    6047 | Alive   
OC4J               | home               |    6041 | Alive   
OC4J               | OC4J_EMPROV        |    6040 | Alive   
OC4J               | OC4J_EM            |    6046 | Alive   
WebCache           | WebCache           |    6054 | Alive   
WebCache           | WebCacheAdmin      |    6039 | Alive   


OMA:
[oracle@ocm2 ~]$ /u01/app/oracle/product/agent10g/bin/emctl status agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.  
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.5.0
OMS Version       : 10.2.0.5.0
Protocol Version  : 10.2.0.5.0
Agent Home        : /u01/app/oracle/product/agent10g
Agent binaries    : /u01/app/oracle/product/agent10g
Agent Process ID  : 6806
Parent Process ID : 6786
Agent URL         : https://ocm2:3872/emd/main/
Repository URL    : https://ocm2:1159/em/upload
Started at        : 2014-07-30 12:59:31
Started by user   : oracle
Last Reload       : 2014-07-30 12:59:31
Last successful upload                       : 2014-07-30 13:26:29
Total Megabytes of XML files uploaded so far :     2.87
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    12.82%
Last successful heartbeat to OMS             : 2014-07-30 13:26:33
---------------------------------------------------------------
Agent is Running and Ready

附件是OMS和OMA相关日志文件,烦请大师帮忙分析问题,如何进一步解决,感谢!
2#
发表于 2014-7-30 13:56:16
linux 5.2 32 bit gc 10.2.0.5 add database报404错误

gc_error1.jpg (151.17 KB, 下载次数: 467)

gc 10.2.0.5 add database

gc 10.2.0.5 add database

gc_error2.jpg (127.76 KB, 下载次数: 465)

gc 10.2.0.5 add database

gc 10.2.0.5 add database

gc_error3.jpg (63.09 KB, 下载次数: 475)

gc 10.2.0.5 add database

gc 10.2.0.5 add database

OMS_OMA.rar

164.59 KB, 下载次数: 1668

OMS/OMA log日志和配置文件

回复 只看该作者 道具 举报

3#
发表于 2014-7-30 14:06:57
2014-07-30 13:01:40,360 [AJPRequestHandler-ApplicationServerThread-12] WARN  jdbc.ConnectionCache _getConnection.353 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
2014-07-30 13:01:40,362 [AJPRequestHandler-ApplicationServerThread-12] ERROR conn.ConnectionService verifyRepositoryEx.911 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection
2014-07-30 13:01:44,534 [AJPRequestHandler-ApplicationServerThread-7] ERROR conn.ConnectionService verifyRepositoryEx.911 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm2)(PORT=1521)))(CONNECT_DATA=(SID=EMREP)))

2014-07-30 13:01:52,270 [AJPRequestHandler-ApplicationServerThread-15] ERROR conn.ConnectionService verifyRepositoryEx.911 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm2)(PORT=1521)))(CONNECT_DATA=(SID=EMREP)))

2014-07-30 13:01:58,147 [AJPRequestHandler-ApplicationServerThread-11] ERROR conn.ConnectionService verifyRepositoryEx.911 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm2)(PORT=1521)))(CONNECT_DATA=(SID=EMREP)))

2014-07-30 13:05:03,195 [JobWorker 2054:Thread-22] ERROR em.jobs executeCommand.216 - OpatchUpdateLatest: Oracle MetaLink credentials are incorrect or missing. Access Patching Setup to set required parameters.
2014-07-30 13:05:03,215 [JobWorker 2715:Thread-21] ERROR em.jobs executeCommand.369 - UpdateARUTables: My Oracle Support credentials are incorrect or missing. Click Patching Setup to set required parameters.
2014-07-30 13:05:05,991 [JobWorker 2744:Thread-20] ERROR em.provision checkAllSoftwareLibLocs.210 - AdminUtil:checkAllSoftwareLibLocs: No software library locations configured.
2014-07-30 13:05:06,414 [JobWorker 2744:Thread-20] ERROR gcconfig.jobs executeCommand.248 - component exception while getting OMS data
oracle.sysman.emgc.provision.component.ComponentException: Software Library location is not configured.
        at oracle.sysman.emgc.provision.ui.model.admin.AdminUtil.checkAllSoftwareLibLocs(AdminUtil.java:212)
        at oracle.sysman.emgc.provision.ui.model.admin.AdminUtil.checkAllSoftwareLibLocs(AdminUtil.java:143)
        at oracle.sysman.pp.gcconfig.jobs.commands.SWLibInfoCollectionCommand.executeCommand(SWLibInfoCollectionCommand.java:169)
        at oracle.sysman.emdrep.jobs.BaseJobWorker.runStep(BaseJobWorker.java:614)
        at oracle.sysman.emdrep.jobs.BaseJobWorker.doOneOperation(BaseJobWorker.java:738)
        at oracle.sysman.emdrep.jobs.JobWorker.doOneOperation(JobWorker.java:306)
        at oracle.sysman.emdrep.jobs.JobWorker.run(JobWorker.java:288)
        at oracle.sysman.util.threadPoolManager.WorkerThread.run(Worker.java:261)
2014-07-30 13:05:18,066 [EMUI_13_05_16_/console/net/lsnr/home] WARN  pref.SubtabPref getFolders.710 - Unknown folder id: VirtualServers retrieved from repository
2014-07-30 13:05:18,081 [EMUI_13_05_16_/console/net/lsnr/home] ERROR svlt.PageHandler handleRequest.640 - javax.servlet.ServletException: java.lang.ClassNotFoundException: _net._lsnr._home
javax.servlet.ServletException: java.lang.ClassNotFoundException: _net._lsnr._home
        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:329)
        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:230)
        at oracle.sysman.emSDK.svlt.PageHandler.render(PageHandler.java:1114)
        at oracle.sysman.emSDK.svlt.PageHandler.myRender(PageHandler.java:1174)
        at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:598)
        at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:777)
        at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:328)
        at oracle.sysman.eml.app.Console.doGet(Console.java:304)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
        at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:265)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
        at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:369)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:670)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
        at java.lang.Thread.run(Thread.java:534)
2014-07-30 13:05:41,981 [EMUI_13_05_41_/console/database/config] ERROR svlt.PageHandler handleRequest.640 - javax.servlet.ServletException: java.lang.ClassNotFoundException: _database._config._discoveryProgress
javax.servlet.ServletException: java.lang.ClassNotFoundException: _database._config._discoveryProgress
        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:329)
        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:230)
        at oracle.sysman.emSDK.svlt.PageHandler.render(PageHandler.java:1114)
        at oracle.sysman.emSDK.svlt.PageHandler.myRender(PageHandler.java:1174)
        at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:598)
        at oracle.sysman.db.adm.RootController.handleRequest(RootController.java:247)
        at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:777)
        at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:328)
        at oracle.sysman.eml.app.Console.doGet(Console.java:304)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
        at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:265)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
        at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:369)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:670)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
        at java.lang.Thread.run(Thread.java:534)
2014-07-30 13:07:17,101 [Thread-36] WARN  emd.targets setContents.92 - ShortName ShortName Average Synchronous Single-Block Read Latency (ms) very long. Has been truncated.
2014-07-30 13:07:17,458 [Thread-36] WARN  emd.targets setContents.101 - Label Age of the first message in persistent queue per subscriber (seconds)  very long. Has been truncated.
2014-07-30 13:19:08,926 [EMUI_13_19_08_/console/targets] WARN  pref.SubtabPref getFolders.710 - Unknown folder id: VirtualServers retrieved from repository
2014-07-30 13:19:54,361 [EMUI_13_19_54_/console/database/config] ERROR svlt.PageHandler handleRequest.640 - javax.servlet.ServletException: java.lang.ClassNotFoundException: _database._config._discoveryProgress
javax.servlet.ServletException: java.lang.ClassNotFoundException: _database._config._discoveryProgress
        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:329)
        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:230)
        at oracle.sysman.emSDK.svlt.PageHandler.render(PageHandler.java:1114)
        at oracle.sysman.emSDK.svlt.PageHandler.myRender(PageHandler.java:1174)
        at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:598)
        at oracle.sysman.db.adm.RootController.handleRequest(RootController.java:247)
        at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:777)
        at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:328)
        at oracle.sysman.eml.app.Console.doGet(Console.java:304)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
        at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:265)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
        at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:369)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:670)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
        at java.lang.Thread.run(Thread.java:534)
2014-07-30 13:20:20,904 [Thread-38] WARN  emd.targets setContents.92 - ShortName ShortName Average Synchronous Single-Block Read Latency (ms) very long. Has been truncated.
2014-07-30 13:20:21,133 [Thread-38] WARN  emd.targets setContents.101 - Label Age of the first message in persistent queue per subscriber (seconds)  very long. Has been truncated.



回复 只看该作者 道具 举报

4#
发表于 2014-7-30 14:07:21
2014-07-30 13:01:44,534 [AJPRequestHandler-ApplicationServerThread-7] ERROR conn.ConnectionService verifyRepositoryEx.911 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:



这个EMREP的状态似乎并不正常啊

回复 只看该作者 道具 举报

5#
发表于 2014-7-30 14:34:31
emrep,库是open的,作为repository 11.1.0.7,监听也是启动的

回复 只看该作者 道具 举报

6#
发表于 2014-7-30 14:35:00
Maclean Liu(刘相兵 发表于 2014-7-30 14:07
2014-07-30 13:01:44,534 [AJPRequestHandler-ApplicationServerThread-7] ERROR conn.ConnectionService v ...

EMREP库是open的,作为repository 11.1.0.7,监听也是启动的

回复 只看该作者 道具 举报

7#
发表于 2014-7-30 14:38:44
[oracle@ocm2 ~]$ which lsnrctl
/u01/app/oracle/product/11.1.0/db_1/bin/lsnrctl
[oracle@ocm2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 30-JUL-2014 14:37:40

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                30-JUL-2014 13:01:43
Uptime                    0 days 1 hr. 35 min. 56 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ocm2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm2)(PORT=1521)))
Services Summary...
Service "EMREP" has 1 instance(s).
  Instance "EMREP", status READY, has 1 handler(s) for this service...
Service "EMREP_XPT" has 1 instance(s).
  Instance "EMREP", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@ocm2 ~]$ which sqlplus
/u01/app/oracle/product/11.1.0/db_1/bin/sqlplus
[oracle@ocm2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Jul 30 14:37:55 2014

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
EMREP            OPEN

回复 只看该作者 道具 举报

8#
发表于 2014-7-30 14:39:55
[oracle@ocm2 ~]$ more /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EMREP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ocm2)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EMREP)
    )
  )

[oracle@ocm2 ~]$ more /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ocm2)(PORT = 1521))
    )
  )

回复 只看该作者 道具 举报

9#
发表于 2014-7-30 15:11:29
Start Date                30-JUL-2014 13:01:43
Uptime                    0 days 1 hr. 35 min. 56 sec


2014-07-30 13:01:44,534 [AJPRequestHandler-ApplicationServerThread-7] ERROR conn.ConnectionService verifyRepositoryEx.911 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm2)(PORT=1521)))(CONNECT_DATA=(SID=EMREP)))


监听的启动时间和 报错时间很接近,你现在重试下还报错吗?

回复 只看该作者 道具 举报

10#
发表于 2014-7-31 09:21:55
Maclean Liu(刘相兵 发表于 2014-7-30 15:11
Start Date                30-JUL-2014 13:01:43
Uptime                    0 days 1 hr. 35 min. 56 sec ...

oms oma omr listener都重启了,日志请看附件

回复 只看该作者 道具 举报

11#
发表于 2014-7-31 09:22:52
OMA、OMS log日志

oma_oms_log.rar

182.89 KB, 下载次数: 1512

回复 只看该作者 道具 举报

12#
发表于 2014-7-31 09:24:10
Maclean Liu(刘相兵 发表于 2014-7-30 15:11
Start Date                30-JUL-2014 13:01:43
Uptime                    0 days 1 hr. 35 min. 56 sec ...

2014-07-31 09:12:12,176 [Thread-42] WARN  emd.targets setContents.92 - ShortName ShortName Average Synchronous Single-Block Read Latency (ms) very long. Has been truncated.
2014-07-31 09:12:12,382 [Thread-42] WARN  emd.targets setContents.101 - Label Age of the first message in persistent queue per subscriber (seconds)  very long. Has been truncated.
2014-07-31 09:12:22,610 [EMUI_09_12_22_/console/database/config] ERROR svlt.PageHandler handleRequest.640 - javax.servlet.ServletException: java.lang.ClassNotFoundException: _database._config._discoveryProgress
javax.servlet.ServletException: java.lang.ClassNotFoundException: _database._config._discoveryProgress
        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:329)
        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:230)
        at oracle.sysman.emSDK.svlt.PageHandler.render(PageHandler.java:1114)
        at oracle.sysman.emSDK.svlt.PageHandler.myRender(PageHandler.java:1174)
        at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:598)
        at oracle.sysman.db.adm.RootController.handleRequest(RootController.java:247)
        at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:777)
        at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:328)
        at oracle.sysman.eml.app.Console.doGet(Console.java:304)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
        at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:265)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
        at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:369)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:670)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
        at java.lang.Thread.run(Thread.java:534)
2014-07-31 09:12:28,870 [Thread-44] WARN  emd.targets setContents.92 - ShortName ShortName Average Synchronous Single-Block Read Latency (ms) very long. Has been truncated.
2014-07-31 09:12:29,027 [Thread-44] WARN  emd.targets setContents.101 - Label Age of the first message in persistent queue per subscriber (seconds)  very long. Has been truncated.
2014-07-31 09:12:39,764 [EMUI_09_12_39_/console/database/config] ERROR svlt.PageHandler handleRequest.640 - javax.servlet.ServletException: java.lang.ClassNotFoundException: _database._config._discoveryProgress
javax.servlet.ServletException: java.lang.ClassNotFoundException: _database._config._discoveryProgress
        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:329)
        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:230)
        at oracle.sysman.emSDK.svlt.PageHandler.render(PageHandler.java:1114)
        at oracle.sysman.emSDK.svlt.PageHandler.myRender(PageHandler.java:1174)
        at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:598)
        at oracle.sysman.db.adm.RootController.handleRequest(RootController.java:247)
        at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:777)
        at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:328)
        at oracle.sysman.eml.app.Console.doGet(Console.java:304)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
        at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:265)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
        at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
        at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:369)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:670)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
        at java.lang.Thread.run(Thread.java:534)
2014-07-31 09:12:45,756 [Thread-46] WARN  emd.targets setContents.92 - ShortName ShortName Average Synchronous Single-Block Read Latency (ms) very long. Has been truncated.
2014-07-31 09:12:45,966 [Thread-46] WARN  emd.targets setContents.101 - Label Age of the first message in persistent queue per subscriber (seconds)  very long. Has been truncated.
2014-07-31 09:14:07,168 [EMUI_09_14_06_/console/net/lsnr/home] WARN  pref.SubtabPref getFolders.710 - Unknown folder id: VirtualServers retrieved from repository
2014-07-31 09:14:07,174 [EMUI_09_14_06_/console/net/lsnr/home] ERROR svlt.PageHandler handleRequest.640 - javax.servlet.ServletException: java.lang.ClassNotFoundException: _net._lsnr._home
javax.servlet.ServletException: java.lang.ClassNotFoundException: _net._lsnr._home
        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:329)
        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)

回复 只看该作者 道具 举报

13#
发表于 2014-8-5 22:19:32
help~~~~~~~

回复 只看该作者 道具 举报

14#
发表于 2014-8-6 10:35:01
你后续没有再描述过症状,我们不知道后续的实际情况。

查了mos没有找到类似案例, 怀疑和rep db配置或target配置有关。

你可以尝试 再加一个没有什么配置的target尝试。

需要整体诊断。例如target的状态等

回复 只看该作者 道具 举报

15#
发表于 2014-8-19 22:47:53
感谢回复,32位的gc,装了两三遍,都有这个错,换成64bit的,gc 10.2.0.3-》》10.2.0.5成功了

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-21 02:07 , Processed in 0.056404 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569