unwrapped oracle,求助CentOS 5.4 +oracle 11g R2 ASM 模式 安装后 EM 启动后登陆不进去!

本文描述了一位用户在尝试在CentOS 5.4环境中安装Oracle 11g R2 ASM模式下的EM时遇到登录问题。问题表现为网页错误,tnsping查询失败,以及emctl启动时的ORA-12514错误。文章详细记录了故障现象、错误日志分析和可能的解决方案。
摘要由CSDN通过智能技术生成

求助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)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值