求助CentOS 5.4 +oracle 11g R2 ASM 模式 安装后 EM 启动后登陆不进去!
按照安装文档,正常安装后,em 画面也有就是报网页错误,数据库正常,grid 用户tnsping 数据库SID出错,
[grid@oracle11g ~]$ tnsping query
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 19-APR-2010 08:47:07
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/grid/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=125.211.213.133)(PORT=1521)))
[grid@oracle11g ~]$ tnsping query
tnsping 主机名正常
[grid@oracle11g ~]$ tnsping oracle11g
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 19-APR-2010 08:47:53
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/grid/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.240.3.156)(PORT=1521)))
OK (10 msec)
https://host IP :1158/em
在IE状态栏下有网页错误,然后就进不去了。
emctl 启动的日志
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=query)))
2010-04-16 16:00:28,224 [SeverityLoad https://oracle11g:3938/emd/main] ERROR eml.XMLLoader markFileAsError.858 - Error repeated 4 times: ERROR-400|Listener refused the connection with the foll
owing error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=query)))
with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=query)))
2010-04-16 16:00:47,511 [OmsServiceDriver thread] ERROR em.failover mainTask.457 - java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=query)))
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=query)))
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:73)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:503)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:436)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:621)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:492)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:386)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:276)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:212)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:140)
at oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1752)
at oracle.jdbc.pool.OracleImplicitConnectionCache.makeOneConnection(OracleImplicitConnectionCache.java:644)
at oracle.jdbc.pool.OracleImplicitConnectionCache.getCacheConnection(OracleImplicitConnectionCache.java:592)
at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:460)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:544)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:480)
at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:336)
at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:322)
at oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:575)
at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:207)
at oracle.sysman.emSDK.svc.conn.ConnectionService.getSystemConnection(ConnectionService.java:1383)
at oracle.sysman.emdrep.omsservice.OmsServiceDriver.getConnection(OmsServiceDriver.java8)
at oracle.sysman.emdrep.failover.OMSHeartbeatRecorder.getConnection(OMSHeartbeatRecorder.java:111)
at oracle.sysman.emdrep.failover.OMSHeartbeatRecorder.heartbeat(OMSHeartbeatRecorder.java:265)
at oracle.sysman.emdrep.failover.OMSHeartbeatRecorder.mainTask(OMSHeartbeatRecorder.java:453)
at oracle.sysman.emdrep.omsservice.OmsServiceDriver.run(OmsServiceDriver.java:163)
2010-04-16 16:00:47,518 [OmsServiceDriver thread] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = Listener refused the connection with the following erro
r:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=query)))
2010-04-16 16:00:47,519 [OmsServiceDriver thread] ERROR em.jobs die.1608 - Dispatcher: causing a restart
2010-04-16 16:00:47,519 [OmsServiceDriver thread] ERROR emd.main restart.425 - HealthMonitor Apr 16, 2010 4:00:47 PM Job Dispatcher error: Could not get connection
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=query)))
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:73)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:503)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:436)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:621)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:492)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:386)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:276)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:212)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:140)
at oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1752)
at oracle.jdbc.pool.OracleImplicitConnectionCache.makeOneConnection(OracleImplicitConnectionCache.java:644)
at oracle.jdbc.pool.OracleImplicitConnectionCache.getCacheConnection(OracleImplicitConnectionCache.java:592)
at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:460)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:544)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:480)
at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:336)
at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:322)
at oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:575)
at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:207)
at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1138)
at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1172)
at oracle.sysman.eml.app.SessionObjectManager.sessionDestroyed(SessionObjectManager.java:116)
at oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:126)
at com.evermind.server.http.HttpApplication.invalidateSession(HttpApplication.java60)
at com.evermind.server.http.EvermindHttpSession.invalidate(EvermindHttpSession.java:397)
at com.evermind.server.http.EvermindHttpSession.isInvalid(EvermindHttpSession.java:305)
at com.evermind.server.http.EvermindHttpSession.getServletContext(EvermindHttpSession.java:982)
at oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:90)
at com.evermind.server.http.HttpApplication.invalidateLocalSession(HttpApplication.java:900)
at com.evermind.server.http.EvermindHttpSession.invalidateLocal(EvermindHttpSession.java:346)
at com.evermind.server.http.HttpApplication.destroySessions(HttpApplication.java:5918)
at com.evermind.server.http.HttpApplication.destroy(HttpApplication.java:5860)
at com.evermind.server.http.HttpSite.destroy(HttpSite.java75)
at com.evermind.server.http.HttpServer.destroy(HttpServer.java:548)
at com.evermind.server.ApplicationServer.destroy(ApplicationServer.java:2074)
at com.evermind.server.ApplicationServerShutdownHandler.run(ApplicationServerShutdownHandler.java:93)
at java.lang.Thread.run(Thread.java:595)
2010-04-16 16:17:21,454 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.pp.paf.sample.ui.intg.PAFDemoIntegration
2010-04-16 16:17:25,365 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.pp.sidb.ui.intg.SIDBProvisioningIntegration
2010-04-16 16:17:25,643 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.pp.racprov.ui.intg.RACProvIntegration
2010-04-16 16:17:25,645 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.pp.ec.ui.intg.ExtendClusterIntegration
2010-04-16 16:17:25,647 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.pp.dn.ui.intg.DltNodeIntegration
2010-04-16 16:17:25,649 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.pp.common.ui.intg.ProvCommonIntegration
2010-04-16 16:17:25,651 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.pp.bpelprov.ui.intg.BPELProvisioningIntegration
2010-04-16 16:17:25,758 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.emCLI.CLIIntg
2010-04-16 16:17:25,760 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.emCLI.CLIDownloadIntg
2010-04-16 16:17:25,762 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.pp.asprov.ui.intg.ASProvisioningIntegration
2010-04-16 16:17:27,591 [OC4J Launcher] ERROR app.ContextInitializer contextInitialized.420 - Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration
2010-04-16 16:18:11,656 [XMLLoader0 00000000015.xml] ERROR eml.XMLLoader LoadFiles.696 - Error while processing 00000000015.xml:
java.sql.SQLException: ORA-20101: Metric PhysAddress for target type netapp_filer not configured
ORA-06512: 鍦?"SYSMAN.ECM_CT", line 718
ORA-06512: 鍦?line 1
ORA-06512: 鍦?"SYSMAN.EMD_LOADER", line 4931
ORA-06512: 鍦?line 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:73)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:472)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:422)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1089)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:200)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1029)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1347)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3556)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3727)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:8130)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1209)
at oracle.sysman.util.jdbc.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:173)
at oracle.sysman.util.jdbc.CallableStatementWrapper.execute(CallableStatementWrapper.java:135)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.postLoadProc(XMLDocumentSplitter.java:1709)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.endElement(XMLDocumentSplitter.java:1009)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1318)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:206)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.split(XMLDocumentSplitter.java:477)
at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.loadFromStream(XMLLoaderContext.java:1824)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.LoadFile(XMLLoader.java:578)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.LoadFiles(XMLLoader.java:669)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.run(XMLLoader.java:1316)
at java.lang.Thread.run(Thread.java:595)