2 Replies Latest reply on Aug 7, 2010 10:31 PM by 737000

    ERROR pingManager: nmepm_pingReposURL: Cannot connect

    737000
      Dear All,

      I got a serious issues with my database

      - I created a disks group  (DATA) using ASMLib
      - I installed Oracle grid infrastructure
      - I Installed Oracle database software 11g
      - My OS ORACLE ENTERPRISE LINUX 5

      Result
      - I couldn't start OEM
      - lsnrctl take long time to start or get status
      - emctl take long time to start or get status

      everything ok  I can access my database using SQL-Plus but I cant access using OEM
      when I start lsnrctl it takes long long time (2 minutes)
      when I start emctl start dbconsole it takes long time too ( > 2 min)
      I tried to reconfigure emctl many times but nothing new
      this's first time i use grid so i need some advice

      in grid control which listener should start (grid itself or database home)
      ORACLE_SID is orcl and ORACLE_HOME is   /u01/app/oracle/product/11.2.0/dbhome_1

      when i start dbconsole from  /u01/app/oracle/product/11.2.0/dbhome_1  its start but i could not access OEM

      [oracle@ora bin]$ ./emctl start dbconsole
      Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
      Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
      https://ora:1158/em/console/aboutApplication
      Starting Oracle Enterprise Manager 11g Database Control ............... started.
      ------------------------------------------------------------------
      Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/ora_orcl/sysman/log

      when I start dbconsole from  /u01/app/oracle/product/11.2.0/grid this what happen but
      ORACLE_SID is orcl and ORACLE_HOME is   /u01/app/oracle/product/11.2.0/grid

      [oracle@ora ~]$ emctl start dbconsole
      Can't locate CompEMdbconsole.pm in @INC (@INC contains: %s_javapOracleHome%/sysman/admin/scripts %s_javapOracleHome%/bin /u01/app/oracle/product/11.2.0/grid/perl/lib/5.10.0/i686-linux-thread-multi /u01/app/oracle/product/11.2.0/grid/perl/lib/5.10.0 /u01/app/oracle/product/11.2.0/grid/perl/lib /u01/app/oracle/product/11.2.0/grid/perl/lib/site_perl/5.10.0/i686-linux-thread-multi /u01/app/oracle/product/11.2.0/grid/perl/lib/site_perl/5.10.0 /u01/app/oracle/product/11.2.0/grid/perl/lib/site_perl /u01/app/oracle/product/11.2.0/grid/perl/libwww-perl/lib /u01/app/oracle/product/11.2.0/grid/perl/ext/POSIX /u01/app/oracle/product/11.2.0/grid/perl/URI /u01/app/oracle/product/11.2.0/grid/perl/HTML_Parser /u01/app/oracle/product/11.2.0/grid/perl/HTML-Parser/lib /u01/app/oracle/product/11.2.0/grid/sysman/admin/scripts /u01/app/oracle/product/11.2.0/grid/bin /u01/app/oracle/product/11.2.0/grid/sysman/admin/scripts/Net-DNS-0.48/lib/ /u01/app/oracle/product/11.2.0/grid/sysman/admin/scripts/libnet-1.19/ .) at /u01/app/oracle/product/11.2.0/grid/bin/EmctlCommon.pm line 597.


      this is the content of sysman log file  emagent.trc

      2010-08-07 01:28:44,551 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:28:44,551 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
      2010-08-07 01:28:44,552 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:28:44,552 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
      2010-08-07 01:29:14,567 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:29:14,567 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
      2010-08-07 01:29:14,568 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:29:14,568 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
      2010-08-07 01:29:15,663 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:29:15,663 Thread-3007904656 ERROR upload: FxferSend: Cannot connect to: https://ora:1158/em/upload/. retStatus=-1
      2010-08-07 01:29:15,663 Thread-3007904656 ERROR upload: Failed to upload file A0000001.xml: HTTP error.
      2010-08-07 01:29:15,749 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:29:15,749 Thread-3007904656 ERROR upload: FxferSend: Cannot connect to: https://ora:1158/em/upload/. retStatus=-1
      2010-08-07 01:29:15,749 Thread-3007904656 ERROR upload: Failed to upload file A0000001.xml: HTTP error.
      2010-08-07 01:29:15,835 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:29:15,835 Thread-3007904656 ERROR upload: FxferSend: Cannot connect to: https://ora:1158/em/upload/. retStatus=-1
      2010-08-07 01:29:15,835 Thread-3007904656 ERROR upload: Failed to upload file A0000001.xml: HTTP error.
      2010-08-07 01:29:15,835 Thread-3007904656 ERROR upload: 3 Failures in a row or XML error for A0000001.xml, retcode = -2, we give up
      2010-08-07 01:29:44,846 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:29:44,846 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
      2010-08-07 01:29:44,846 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
      2010-08-07 01:29:44,846 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1



      this is the content of sysman log emagent.log*

      2010-08-07 01:07:28,469 Thread-3020503952 <Upload Manager> Exceeded Max allowed Upload data - No of files: 114, Size of upload data: 64.885110MB, Pct(%) of Disk used: 8.53%, Disabling collections (00852)
      2010-08-07 01:07:28,469 Thread-3020503952 Disable collector (00406)
      2010-08-07 01:11:24,391 Thread-3007904656 target {orcl, oracle_database} is broken: cannot compute dynamic properties in time. (00155)
      2010-08-07 01:11:24,391 Thread-3017354128 target {+ASM_ora, osm_instance} is broken: cannot compute dynamic properties in time. (00155)
      2010-08-07 01:11:24,824 Thread-3007904656 enable collector (00407)
      2010-08-07 01:11:26,322 Thread-3007904656 <Upload Manager> Exceeded Max allowed Upload data - No of files: 119, Size of upload data: 73.968864MB, Pct(%) of Disk used: 8.53%, Disabling collections (00852)
      2010-08-07 01:11:26,322 Thread-3007904656 Disable collector (00406)
      2010-08-07 01:15:49,209 Thread-3007904656 target {+ASM_ora, osm_instance} is broken: cannot compute dynamic properties in time. (00155)
      2010-08-07 01:15:49,506 Thread-3007904656 enable collector (00407)
      2010-08-07 01:15:50,838 Thread-3023653776 <Upload Manager> Exceeded Max allowed Upload data - No of files: 124, Size of upload data: 82.918961MB, Pct(%) of Disk used: 8.53%, Disabling collections (00852)
      2010-08-07 01:15:50,838 Thread-3023653776 Disable collector (00406)
      2010-08-07 01:16:09,370 Thread-3017354128 target {orcl, oracle_database} is broken: cannot compute dynamic properties in time. (00155)
      2010-08-07 01:16:09,661 Thread-3017354128 enable collector (00407)
      2010-08-07 01:16:10,995 Thread-3023653776 <Upload Manager> Exceeded Max allowed Upload data - No of files: 129, Size of upload data: 91.893702MB, Pct(%) of Disk used: 8.54%, Disabling collections (00852)
      2010-08-07 01:16:10,995 Thread-3023653776 Disable collector (00406)
      2010-08-07 01:19:49,712 Thread-3017354128 target {+ASM_ora, osm_instance} is broken: cannot compute dynamic properties in time. (00155)
      2010-08-07 01:19:50,010 Thread-3017354128 enable collector (00407)
      2010-08-07 01:19:51,346 Thread-3020503952 <Upload Manager> Exceeded Max allowed Upload data - No of files: 134, Size of upload data: 100.843798MB, Pct(%) of Disk used: 8.54%, Disabling collections (00852)
      2010-08-07 01:19:51,346 Thread-3020503952 Disable collector (00406)
      2010-08-07 01:20:09,721 Thread-3004754832 target {orcl, oracle_database} is broken: cannot compute dynamic properties in time. (00155)
      2010-08-07 01:20:10,025 Thread-3004754832 enable collector (00407)
      2010-08-07 01:20:11,520 Thread-3020503952 <Upload Manager> Exceeded Max allowed Upload data - No of files: 139, Size of upload data: 109.818539MB, Pct(%) of Disk used: 8.54%, Disabling collections (00852)
      2010-08-07 01:20:11,520 Thread-3020503952 Disable collector (00406)


      this is my listener

      [oracle@ora bin]$ ./lsnrctl status

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 07-AUG-2010 01:17:50

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
      Start Date 07-AUG-2010 00:42:51
      Uptime 0 days 0 hr. 36 min. 8 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
      Listener Log File /u01/app/oracle/diag/tnslsnr/ora/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.20)(PORT=1523)))
      Services Summary...
      Service "+ASM" has 1 instance(s).
      Instance "+ASM", status READY, has 1 handler(s) for this service...
      Service "orcl" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
      Service "orclXDB" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
      The command completed successfully

      any suggestions + solutions

      thanks

      Edited by: ORACLEZ on Aug 7, 2010 2:03 AM
        • 1. Re: ERROR pingManager: nmepm_pingReposURL: Cannot connect
          Lai-Oracle
          Hi,

          I believe there could be two problems:

          1. the second start command is not working probably due to wrong ORACLE_HOME/ORACLE_SID setting. Can you try to start the database control from ORACLE_HOME/bin using "./emctl start dbconsole"

          2. The issue with accessing the EM Console probably could be due to agent not working. Can you please check and confirm whether the output of following command has a value for all lines:

          ./emctl status agent

          Also check whether emoms.trc file is generated.

          Regards
          Lai
          • 2. Re: ERROR pingManager: nmepm_pingReposURL: Cannot connect
            737000
            Hi  Lai          ,

            This is what i do when I want to stat grid and database

            - (+ASM) Grid Home /u01/app/oracle/product/11.2.0/grid
            - (orcl) Database Home /u01/app/oracle/product/11.2.0/dbhome_1

            - export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
            - export ORACLE_SID=orcl
            - Then cd $ORACLE_HOME
            - ./lsnrctl start
            - ./sqlplus to start database
            - ./emctl start dbconsole

            Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
            Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
            https://ora:1158/em/console/aboutApplication
            Starting Oracle Enterprise Manager 11g Database Control ............. started.
            ------------------------------------------------------------------
            Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/ora_orcl/sysman/log


            Result:
            - I can access database from Sqlplus
            - I can't access database from OEM
            - I noticed when I use this ./lsnrstas it takes long time to give me status after I start ./emctl start dbconsole

            My question which listener should I use ?? grid or dbhome

            and this is the content of emoms.trc I just post last three exceptions

            2010-08-08 01:09:33,508 [HTTPThreadGroup-2] ERROR app.SessionObjectManager sessionDestroyed.128 - java.sql.SQLException: Io exception: Socket read timed out
            java.sql.SQLException: Io exception: Socket read timed out
                 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:77)
                 at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:230)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:501)
                 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:436)
                 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:621)
                 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
                 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
                 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:492)
                 at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:386)
                 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:276)
                 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:212)
                 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:140)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1752)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.makeOneConnection(OracleImplicitConnectionCache.java:644)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.defaultUserPrePopulateCache(OracleImplicitConnectionCache.java:272)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.doForEveryCachedConnection(OracleImplicitConnectionCache.java:1307)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.refreshCacheConnections(OracleImplicitConnectionCache.java:1902)
                 at oracle.jdbc.pool.OracleConnectionCacheManager.refreshCache(OracleConnectionCacheManager.java:756)
                 at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:357)
                 at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:322)
                 at oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:575)
                 at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:207)
                 at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1138)
                 at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1172)
                 at oracle.sysman.eml.app.SessionObjectManager.sessionDestroyed(SessionObjectManager.java:116)
                 at oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:126)
                 at com.evermind.server.http.HttpApplication.invalidateSession(HttpApplication.java:860)
                 at com.evermind.server.http.EvermindHttpSession.invalidate(EvermindHttpSession.java:397)
                 at oracle.sysman.emSDK.sec.auth.EMBaseLoginAdapterImpl.logoff(EMBaseLoginAdapterImpl.java:680)
                 at oracle.sysman.emSDK.sec.auth.EMBaseLoginAdapterImpl.login(EMBaseLoginAdapterImpl.java:629)
                 at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:127)
                 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
                 at oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:165)
                 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
                 at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
                 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
                 at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
                 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
                 at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:357)
                 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
                 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
                 at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
                 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
                 at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
                 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
                 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
                 at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                 at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
                 at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
                 at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
                 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
                 at java.lang.Thread.run(Thread.java:595)
            2010-08-08 01:09:41,094 [shutdownHookThread] WARN jdbc.ConnectionCache _getConnection.352 - Io exception: Socket read timed out
            java.sql.SQLException: Io exception: Socket read timed out
                 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:77)
                 at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:230)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:501)
                 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:436)
                 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:621)
                 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
                 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
                 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:492)
                 at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:386)
                 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:276)
                 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:212)
                 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:140)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1752)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.makeOneConnection(OracleImplicitConnectionCache.java:644)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.getCacheConnection(OracleImplicitConnectionCache.java:592)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:460)
                 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:544)
                 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:480)
                 at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:336)
                 at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:322)
                 at oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:575)
                 at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:207)
                 at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1138)
                 at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1172)
                 at oracle.sysman.eml.app.SessionObjectManager.sessionDestroyed(SessionObjectManager.java:116)
                 at oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:126)
                 at com.evermind.server.http.HttpApplication.invalidateLocalSession(HttpApplication.java:900)
                 at com.evermind.server.http.EvermindHttpSession.invalidateLocal(EvermindHttpSession.java:346)
                 at com.evermind.server.http.HttpApplication.destroySessions(HttpApplication.java:5918)
                 at com.evermind.server.http.HttpApplication.destroy(HttpApplication.java:5860)
                 at com.evermind.server.http.HttpSite.destroy(HttpSite.java:875)
                 at com.evermind.server.http.HttpServer.destroy(HttpServer.java:548)
                 at com.evermind.server.ApplicationServer.destroy(ApplicationServer.java:2074)
                 at com.evermind.server.ApplicationServerShutdownHandler.run(ApplicationServerShutdownHandler.java:93)
                 at java.lang.Thread.run(Thread.java:595)
            2010-08-08 01:09:41,095 [shutdownHookThread] WARN jdbc.ConnectionCache _getConnection.353 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying
            2010-08-08 01:09:44,601 [XMLLoader0] WARN jdbc.ConnectionCache _getConnection.352 - Io exception: Socket read timed out
            java.sql.SQLException: Io exception: Socket read timed out
                 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:77)
                 at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:230)
                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:501)
                 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:436)
                 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:621)
                 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
                 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
                 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:492)
                 at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:386)
                 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:276)
                 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:212)
                 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:140)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1752)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.makeOneConnection(OracleImplicitConnectionCache.java:644)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.getCacheConnection(OracleImplicitConnectionCache.java:592)
                 at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:460)
                 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:544)
                 at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:480)
                 at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:336)
                 at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:322)
                 at oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:575)
                 at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:207)
                 at oracle.sysman.emSDK.svc.conn.ConnectionService.getSystemConnection(ConnectionService.java:1383)
                 at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.getConnection(XMLLoaderContext.java:997)
                 at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.logLoadError(XMLLoaderContext.java:3464)
                 at oracle.sysman.emdrep.dbjava.loader.XMLLoader.run(XMLLoader.java:1263)
                 at java.lang.Thread.run(Thread.java:595)
            2010-08-08 01:09:44,603 [XMLLoader0] WARN jdbc.ConnectionCache _getConnection.353 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning up cache and retrying

            Thank you my friend for response