1 2 Previous Next 16 Replies Latest reply on May 4, 2007 4:11 PM by mnazim-Oracle

    Agent Connection to Instance Failed With ORA-12541

    575559
      dbconsole is showing:

      agent connection to instance failed with ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach). All other captions i.e. database instance, listener are showing down.

      Instance is up and running. listener is up and running. I can connect using sqlplus to database normally - no problem what so ever. Why DBconsole is saying no listener. how to correct this issue.

      I tried to reconfiure emca - no result. kindly help to rectify this error.

      INFO: This is Oracle 10.2.0.3 @ linux 4.
        • 1. Re: Agent Connection to Instance Failed With ORA-12541
          rodneyli
          Can you post emagent.trc and emoms.trc?
          • 2. Re: Agent Connection to Instance Failed With ORA-12541
            575470
            It seems to be a port issue

            on the database for dbconsole, have your tried

            emca -config dbconsole db

            and provide the listener port again when asked
            • 4. Re: Agent Connection to Instance Failed With ORA-12541
              575559
              First, my thanks for replying back and your help. Below are required files.

              emom.properties
              ===========
              #Wed May 02 11:22:55 CDT 2007
              oracle.sysman.emSDK.svlt.ConsoleServerName=usilchqadbor01.universalaccess.net_Management_Service
              oracle.sysman.eml.mntr.emdRepPwd=d8a93ec82c105e78
              emdrep.ping.pingCommand=/usr/sbin/ping6 <hostname>
              oracle.sysman.eml.mntr.emdRepPort=1521
              oracle.sysman.eml.mntr.emdRepDBName=VQA01.universalaccess.net
              oracle.sysman.eml.mntr.emdRepPwdSeed=5621539308773213518
              oracle.sysman.emSDK.svlt.ConsoleMode=standalone
              oracle.sysman.emRep.dbConn.statementCacheSize=30
              oracle.sysman.db.isqlplusUrl=http\://usilchqadbor01.universalaccess.net\:5560/isqlplus/dynamic
              oracle.sysman.emSDK.svlt.ConsoleServerPort=1158
              oracle.sysman.eml.mntr.emdRepRAC=FALSE
              oracle.sysman.emSDK.emd.rt.useMonitoringCred=true
              oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
              oracle.sysman.db.isqlplusWebDBAUrl=http\://usilchqadbor01.universalaccess.net\:5560/isqlplus/dba/dynamic
              oracle.sysman.emSDK.svlt.ConsoleServerHost=usilchqadbor01.universalaccess.net
              oracle.sysman.eml.mntr.emdRepDBID=387172890
              oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1158
              oracle.sysman.eml.mntr.emdRepServer=usilchqadbor01.universalaccess.net
              oracle.sysman.eml.mntr.emdRepSID=VQA01
              oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=usilchqadbor01.universalaccess.net)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=VQA01.universalaccess.net)))
              oracle.sysman.emSDK.sec.ReuseLogonPassword=true
              oracle.sysman.eml.mntr.emdRepUser=SYSMAN
              oracle.sysman.db.adm.conn.statementCacheSize=2
              oracle.sysman.db.perf.conn.statementCacheSize=30

              target.xml
              =======<Targets AGENT_TOKEN="7ae984b7cf8fcb0652b7d6b9a09d9598b3fa1c0c">
              <Target TYPE="oracle_emd" NAME="usilchqadbor01.universalaccess.net:3938"/>
              <Target TYPE="host" NAME="usilchqadbor01.universalaccess.net"/>
              <Target TYPE="oracle_database" NAME="VQA01.universalaccess.net">
              <Property NAME="MachineName" VALUE="usilchqadbor01.universalaccess.net"/>
              <Property NAME="Port" VALUE="1521"/>
              <Property NAME="SID" VALUE="VQA01"/>
              <Property NAME="OracleHome" VALUE="/opt/oracle/app"/>
              <Property NAME="UserName" VALUE="00dd9cf76bab5ca8" ENCRYPTED="TRUE"/>
              <Property NAME="password" VALUE="cb5620a5fd44c37a" ENCRYPTED="TRUE"/>
              </Target>
              <Target TYPE="oracle_listener" NAME="LISTENER_usilchqadbor01.universalaccess.net">
              <Property NAME="Machine" VALUE="usilchqadbor01.universalaccess.net"/>
              <Property NAME="LsnrName" VALUE="LISTENER"/>
              <Property NAME="Port" VALUE="1521"/>
              <Property NAME="OracleHome" VALUE="/opt/oracle/app"/>
              <Property NAME="ListenerOraDir" VALUE="/opt/oracle/app/network/admin"/>
              </Target>
              </Targets>

              emom.trc
              =======2007-05-03 06:59:07,853 [HttpRequestHandler-8814509] ERROR eml.OMSHandshake getParameterFromDB.563 - Io exception: The Network Adapter could not establish the connection
              2007-05-03 06:59:07,854 [HttpRequestHandler-8814509] ERROR eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL = http://usilchqadbor01.universalaccess.net:3938/emd/main)(ERROR = INTERNAL_ERROR)
              2007-05-03 06:59:37,860 [HttpRequestHandler-8814509] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
              2007-05-03 06:59:37,860 [HttpRequestHandler-8814509] 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:518)
              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:606)
              at oracle.sysman.emSDK.svc.conn.ConnectionService.getRepositoryVersionAndMode(ConnectionService.java:369)
              at oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepositoryEx(ConnectionService.java:396)
              at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:157)
              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)
              2007-05-03 06:59:37,862 [HttpRequestHandler-8814509] ERROR conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection
              2007-05-03 06:59:37,863 [HttpRequestHandler-8814509] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
              @
              "emoms.trc" 36866L, 3560803C

              emom.log
              =======
              2007-05-03 06:59:07,838 [HttpRequestHandler-4626217] ERROR conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection
              2007-05-03 06:59:07,841 [HttpRequestHandler-4626217] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
              2007-05-03 06:59:07,841 [HttpRequestHandler-4626217] 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:518)
              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:606)
              at oracle.sysman.emdrep.receiver.OMSHandshake.getParameterFromDB(OMSHandshake.java:548)
              at oracle.sysman.emdrep.receiver.OMSHandshake.getMaxAgentCompatVer(OMSHandshake.java:530)
              at oracle.sysman.emdrep.receiver.OMSHandshake.handshake(OMSHandshake.java:973)
              at oracle.sysman.emdrep.receiver.OMSHandshake.handshake(OMSHandshake.java:809)
              at oracle.sysman.emdrep.receiver.FxferRecv.doGet(FxferRecv.java:669)
              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:252)
              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)
              @
              "emoms.log" 37259L, 3598812C

              Listener.ora
              ========
              SID_LIST_LISTENER =
              (SID_LIST =
              (SID_DESC =
              (SID_NAME = PLSExtProc)
              (ORACLE_HOME = /opt/oracle/app)
              (PROGRAM = extproc)
              )
              (SID_DESC =
              (GLOBAL_DBNAME = VQA01)
              (ORACLE_HOME = /opt/oracle/app)
              (SID_NAME = VQA01)
              )
              )

              LISTENER =
              (DESCRIPTION_LIST =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.254.12)(PORT = 1521))
              )
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
              )
              )
              • 5. Re: Agent Connection to Instance Failed With ORA-12541
                575559
                First, my thanks for replying back and your help. Below are required files.

                emom.properties
                ===========
                #Wed May 02 11:22:55 CDT 2007
                oracle.sysman.emSDK.svlt.ConsoleServerName=usilchqadbor01.universalaccess.net_Management_Service
                oracle.sysman.eml.mntr.emdRepPwd=d8a93ec82c105e78
                emdrep.ping.pingCommand=/usr/sbin/ping6 <hostname>
                oracle.sysman.eml.mntr.emdRepPort=1521
                oracle.sysman.eml.mntr.emdRepDBName=VQA01.universalaccess.net
                oracle.sysman.eml.mntr.emdRepPwdSeed=5621539308773213518
                oracle.sysman.emSDK.svlt.ConsoleMode=standalone
                oracle.sysman.emRep.dbConn.statementCacheSize=30
                oracle.sysman.db.isqlplusUrl=http\://usilchqadbor01.universalaccess.net\:5560/isqlplus/dynamic
                oracle.sysman.emSDK.svlt.ConsoleServerPort=1158
                oracle.sysman.eml.mntr.emdRepRAC=FALSE
                oracle.sysman.emSDK.emd.rt.useMonitoringCred=true
                oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
                oracle.sysman.db.isqlplusWebDBAUrl=http\://usilchqadbor01.universalaccess.net\:5560/isqlplus/dba/dynamic
                oracle.sysman.emSDK.svlt.ConsoleServerHost=usilchqadbor01.universalaccess.net
                oracle.sysman.eml.mntr.emdRepDBID=387172890
                oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1158
                oracle.sysman.eml.mntr.emdRepServer=usilchqadbor01.universalaccess.net
                oracle.sysman.eml.mntr.emdRepSID=VQA01
                oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=usilchqadbor01.universalaccess.net)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=VQA01.universalaccess.net)))
                oracle.sysman.emSDK.sec.ReuseLogonPassword=true
                oracle.sysman.eml.mntr.emdRepUser=SYSMAN
                oracle.sysman.db.adm.conn.statementCacheSize=2
                oracle.sysman.db.perf.conn.statementCacheSize=30

                target.xml
                =======<Targets AGENT_TOKEN="7ae984b7cf8fcb0652b7d6b9a09d9598b3fa1c0c">
                <Target TYPE="oracle_emd" NAME="usilchqadbor01.universalaccess.net:3938"/>
                <Target TYPE="host" NAME="usilchqadbor01.universalaccess.net"/>
                <Target TYPE="oracle_database" NAME="VQA01.universalaccess.net">
                <Property NAME="MachineName" VALUE="usilchqadbor01.universalaccess.net"/>
                <Property NAME="Port" VALUE="1521"/>
                <Property NAME="SID" VALUE="VQA01"/>
                <Property NAME="OracleHome" VALUE="/opt/oracle/app"/>
                <Property NAME="UserName" VALUE="00dd9cf76bab5ca8" ENCRYPTED="TRUE"/>
                <Property NAME="password" VALUE="cb5620a5fd44c37a" ENCRYPTED="TRUE"/>
                </Target>
                <Target TYPE="oracle_listener" NAME="LISTENER_usilchqadbor01.universalaccess.net">
                <Property NAME="Machine" VALUE="usilchqadbor01.universalaccess.net"/>
                <Property NAME="LsnrName" VALUE="LISTENER"/>
                <Property NAME="Port" VALUE="1521"/>
                <Property NAME="OracleHome" VALUE="/opt/oracle/app"/>
                <Property NAME="ListenerOraDir" VALUE="/opt/oracle/app/network/admin"/>
                </Target>
                </Targets>

                emom.trc
                =======2007-05-03 06:59:07,853 [HttpRequestHandler-8814509] ERROR eml.OMSHandshake getParameterFromDB.563 - Io exception: The Network Adapter could not establish the connection
                2007-05-03 06:59:07,854 [HttpRequestHandler-8814509] ERROR eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL = http://usilchqadbor01.universalaccess.net:3938/emd/main)(ERROR = INTERNAL_ERROR)
                2007-05-03 06:59:37,860 [HttpRequestHandler-8814509] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
                2007-05-03 06:59:37,860 [HttpRequestHandler-8814509] 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:518)
                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:606)
                at oracle.sysman.emSDK.svc.conn.ConnectionService.getRepositoryVersionAndMode(ConnectionService.java:369)
                at oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepositoryEx(ConnectionService.java:396)
                at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:157)
                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)
                2007-05-03 06:59:37,862 [HttpRequestHandler-8814509] ERROR conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection
                2007-05-03 06:59:37,863 [HttpRequestHandler-8814509] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
                @
                "emoms.trc" 36866L, 3560803C

                Listener.ora
                ========
                SID_LIST_LISTENER =
                (SID_LIST =
                (SID_DESC =
                (SID_NAME = PLSExtProc)
                (ORACLE_HOME = /opt/oracle/app)
                (PROGRAM = extproc)
                )
                (SID_DESC =
                (GLOBAL_DBNAME = VQA01)
                (ORACLE_HOME = /opt/oracle/app)
                (SID_NAME = VQA01)
                )
                )

                LISTENER =
                (DESCRIPTION_LIST =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.254.12)(PORT = 1521))
                )
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
                )
                )
                • 6. Re: Agent Connection to Instance Failed With ORA-12541
                  575559
                  First, my thanks for replying back and your help. Below are required files.

                  emom.properties
                  ===========
                  #Wed May 02 11:22:55 CDT 2007
                  oracle.sysman.emSDK.svlt.ConsoleServerName=usilchqadbor01.universalaccess.net_Management_Service
                  oracle.sysman.eml.mntr.emdRepPwd=d8a93ec82c105e78
                  emdrep.ping.pingCommand=/usr/sbin/ping6 <hostname>
                  oracle.sysman.eml.mntr.emdRepPort=1521
                  oracle.sysman.eml.mntr.emdRepDBName=VQA01.universalaccess.net
                  oracle.sysman.eml.mntr.emdRepPwdSeed=5621539308773213518
                  oracle.sysman.emSDK.svlt.ConsoleMode=standalone
                  oracle.sysman.emRep.dbConn.statementCacheSize=30
                  oracle.sysman.db.isqlplusUrl=http\://usilchqadbor01.universalaccess.net\:5560/isqlplus/dynamic
                  oracle.sysman.emSDK.svlt.ConsoleServerPort=1158
                  oracle.sysman.eml.mntr.emdRepRAC=FALSE
                  oracle.sysman.emSDK.emd.rt.useMonitoringCred=true
                  oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
                  oracle.sysman.db.isqlplusWebDBAUrl=http\://usilchqadbor01.universalaccess.net\:5560/isqlplus/dba/dynamic
                  oracle.sysman.emSDK.svlt.ConsoleServerHost=usilchqadbor01.universalaccess.net
                  oracle.sysman.eml.mntr.emdRepDBID=387172890
                  oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1158
                  oracle.sysman.eml.mntr.emdRepServer=usilchqadbor01.universalaccess.net
                  oracle.sysman.eml.mntr.emdRepSID=VQA01
                  oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=usilchqadbor01.universalaccess.net)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=VQA01.universalaccess.net)))
                  oracle.sysman.emSDK.sec.ReuseLogonPassword=true
                  oracle.sysman.eml.mntr.emdRepUser=SYSMAN
                  oracle.sysman.db.adm.conn.statementCacheSize=2
                  oracle.sysman.db.perf.conn.statementCacheSize=30

                  target.xml
                  =======<Targets AGENT_TOKEN="7ae984b7cf8fcb0652b7d6b9a09d9598b3fa1c0c">
                  <Target TYPE="oracle_emd" NAME="usilchqadbor01.universalaccess.net:3938"/>
                  <Target TYPE="host" NAME="usilchqadbor01.universalaccess.net"/>
                  <Target TYPE="oracle_database" NAME="VQA01.universalaccess.net">
                  <Property NAME="MachineName" VALUE="usilchqadbor01.universalaccess.net"/>
                  <Property NAME="Port" VALUE="1521"/>
                  <Property NAME="SID" VALUE="VQA01"/>
                  <Property NAME="OracleHome" VALUE="/opt/oracle/app"/>
                  <Property NAME="UserName" VALUE="00dd9cf76bab5ca8" ENCRYPTED="TRUE"/>
                  <Property NAME="password" VALUE="cb5620a5fd44c37a" ENCRYPTED="TRUE"/>
                  </Target>
                  <Target TYPE="oracle_listener" NAME="LISTENER_usilchqadbor01.universalaccess.net">
                  <Property NAME="Machine" VALUE="usilchqadbor01.universalaccess.net"/>
                  <Property NAME="LsnrName" VALUE="LISTENER"/>
                  <Property NAME="Port" VALUE="1521"/>
                  <Property NAME="OracleHome" VALUE="/opt/oracle/app"/>
                  <Property NAME="ListenerOraDir" VALUE="/opt/oracle/app/network/admin"/>
                  </Target>
                  </Targets>

                  emom.trc
                  =======2007-05-03 06:59:07,853 [HttpRequestHandler-8814509] ERROR eml.OMSHandshake getParameterFromDB.563 - Io exception: The Network Adapter could not establish the connection
                  2007-05-03 06:59:07,854 [HttpRequestHandler-8814509] ERROR eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL = http://usilchqadbor01.universalaccess.net:3938/emd/main)(ERROR = INTERNAL_ERROR)
                  2007-05-03 06:59:37,860 [HttpRequestHandler-8814509] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
                  2007-05-03 06:59:37,860 [HttpRequestHandler-8814509] 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:518)
                  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:606)
                  at oracle.sysman.emSDK.svc.conn.ConnectionService.getRepositoryVersionAndMode(ConnectionService.java:369)
                  at oracle.sysman.emSDK.svc.conn.ConnectionService.verifyRepositoryEx(ConnectionService.java:396)
                  at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:157)
                  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)
                  2007-05-03 06:59:37,862 [HttpRequestHandler-8814509] ERROR conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection
                  2007-05-03 06:59:37,863 [HttpRequestHandler-8814509] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
                  @
                  "emoms.trc" 36866L, 3560803C

                  emom.log
                  =======
                  2007-05-03 06:59:07,838 [HttpRequestHandler-4626217] ERROR conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter could not establish the connection
                  2007-05-03 06:59:07,841 [HttpRequestHandler-4626217] WARN jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
                  2007-05-03 06:59:07,841 [HttpRequestHandler-4626217] 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:518)
                  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:606)
                  at oracle.sysman.emdrep.receiver.OMSHandshake.getParameterFromDB(OMSHandshake.java:548)
                  at oracle.sysman.emdrep.receiver.OMSHandshake.getMaxAgentCompatVer(OMSHandshake.java:530)
                  at oracle.sysman.emdrep.receiver.OMSHandshake.handshake(OMSHandshake.java:973)
                  at oracle.sysman.emdrep.receiver.OMSHandshake.handshake(OMSHandshake.java:809)
                  at oracle.sysman.emdrep.receiver.FxferRecv.doGet(FxferRecv.java:669)
                  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:252)
                  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)
                  @
                  "emoms.log" 37259L, 3598812C

                  Listener.ora
                  ========
                  SID_LIST_LISTENER =
                  (SID_LIST =
                  (SID_DESC =
                  (SID_NAME = PLSExtProc)
                  (ORACLE_HOME = /opt/oracle/app)
                  (PROGRAM = extproc)
                  )
                  (SID_DESC =
                  (GLOBAL_DBNAME = VQA01)
                  (ORACLE_HOME = /opt/oracle/app)
                  (SID_NAME = VQA01)
                  )
                  )

                  LISTENER =
                  (DESCRIPTION_LIST =
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.254.12)(PORT = 1521))
                  )
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
                  )
                  )
                  • 7. Re: Agent Connection to Instance Failed With ORA-12541
                    575470
                    Your TNSNAMES.ORA file and emoms.properties file show different SERVICE_NAMES

                    emoms.properties shows SERVICE_NAME\=VQA01.universalaccess.net and TNSNAMES ony VQA01, I think your database global_name is missing your domain name

                    so please check you global_name of your database, if its VQA01 change it to VQA01.universalaccess.net, and change GLOBAL_NAME in your TNSNAMES.ORA file as well

                    Hope it works
                    • 8. Re: Agent Connection to Instance Failed With ORA-12541
                      575559
                      SYSTEM>select * from global_name;

                      GLOBAL_NAME
                      --------------------------------------------
                      VQA01.UNIVERSALACCESS.NET

                      tnsnames.ora
                      ==========
                      EXTPROC_CONNECTION_DATA =
                      (DESCRIPTION =
                      (ADDRESS_LIST =
                      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
                      )
                      (CONNECT_DATA =
                      (SID = PLSExtProc)
                      (PRESENTATION = RO)
                      )
                      )
                      VQA01 =
                      (DESCRIPTION =
                      (ADDRESS_LIST =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.254.12)(PORT = 1521))
                      )
                      (CONNECT_DATA =
                      (SERVER = DEDICATED)
                      (SERVICE_NAME = VQA01)
                      (GLOBAL_DBNAME = VQA01.UNIVERSALACCESS.NET)
                      )
                      )


                      still same result with error. i guess there is something else with this.
                      • 9. Re: Agent Connection to Instance Failed With ORA-12541
                        rodneyli
                        Can you post lsnrctl status?
                        And there is just one oracle home on this server, right?
                        • 10. Re: Agent Connection to Instance Failed With ORA-12541
                          575559
                          $ lsnrctl status

                          LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 03-MAY-2007 13:26:22

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

                          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.254.254.12)(PORT=1521 )))
                          STATUS of the LISTENER
                          ------------------------
                          Alias LISTENER
                          Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
                          Start Date 03-MAY-2007 10:09:53
                          Uptime 0 days 3 hr. 16 min. 30 sec
                          Trace Level off
                          Security ON: Local OS Authentication
                          SNMP OFF
                          Listener Parameter File /opt/oracle/app/network/admin/listener.ora
                          Listener Log File /opt/oracle/app/network/log/listener.log
                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.254.254.12)(PORT=1521)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
                          Services Summary...
                          Service "PLSExtProc" has 1 instance(s).
                          Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                          Service "VQA01" has 1 instance(s).
                          Instance "VQA01", status UNKNOWN, has 1 handler(s) for this service...
                          The command completed successfully

                          Like i said, it i can connect to database ; no problem what soever, Yes, only one OH and one instance. any ideas?
                          • 11. Re: Agent Connection to Instance Failed With ORA-12541
                            rodneyli
                            your listener looks ok and yet your agent had problems..weird...running out of things to check. do you have only one network card? May be try a fresh install??
                            • 12. Re: Agent Connection to Instance Failed With ORA-12541
                              575470
                              I can understand you are already stressed a lot due to this issue, but can you just try this

                              emctl stop dbconsole

                              Change this in emoms.properties

                              original
                              oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=usilchqadbor01.universalaccess.net)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=VQA01.universalaccess.net)))

                              change to
                              oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=usilchqadbor01.universalaccess.net)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=VQA01)))

                              emctl start dbconsole
                              • 13. Re: Agent Connection to Instance Failed With ORA-12541
                                mnazim-Oracle
                                Bounce the dbconsole , if problem doesn't solve issue following command
                                <DBoh>\bin\emctl clearstate agent
                                • 14. Re: Agent Connection to Instance Failed With ORA-12541
                                  575559
                                  hi there,

                                  Thanks guys for your replys and sharing your knowledge.

                                  I tried both solutions from kam sing & mnazim - none worked for me

                                  here is a point .........

                                  [vancorlc@usilchqadbor01 ~]$ emctl start dbconsole
                                  TZ set to US/Central
                                  Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
                                  Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
                                  http://usilchqadbor01.universalaccess.net:1158/em/console/aboutApplication
                                  Agent Version : 10.1.0.5.1
                                  OMS Version : 10.1.0.5.0
                                  Protocol Version : 10.1.0.2.0
                                  Agent Home : /opt/oracle/app/usilchqadbor01.universalaccess.net_VQA01
                                  Agent binaries : /opt/oracle/app
                                  Agent Process ID : 16835
                                  Parent Process ID : 16829
                                  Agent URL : http://usilchqadbor01.universalaccess.net:3938/emd/main
                                  Started at : 2007-05-04 09:35:05
                                  Started by user : vancorlc
                                  Last Reload : 2007-05-04 09:35:05
                                  Last successful upload : (none)
                                  Last attempted upload : (none)
                                  Total Megabytes of XML files uploaded so far : 0.00
                                  Number of XML files pending upload : 613
                                  Size of XML files pending upload(MB) : 19.32
                                  Available disk space on upload filesystem : 73.53%
                                  Agent is already started. Will restart the agent
                                  Stopping agent ... stopped.
                                  Starting Oracle Enterprise Manager 10g Database Control ............................. started.
                                  ------------------------------------------------------------------
                                  Logs are generated in directory /opt/oracle/app/usilchqadbor01.universalaccess.net_VQA01/sysman/log

                                  [vancorlc@usilchqadbor01 ~]$ emctl status agent
                                  TZ set to US/Central
                                  Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
                                  Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
                                  ---------------------------------------------------------------
                                  Agent Version : 10.1.0.5.1
                                  OMS Version : 10.1.0.5.0
                                  Protocol Version : 10.1.0.2.0
                                  Agent Home : /opt/oracle/app/usilchqadbor01.universalaccess.net_VQA01
                                  Agent binaries : /opt/oracle/app
                                  Agent Process ID : 25095
                                  Parent Process ID : 20624
                                  Agent URL : http://usilchqadbor01.universalaccess.net:3938/emd/main
                                  Started at : 2007-05-04 09:37:42
                                  Started by user : vancorlc
                                  Last Reload : 2007-05-04 09:37:42
                                  Last successful upload : (none)
                                  Last attempted upload : (none)
                                  Total Megabytes of XML files uploaded so far : 0.00
                                  Number of XML files pending upload : 618
                                  Size of XML files pending upload(MB) : 20.09
                                  Available disk space on upload filesystem : 73.55%
                                  ---------------------------------------------------------------
                                  Agent is Running and Ready
                                  [vancorlc@usilchqadbor01 ~]$ emctl upload
                                  TZ set to US/Central
                                  Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
                                  Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
                                  EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

                                  you can see none of xml files are uploaded by agent. It seems there is something terribly wrong with agent that it is not loading files; although agent is running. Any idea what can stop agent to load files on oms - timezone of agent ? i checked emd.properties and it is correct. what it is saying [ OMS version not checked yet.......] i dont understand this - any option that you guys want to share please....

                                  i'll be looking forward..
                                  thanks
                                  1 2 Previous Next