EM 10g fails to get db status

From: Andreas Walter <awaltx_at_gmx.de>
Date: Thu, 20 May 2004 01:29:55 +0200
Message-ID: <c8gqm1$np3$1@nets3.rz.RWTH-Aachen.DE>

Hi there,
I've installed a new Oracle 10g database server on Fedora Core 1, and as far as I can see, all the database and all processes seem to be running, as I could see by using

	emctl status agent
	emctl status dbconsole
and 	lsnrctl status.

However, when opening http://ulme:5500/em (ulme is the host where the software has been installed), I am told that the database's status is currently unavailable. Taking a look at the emoms.log file reveals that there is probably a problem with jdbc:

[oracle_at_ulme log]$ more emoms.log
2004-05-19 16:36:49,770 [Orion Launcher] WARN jdbc.ConnectionCache
_getConnection.302 - Got a fatal exeption when getting a connection; Error
  code = 17002; Cleaning up cache and retrying 2004-05-19 16:36:49,786 [Orion Launcher] WARN jdbc.ConnectionCache
_getConnection.305 - Io exception: The Network Adapter could not establish
  the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)

         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318)
         at 
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:411)
         at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147)
         at 
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:553)
         at 
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:215)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:108)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:76)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:58)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection(OracleConnectionCacheImpl.java:506)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getPooledConnection(OracleConnectionCacheImpl.java:381)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:305)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:285)
         at 
oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:295)
         at 
oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:422)
         at 
oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:156)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:532)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.getRepositoryVersion(ConnectionService.java:348)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepositoryEx(ConnectionService.java:374)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepository(ConnectionService.java:408)
         at 
oracle.sysman.eml.app.ContextInitializer.contextInitialized(ContextInitializer.java:159)
         at 
com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:771)
         at 
com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:497)
         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:2325)
         at 
com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1498)
         at 
com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:93)
         at java.lang.Thread.run(Thread.java:534)

2004-05-19 16:36:49,794 [Orion Launcher] ERROR conn.ConnectionService verifyRepositoryEx.391 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection 2004-05-19 16:36:53,121 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ias. ias.IASIntegration
2004-05-19 16:36:53,865 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.eml. target.slb.common.SLBIntegration
2004-05-19 16:36:54,133 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.eml. ssl.intg.SSLIntegration
2004-05-19 16:36:54,304 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.tip.oem.cen tral.domain.ProcessConnectDomainIntg
2004-05-19 16:36:54,318 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.tip.oem.cen tral.instance.ProcessConnectInstanceIntg 2004-05-19 16:36:54,321 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.webdb.admin .em.PortalIntegration
2004-05-19 16:36:54,336 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.webdb.admin .em.SSOIntegration
2004-05-19 16:36:54,362 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.reports.em. RepIntg
2004-05-19 16:36:54,365 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsEmailIntegration
2004-05-19 16:36:54,368 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsOidIntegration
2004-05-19 16:36:54,371 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsOvfIntegration
2004-05-19 16:36:54,375 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsWebconfIntegration
2004-05-19 16:36:54,378 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsWirelessIntg
2004-05-19 16:36:54,381 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsCalGrpIntegration
2004-05-19 16:36:54,592 [NotificationMgrThread] WARN jdbc.ConnectionCache _getConnection.302 - Got a fatal exeption when getting a connection
; Error code = 17002; Cleaning up cache and retrying 2004-05-19 16:36:54,593 [NotificationMgrThread] WARN jdbc.ConnectionCache _getConnection.305 - Io exception: The Network Adapter could not es
tablish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)

         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318)
         at 
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:411)
         at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147)
         at 
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:553)
         at 
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:215)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:108)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:76)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:58)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection(OracleConnectionCacheImpl.java:506)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getPooledConnection(OracleConnectionCacheImpl.java:381)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:305)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:285)
         at 
oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:295)
         at 
oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:422)
         at 
oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:156)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:532)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.getRepositoryVersion(ConnectionService.java:348)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepositoryEx(ConnectionService.java:374)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepository(ConnectionService.java:408)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.blockUntilValid(ConnectionService.java:430)
         at 

