3 Replies Latest reply on Sep 15, 2006 3:34 PM by 432043

    Enterprise Manager 10g Release 2: Database Down Page

    432043
      I can't get Enterprise Manager to see that the Database Instance and Listener are up. I can interact with the database through SQL Plus and can bring the listener up and down through lsnrctl but no matter what I do, the web-based enterprise manager will no detect that the database or listener are up. I did not install this database but "inherited" it. It is is a SLES 9 cluster but not using Oracle Clusterware. Its clustered using a product from Polyserve. I would like to avoid a reinstall because I am not familiar with the clustering software. Thanks for any help.
        • 1. Re: Enterprise Manager 10g Release 2: Database Down Page
          mnazim-Oracle
          whats the oms ,agent version.?

          Please paste the emoms.trc and emagent.trc file here .
          • 2. Re: Enterprise Manager 10g Release 2: Database Down Page
            432043
            I am not sure what you mean my the oms, agent version. I am running Oracle Database 10g 10.2.0.1.0. I don't believe it has been patched since the base install of release 2.

            Both of those files are mighty big but almost all of it just repeats the same errors, below I have pasted excerpts. Thanks for replying.

            Here is an excerpt from emoms.trc
            2006-09-15 10:22:24,929 [HttpRequestHandler-4818382] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection
            2006-09-15 10:22:24,932 [HttpRequestHandler-4818382] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
            2006-09-15 10:22:24,932 [HttpRequestHandler-4818382] WARN jdbc.ConnectionCache _getConnection.306 - 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: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.<init>(PhysicalConnection.java:493)
                 at oracle.jdbc.driver.T4CConnection.<init>(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.emdrep.receiver.OMSHandshake.getParameterFromDB(OMSHandshake.java:387)
                 at oracle.sysman.emdrep.receiver.OMSHandshake.getMaxAgentCompatVer(OMSHandshake.java:369)
                 at oracle.sysman.emdrep.receiver.OMSHandshake.handshake(OMSHandshake.java:794)
                 at oracle.sysman.emdrep.receiver.OMSHandshake.handshake(OMSHandshake.java:648)
                 at oracle.sysman.emdrep.receiver.FxferRecv.doGet(FxferRecv.java:658)
                 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.ContextInitFilter.doFilter(ContextInitFilter.java:239)
                 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604)
                 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
                 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793)
                 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
                 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
                 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
                 at java.lang.Thread.run(Thread.java:534)
            2006-09-15 10:22:24,935 [HttpRequestHandler-4818382] ERROR eml.OMSHandshake getParameterFromDB.402 - Io exception: The Network Adapter could not establish the connection
            2006-09-15 10:22:24,935 [HttpRequestHandler-4818382] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://stl-lxc-01.stlouiscity.com:3938/emd/main)(ERROR = INTERNAL_ERROR)
            2006-09-15 10:22:24,940 [HttpRequestHandler-3974996] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
            2006-09-15 10:22:24,941 [HttpRequestHandler-3974996] WARN jdbc.ConnectionCache _getConnection.306 - 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: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.<init>(PhysicalConnection.java:493)
                 at oracle.jdbc.driver.T4CConnection.<init>(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.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:144)
                 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604)
                 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
                 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793)
                 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
                 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
                 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
                 at java.lang.Thread.run(Thread.java:534)
            2006-09-15 10:22:24,943 [HttpRequestHandler-3974996] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection
            2006-09-15 10:22:24,945 [HttpRequestHandler-3974996] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
            2006-09-15 10:22:24,947 [HttpRequestHandler-3974996] WARN jdbc.ConnectionCache _getConnection.306 - 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: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.<init>(PhysicalConnection.java:493)
                 at oracle.jdbc.driver.T4CConnection.<init>(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.emdrep.receiver.OMSHandshake.getParameterFromDB(OMSHandshake.java:387)
                 at oracle.sysman.emdrep.receiver.OMSHandshake.getMaxAgentCompatVer(OMSHandshake.java:369)
                 at oracle.sysman.emdrep.receiver.OMSHandshake.handshake(OMSHandshake.java:794)
                 at oracle.sysman.emdrep.receiver.OMSHandshake.handshake(OMSHandshake.java:648)
                 at oracle.sysman.emdrep.receiver.FxferRecv.doGet(FxferRecv.java:658)
                 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.ContextInitFilter.doFilter(ContextInitFilter.java:239)
                 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604)
                 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
                 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793)
                 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
                 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
                 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
                 at java.lang.Thread.run(Thread.java:534)
            2006-09-15 10:22:24,950 [HttpRequestHandler-3974996] ERROR eml.OMSHandshake getParameterFromDB.402 - Io exception: The Network Adapter could not establish the connection
            2006-09-15 10:22:24,950 [HttpRequestHandler-3974996] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://stl-lxc-01.stlouiscity.com:3938/emd/main)(ERROR = INTERNAL_ERROR)

            Here is an excerpt from emagent.trc
            2006-09-14 16:31:38 Thread-22216711 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:31:38 Thread-22216711 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:32:08 Thread-22233095 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:32:08 Thread-22233095 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:32:19 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            2006-09-14 16:32:38 Thread-22282247 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:32:38 Thread-22282247 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:33:00 Thread-22315016 ERROR emSDK.xml: ParseError: File=stream, Line=4, Msg=Missing value for ARG in RemoteOperationArgument
            2006-09-14 16:33:02 Thread-22331401 ERROR emSDK.xml: ParseError: File=stream, Line=4, Msg=Missing value for ARG in RemoteOperationArgument
            2006-09-14 16:33:08 Thread-22511630 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:33:08 Thread-22511630 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:33:38 Thread-22609936 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:33:38 Thread-22609936 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:34:04 Thread-32771 WARN http: 7,-1: nmehl_httpListener: signaled to exit from emctl
            2006-09-14 16:35:52 Thread-16384 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:35:52 Thread-16384 WARN command: Job Subsystem Timeout set at 600 seconds
            2006-09-14 16:35:53 Thread-16384 WARN upload: Upload manager has no Failure script: disabled
            2006-09-14 16:35:53 Thread-16384 WARN upload: Recovering left over xml files in upload directory
            2006-09-14 16:35:53 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            2006-09-14 16:35:53 Thread-16384 WARN upload: Recovered 2237 left over xml files in upload directory
            2006-09-14 16:35:53 Thread-16384 WARN metadata: Metric Disk_Path does not have any data columns
            2006-09-14 16:35:53 Thread-16384 WARN metadata: Metric osm_diskGroupPolicies does not have any data columns
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x82f80b8 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },SystemTablespaceNumber::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x82f80b8 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },SysauxTablespaceNumber::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x82f80b8 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },MonitorConfigStatus::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x8196b68 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },Config::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x82f80b8 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },GetDumpDestination::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x82f80b8 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },GetArchiveDestination::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x82f80b8 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },GetDBVersion::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN engine: Missing Properties : [Version]
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },ComputeVC::Missing Properties : [Version]
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x82f80b8 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },GetCPUCount::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x82f80b8 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },CheckRAC::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

            SQL = " OCIServerAttach"...
            LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stl-lxc-01.stlouiscity.com)(PORT=1521))(CONNECT_DATA=(SID=CSB)))
            2006-09-14 16:35:53 Thread-114694 ERROR vpxoci: ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN vpxoci: Login 0x8264668 failed, error=ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-114694 WARN TargetManager: Exception in computing dynamic properties of {CSB, oracle_database },decideIncludeDB::ORA-12541: TNS:no listener
            2006-09-14 16:35:53 Thread-16384 WARN upload: Truncating value of "CATEGORY_PROP_2" from "SUSE LINUX Enterprise Server 9 (i586) VERSION = 9 PATCHLEVEL = 2 " to "SUSE LINUX Enterprise Server 9 (i586) VERSION = 9 PATCHLEVEL ="
            2006-09-14 16:35:53 Thread-16384 WARN collector: the column name DiskActivityavwait in this condition does not exist
            2006-09-14 16:35:53 Thread-16384 WARN collector: nmecs_initializeStateFiles(): found empty directory, wiping state
            2006-09-14 16:35:53 Thread-180232 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:35:53 Thread-180232 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:35:53 Thread-163847 ERROR upload: Error in uploadXMLFiles. Trying again in 60.00 seconds.
            2006-09-14 16:35:53 Thread-163847 ERROR upload: Exceeded max. amount of upload data: 2239 files, 50.041175 MB Data. 25.60% of disk used. Disabling collections.
            2006-09-14 16:35:53 Thread-163847 WARN collector: Disable collector
            2006-09-14 16:35:53 Thread-163847 ERROR collector: Collector state files cleaned, severity will be resent
            2006-09-14 16:35:55 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            2006-09-14 16:35:59 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            2006-09-14 16:36:07 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            2006-09-14 16:36:23 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            2006-09-14 16:36:23 Thread-212999 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:36:23 Thread-212999 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:36:53 Thread-278537 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:36:53 Thread-278537 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:36:55 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            2006-09-14 16:37:23 Thread-311305 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:37:23 Thread-311305 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:37:53 Thread-344072 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:37:53 Thread-344072 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:37:59 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            2006-09-14 16:38:23 Thread-360455 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:38:23 Thread-360455 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:38:54 Thread-393224 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:38:54 Thread-393224 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:39:24 Thread-425991 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:39:24 Thread-425991 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:39:54 Thread-458759 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:39:54 Thread-458759 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
            2006-09-14 16:40:07 Thread-65541 ERROR command: nmejcn: received no status header from repository at http://stl-lxc-01.stlouiscity.com:1158/em/upload/
            • 3. Re: Enterprise Manager 10g Release 2: Database Down Page
              432043
              I think this is the agent version?

              10.1.0.4.1