13 Replies Latest reply on Oct 23, 2006 6:12 PM by 541351

    HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...

    371156
      Can anyone help me figure out this exception?

      TIA!

      Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
      java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
           at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
           at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
           at java.sql.DriverManager.getConnection(DriverManager.java:512)
           at java.sql.DriverManager.getConnection(DriverManager.java:171)
           at org.apache.jsp.view_jsp._jspService(view_jsp.java:77)
           at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
           at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
           at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
           at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
           at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
           at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
           at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
           at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
           at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
           at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
           at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
           at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
           at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
           at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
           at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
           at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
           at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
           at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
           at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
           at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
           at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261)
           at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
           at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604)
           at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562)
           at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679)
           at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
           at java.lang.Thread.run(Thread.java:534)
        • 1. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
          Kamal Kishore
          $ oerr ora 12505
          12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor"
          // *Cause:  The listener received a request to establish a connection to a
          // database or other service. The connect descriptor received by the listener
          // specified a SID for an instance (usually a database instance) that either
          // has not yet dynamically registered with the listener or has not been
          // statically configured for the listener. This may be a temporary condition
          // such as after the listener has started, but before the database instance
          // has registered with the listener.
          // *Action:
          // - Wait a moment and try to connect a second time.
          // - Check which instances are currently known by the listener by executing:
          // lsnrctl services <listener name>
          // - Check that the SID parameter in the connect descriptor specifies
          // an instance known by the listener.
          // - Check for an event in the listener.log file.
          $
          • 2. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
            371156
            Kamal thank alot for the quick response. I'm heading out rite now but when I get back I will try and let you know.

            Rick.
            • 3. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
              371156
              When I run lsnrctl services this is what I get...


              [oracle@ds26 network]$ lsnrctl services

              LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 17-JUL-2005 19:54:40

              Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
              Services Summary...
              Service "PLSExtProc" has 1 instance(s).
              Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
              Handler(s):
              "DEDICATED" established:0 refused:0
              LOCAL SERVER
              Service "db9i" has 2 instance(s).
              Instance "db9i", status UNKNOWN, has 1 handler(s) for this service...
              Handler(s):
              "DEDICATED" established:0 refused:0
              LOCAL SERVER
              Instance "db9i", status READY, has 2 handler(s) for this service...
              Handler(s):
              "D000" established:762 refused:0 current:73 max:1002 state:ready
              DISPATCHER <machine: some.domain.net, pid: 1903>
              (ADDRESS=(PROTOCOL=tcp)(HOST=203.432.54.66)(PORT=32769))
              "DEDICATED" established:0 refused:0 state:ready
              LOCAL SERVER
              The command completed successfully
              [oracle@ds26 network]$
              • 4. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                371156
                Here is my listener.ora file...


                # LISTENER.ORA Network Configuration File: /home/oracle/Oracle9i/product/9.2.0/network/admin/listener.ora
                # Generated by Oracle configuration tools.

                LISTENER =
                (DESCRIPTION_LIST =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
                )
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = some.domain.net)(PORT = 1521))
                )
                )
                )

                SID_LIST_LISTENER =
                (SID_LIST =
                (SID_DESC =
                (SID_NAME = PLSExtProc)
                (ORACLE_HOME = /home/oracle/Oracle9i/product/9.2.0)
                (PROGRAM = extproc)
                )
                (SID_DESC =
                (GLOBAL_DBNAME = db9i)
                (ORACLE_HOME = /home/oracle/Oracle9i/product/9.2.0)
                (SID_NAME = db9i)
                )
                )

                • 5. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                  371156
                  Here is my tnsnames.ora...

                  # TNSNAMES.ORA Network Configuration File: /home/oracle/Oracle9i/product/9.2.0/network/admin/tnsnames.ora
                  # Generated by Oracle configuration tools.

                  DB9I.432.54.66 =
                  (DESCRIPTION =
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = some.domain.net)(PORT = 1521))
                  )
                  (CONNECT_DATA =
                  (SERVICE_NAME = db9i)
                  )
                  )

                  EXTPROC_CONNECTION_DATA.432.54.66 =
                  (DESCRIPTION =
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
                  )
                  (CONNECT_DATA =
                  (SID = PLSExtProc)
                  (PRESENTATION = RO)
                  )
                  )

                  INST1_HTTP.432.54.66 =
                  (DESCRIPTION =
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
                  )
                  (CONNECT_DATA =
                  (SERVER = SHARED)
                  (SERVICE_NAME = MODOSE)
                  (PRESENTATION = http://HRService)
                  )
                  )

                  • 6. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                    371156
                    Here is the listener.log file...
                    TNSLSNR for Linux: Version 9.2.0.1.0 - Production on 16-MAY-2005 23:37:18

                    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

                    System parameter file is /home/oracle/Oracle9i/product/9.2.0/network/admin/listener.ora
                    Log messages written to /home/oracle/Oracle9i/product/9.2.0/network/log/listener.log
                    Trace information written to /home/oracle/Oracle9i/product/9.2.0/network/trace/listener.trc
                    Trace level is currently 0

                    Started with pid=11876
                    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
                    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=432.54.66.203.sfldmi01.ce.domain.net)(PORT=1521)))
                    TNS-12545: Connect failed because target host or object does not exist
                    TNS-12560: TNS:protocol adapter error
                    TNS-00515: Connect failed because target host or object does not exist

                    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

                    • 7. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                      371156
                      Can anyone help me out on this one?

                      TIA...
                      • 8. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                        Kamal Kishore
                        What happens when you do:
                        tnsping DB9I.432.54.66
                        and
                        sqlplus user/password@DB9I.432.54.66
                        What is the connect string for your java code looks like?
                        • 9. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                          Kamal Kishore
                          And also post the contents of your sqlnet.ora file.
                          • 10. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                            371156
                            Output from ping...


                            [oracle@ds26 oracle]$ tnsping DB9I.432.54.66

                            TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 18-JUL-2005 23:24:15

                            Copyright (c) 1997 Oracle Corporation. All rights reserved.

                            Used parameter files:
                            /home/oracle/Oracle9i/product/9.2.0/network/admin/sqlnet.ora


                            Used TNSNAMES adapter to resolve the alias
                            Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = some.domain.net)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = db9i)))
                            OK (10 msec)
                            [oracle@ds26 oracle]$
                            • 11. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                              371156
                              sqlnet.ora file...

                              # SQLNET.ORA Network Configuration File: /home/oracle/Oracle9i/product/9.2.0/network/admin/sqlnet.ora
                              # Generated by Oracle configuration tools.

                              NAMES.DEFAULT_DOMAIN = 432.54.66

                              NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
                              • 12. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                                371156
                                I can connect fine with...

                                sqlplus user/password@DB9I.432.54.66
                                • 13. Re: HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(...
                                  541351
                                  hi,
                                  I have the same problem
                                  The solution you gave is to go to sql prompt but how do u connect from java to avoid the exception