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