oracle.sysman.emdrep.notification.NotificationMgr.run(NotificationMgr.java:984) 2004-05-19 16:36:54,598 [NotificationMgrThread] ERROR conn.ConnectionService verifyRepositoryEx.391 - Invalid Connection Pool. ERROR = Io exce
ption: The Network Adapter could not establish the connection 2004-05-19 16:36:54,598 [NotificationMgrThread] ERROR conn.ConnectionService blockUntilValid.440 - Connection pool is not valid. status =2
2004-05-19 16:36:54,599 [NotificationMgrThread] ERROR conn.ConnectionService blockUntilValid.448 - Repository connection details are invalid
.
2004-05-19 16:36:54,620 [OMSHeartbeatThread] WARN jdbc.ConnectionCache
_getConnection.302 - Got a fatal exeption when getting a connection; E
rror code = 17002; Cleaning up cache and retrying 2004-05-19 16:36:54,621 [OMSHeartbeatThread] WARN jdbc.ConnectionCache
_getConnection.305 - Io exception: The Network Adapter could not estab
lish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286) [oracle_at_ulme log]$ more emoms.log
2004-05-19 16:36:49,770 [Orion Launcher] WARN jdbc.ConnectionCache
_getConnection.302 - Got a fatal exeption when getting a connection; Error
  code = 17002; Cleaning up cache and retrying 2004-05-19 16:36:49,786 [Orion Launcher] WARN jdbc.ConnectionCache
_getConnection.305 - Io exception: The Network Adapter could not establish
  the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)

         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318)
         at 
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:411)
         at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147)
         at 
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:553)
         at 
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:215)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:108)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:76)
         at 
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:58)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection(OracleConnectionCacheImpl.java:506)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getPooledConnection(OracleConnectionCacheImpl.java:381)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:305)
         at 
oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:285)
         at 
oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:295)
         at 
oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:422)
         at 
oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:156)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:532)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.getRepositoryVersion(ConnectionService.java:348)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepositoryEx(ConnectionService.java:374)
         at 
oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepository(ConnectionService.java:408)
         at 
oracle.sysman.eml.app.ContextInitializer.contextInitialized(ContextInitializer.java:159)
         at 
com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:771)
         at 
com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:497)
         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:2325)
         at 
com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1498)
         at 
com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:93)
         at java.lang.Thread.run(Thread.java:534)

2004-05-19 16:36:49,794 [Orion Launcher] ERROR conn.ConnectionService verifyRepositoryEx.391 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection 2004-05-19 16:36:53,121 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ias. ias.IASIntegration
2004-05-19 16:36:53,865 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.eml. target.slb.common.SLBIntegration
2004-05-19 16:36:54,133 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.eml. ssl.intg.SSLIntegration
2004-05-19 16:36:54,304 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.tip.oem.cen tral.domain.ProcessConnectDomainIntg
2004-05-19 16:36:54,318 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.tip.oem.cen tral.instance.ProcessConnectInstanceIntg 2004-05-19 16:36:54,321 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.webdb.admin .em.PortalIntegration
2004-05-19 16:36:54,336 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.webdb.admin .em.SSOIntegration
2004-05-19 16:36:54,362 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.reports.em. RepIntg
2004-05-19 16:36:54,365 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsEmailIntegration
2004-05-19 16:36:54,368 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsOidIntegration
2004-05-19 16:36:54,371 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsOvfIntegration
2004-05-19 16:36:54,375 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsWebconfIntegration
2004-05-19 16:36:54,378 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsWirelessIntg
2004-05-19 16:36:54,381 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.256 - Integration Class not found: oracle.sysman.ocs. mntr.target.OcsCalGrpIntegration
2004-05-19 16:36:54,592 [NotificationMgrThread] WARN jdbc.ConnectionCache _getConnection.302 - Got a fatal exeption when getting a connection
; Error code = 17002; Cleaning up cache and retrying 2004-05-19 16:36:54,593 [NotificationMgrThread] WARN jdbc.ConnectionCache _getConnection.305 - Io exception: The Network Adapter could not es
tablish the connection

and so forth.

Does anybody know what's going wrong there?

Thanx,
Andreas. Received on Wed May 19 2004 - 18:29:55 CDT