12 Replies Latest reply: May 7, 2012 3:08 PM by 935331 RSS

    java.sql.SQLException: Listener refused the connection

    935331
      hi everybody!
      i'm new in oracle and java and have a problem working in Oracle 11g ExpressEdition.
      i have the next error when i'm trying to start java project using oracle:

      incorrect login or password

      and the next:

      java.sql.SQLException: Listener refused the connection with the following error:

      ORA-12505, TNS:listener does not currently know of SID given in connect descript
      or

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
      +531)+
      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
      n.java:32)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
      at java.sql.DriverManager.getConnection(Unknown Source)
      at java.sql.DriverManager.getConnection(Unknown Source)
      at tools.db.ConnectionFactory.getOracleConnection(ConnectionFactory.java
      +:30)+
      at tools.db.DatabaseTools.checkAuthorizationInfo(DatabaseTools.java:24)
      at mainforms.LoginForm.jButton1ActionPerformed(LoginForm.java:112)
      at mainforms.LoginForm.access$000(LoginForm.java:16)
      at mainforms.LoginForm$1.actionPerformed(LoginForm.java:52)
      at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
      at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
      at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
      ce)
      at java.awt.Component.processMouseEvent(Unknown Source)
      at javax.swing.JComponent.processMouseEvent(Unknown Source)
      at java.awt.Component.processEvent(Unknown Source)
      at java.awt.Container.processEvent(Unknown Source)
      at java.awt.Component.dispatchEventImpl(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Window.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
      at java.awt.EventQueue.access$000(Unknown Source)
      at java.awt.EventQueue$3.run(Unknown Source)
      at java.awt.EventQueue$3.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Sour
      ce)
      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Sour
      ce)
      at java.awt.EventQueue$4.run(Unknown Source)
      at java.awt.EventQueue$4.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Sour
      ce)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.run(Unknown Source)
      Caused by: oracle.net.ns.NetException: Listener refused the connection with the
      following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descript
      or

      at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
      at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
      +... 47 more+

      my listener.ora file content:
      SID_LIST_LISTENER =
      +(SID_LIST =+
      +(SID_DESC =+
      +(SID_NAME = PLSExtProc)+
      +(ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server)+
      +(PROGRAM = extproc)+
      +)+
      +(SID_DESC =+
      +(SID_NAME = CLRExtProc)+
      +(ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server)+
      +(PROGRAM = extproc)+
      +)+
      +)+

      LISTENER =
      +(DESCRIPTION_LIST =+
      +(DESCRIPTION =+
      +(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))+
      +(ADDRESS = (PROTOCOL = TCP)(HOST = Home)(PORT = 1521))+
      +)+
      +)+

      DEFAULT_SERVICE_LISTENER = (XE)

      and tnsnames.ora file content:
      XE =
      +(DESCRIPTION =+
      +(ADDRESS = (PROTOCOL = TCP)(HOST = Home)(PORT = 1521))+
      +(CONNECT_DATA =+
      +(SERVER = DEDICATED)+
      +(SERVICE_NAME = XE)+
      +)+
      +)+

      EXTPROC_CONNECTION_DATA =
      +(DESCRIPTION =+
      +(ADDRESS_LIST =+
      +(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))+
      +)+
      +(CONNECT_DATA =+
      +(SID = PLSExtProc)+
      +(PRESENTATION = RO)+
      +)+
      +)+

      ORACLR_CONNECTION_DATA =
      +(DESCRIPTION =+
      +(ADDRESS_LIST =+
      +(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))+
      +)+
      +(CONNECT_DATA =+
      +(SID = CLRExtProc)+
      +(PRESENTATION = RO)+
      +)+
      +)+

      and results of commands:

      C:\Users\Admin>lsnrctl service

      LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 06-╠└╔-2012
      +:13+

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service.
      Handler(s):
      +"DEDICATED" established:0 refused:0+
      LOCAL SERVER
      +"ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready+
      CLRExtProc
      +(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_C54_1CECCED2_7DC8.OR+
      +"ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready+
      CLRExtProc
      +(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_C54_1CECCED2_B57B.OR+
      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 "XEXDB" has 1 instance(s).
      Instance "xe", status READY, has 1 handler(s) for this service...
      Handler(s):
      +"D000" established:0 refused:0 current:0 max:1022 state:ready+
      DISPATCHER <machine: HOME, pid: 3280>
      +(ADDRESS=(PROTOCOL=tcp)(HOST=Home)(PORT=56207))+
      Service "xe" has 1 instance(s).
      Instance "xe", status READY, has 1 handler(s) for this service...
      Handler(s):
      +"DEDICATED" established:1 refused:0 state:ready+
      LOCAL SERVER
      The command completed successfully

      and

      C:\Users\Admin>tnsping XE

      TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 06-╠└╔-2
      +012 13:22:40+

      Copyright (c) 1997, 2010, Oracle. All rights reserved.

      Used parameter files:
      D:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\sqlnet.ora


      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Home)(PO
      RT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
      OK (10 msec)

      dont understand what the reason of problem. read many forums and try this and that but can't resolve it (haven't enough knowledges :( ).
      will be very thankful for a help everybody.
        • 1. Re: java.sql.SQLException: Listener refused the connection
          sb92075
          932328 wrote:
          hi everybody!
          i'm new in oracle and java and have a problem working in Oracle 11g ExpressEdition.
          i have the next error when i'm trying to start java project using oracle:

          incorrect login or password

          and the next:

          java.sql.SQLException: Listener refused the connection with the following error:

          ORA-12505, TNS:listener does not currently know of SID given in connect descript
          post results from following OS commands

          lsnrctl status
          lsnrctl service

          COPY commands & results then PASTE all back here
          • 2. Re: java.sql.SQLException: Listener refused the connection
            935331
            here is the the result:

            D:\...path...>lsnrctl status

            LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 06-╠└╔-2012 19:15
            :15

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
            ction
            Start Date 06-╠└╔-2012 17:02:18
            Uptime 0 days 2 hr. 12 min. 57 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Default Service XEXDB
            Listener Parameter File D:\oraclexe\app\oracle\product\11.2.0\server\network\A
            DMIN\listener.ora
            Listener Log File D:\oraclexe\app\oracle\diag\tnslsnr\Home\listener\aler
            t\log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Home)(PORT=1521)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Home)(PORT=8080))(Presentation=HTTP)
            (Session=RAW))
            Services Summary...
            Service "CLRExtProc" has 1 instance(s).
            Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Service "XEXDB" has 1 instance(s).
            Instance "xe", status READY, has 1 handler(s) for this service...
            Service "xe" has 1 instance(s).
            Instance "xe", status READY, has 1 handler(s) for this service...
            The command completed successfully


            D:\...path...>lsnrctl service

            LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 06-╠└╔-2012 19:19
            :09

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
            Services Summary...
            Service "CLRExtProc" has 1 instance(s).
            Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:0 refused:0
            LOCAL SERVER
            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 "XEXDB" has 1 instance(s).
            Instance "xe", status READY, has 1 handler(s) for this service...
            Handler(s):
            "D000" established:0 refused:0 current:0 max:1022 state:ready
            DISPATCHER <machine: HOME, pid: 2428>
            (ADDRESS=(PROTOCOL=tcp)(HOST=Home)(PORT=49162))
            Service "xe" has 1 instance(s).
            Instance "xe", status READY, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:1 refused:0 state:ready
            LOCAL SERVER
            The command completed successfully

            and i've changed the ora-files(rename service), then stopped listener, started it but results the same - the described error

            now listener.ora:
            SID_LIST_LISTENER =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server)
            (PROGRAM = extproc)
            )
            (SID_DESC =
            (SID_NAME = CLRExtProc)
            (ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server)
            (PROGRAM = extproc)
            )
            )

            LISTENER =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
            (ADDRESS = (PROTOCOL = TCP)(HOST = Home)(PORT = 1521))
            )
            )

            DEFAULT_SERVICE_LISTENER = (*XEXDB*)

            now tnsnames.ora:
            XE =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = Home)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = XEXDB)
            )
            )

            EXTPROC_CONNECTION_DATA =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
            )
            (CONNECT_DATA =
            (SID = PLSExtProc)
            (PRESENTATION = RO)
            )
            )

            ORACLR_CONNECTION_DATA =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
            )
            (CONNECT_DATA =
            (SID = CLRExtProc)
            (PRESENTATION = RO)
            )
            )
            • 3. Re: java.sql.SQLException: Listener refused the connection
              sb92075
              932328 wrote:
              here is the the result:

              D:\...path...>lsnrctl status

              LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 06-╠└╔-2012 19:15
              :15

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

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
              STATUS of the LISTENER
              ------------------------
              Alias LISTENER
              Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
              ction
              Start Date 06-╠└╔-2012 17:02:18
              Uptime 0 days 2 hr. 12 min. 57 sec
              Trace Level off
              Security ON: Local OS Authentication
              SNMP OFF
              Default Service XEXDB
              Listener Parameter File D:\oraclexe\app\oracle\product\11.2.0\server\network\A
              DMIN\listener.ora
              Listener Log File D:\oraclexe\app\oracle\diag\tnslsnr\Home\listener\aler
              t\log.xml
              force the failure again, again
              then post last 100 or so lines from file below
              D:\oraclexe\app\oracle\diag\tnslsnr\Home\listener\alert\log.xml
              • 4. Re: java.sql.SQLException: Listener refused the connection
                935331
                <msg time='2012-05-06T16:58:11.735+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 16:58:11 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T16:58:44.738+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 16:58:44 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:00:02.856+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:00:02 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:00:14.900+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:00:14 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:00:45.008+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:00:45 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:00:48.018+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:00:48 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:18.460+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>System parameter file is D:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:18.819+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Log messages written to D:\oraclexe\app\oracle\diag\tnslsnr\Home\listener\alert\log.xml
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:18.819+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Trace information written to D:\oraclexe\app\oracle\diag\tnslsnr\Home\listener\trace\ora_108_424.trc
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:18.819+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Trace level is currently 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:18.819+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:18.835+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Started with pid=108
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:18.928+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:18.944+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Home)(PORT=1521)))
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:20.582+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Listener completed notification to CRS on start
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:20.629+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>
                TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:48.865+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Home)(PORT=1521)))
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:48.880+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:02:48 * service_register * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:02:51.876+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:02:51 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:03:02.062+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:03:02 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:03:16.508+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:03:16 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:03:22.545+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Home)(PORT=8080))(Presentation=HTTP)(Session=RAW))
                </txt>
                </msg>
                <msg time='2012-05-06T17:03:22.545+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:03:22 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:03:25.541+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:03:25 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:03:49.620+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:03:49 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:03:58.590+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:03:58 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:04:01.616+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:04:01 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:04:19.656+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:04:19 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:07:14.278+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:07:14 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:09:59.872+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:09:59 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:10:32.991+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:10:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:12:45.466+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:12:45 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:13:24.607+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:13:24 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:16:37.298+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:16:37 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:21:38.379+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:21:38 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:23:26.768+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:23:26 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:25:03.114+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:25:03 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:25:33.222+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:25:33 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:30:01.183+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:30:01 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:30:25.270+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:30:25 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:30:34.302+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:30:34 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:30:58.389+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:30:58 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:33:28.929+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:33:28 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:34:17.102+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:34:17 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:37:35.815+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:37:35 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:38:42.053+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:38:42 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:40:33.452+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:40:33 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:43:31.090+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:43:31 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:45:31.522+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:45:31 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:50:32.603+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:50:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:53:33.251+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:53:33 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T17:58:31.321+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 17:58:31 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:00:01.645+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:00:01 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:00:31.753+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:00:31 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:00:46.807+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:00:46 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:03:35.412+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:03:35 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:05:32.833+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:05:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:10:33.914+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:10:33 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:12:55.531+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:12:55 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:13:04.554+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:13:04 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:13:37.674+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:13:37 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:14:44.029+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:14:44 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:15:18.183+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:15:18 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:15:36.949+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:15:36 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:15:51.962+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:15:51 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:16:25.322+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:16:25 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:17:32.063+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:17:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:18:05.088+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:18:05 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:18:35.113+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:18:35 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:22:56.145+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:22:56 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:28:05.164+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:28:05 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:32:56.183+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:32:56 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:40:32.214+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:40:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:42:56.223+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:42:56 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:50:32.253+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:50:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:52:56.264+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:52:56 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:55:32.367+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:55:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T18:59:11.545+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 18:59:11 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:00:29.688+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:00:29 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:00:44.689+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:00:44 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:01:23.703+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:01:23 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:02:56.736+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:02:56 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:03:47.752+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:03:47 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:04:53.767+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:04:53 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:05:59.798+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:05:59 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:07:39.042+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:07:39 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:08:15.113+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:08:15 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:09:54.206+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:09:54 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:11:36.299+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:11:36 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:12:00.312+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:11:59 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=Admin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50478)) * establish * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:12:57.354+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:12:57 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:13:51.913+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:13:51 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:14:24.936+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:14:24 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:14:51.721+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:14:51 * (CONNECT_DATA=(SID=LogistDB)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Admin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50621)) * establish * LogistDB * 12505
                </txt>
                </msg>
                <msg time='2012-05-06T19:14:51.750+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
                </txt>
                </msg>
                <msg time='2012-05-06T19:15:15.587+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:15:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Admin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:17:10.428+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:17:10 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:18:22.597+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:18:22 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:19:09.605+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:19:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Admin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * services * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:20:31.674+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:20:31 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:21:40.732+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:21:40 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:22:13.988+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:22:13 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:22:46.995+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:22:46 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:22:58.999+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:22:58 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:25:32.370+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:25:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:26:44.417+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:26:44 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:27:50.575+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:27:50 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:28:11.590+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:28:11 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:31:12.568+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:31:12 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:31:48.599+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:31:48 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:33:00.647+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:33:00 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:35:30.764+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:35:30 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:38:15.875+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:38:15 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:42:55.204+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:42:55 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:43:01.206+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:43:01 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:43:28.485+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:43:28 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:44:35.170+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:44:35 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:45:08.144+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:45:08 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:45:32.165+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:45:32 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:45:41.176+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:45:41 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:46:14.280+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:46:14 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:46:47.320+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:46:47 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:47:20.333+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:47:20 * service_update * xe * 0
                </txt>
                </msg>
                <msg time='2012-05-06T19:53:02.663+04:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='HOME'
                host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                <txt>06-МАЙ-2012 19:53:02 * service_update * xe * 0
                </txt>
                </msg>
                • 5. Re: java.sql.SQLException: Listener refused the connection
                  sb92075
                  932328 wrote:
                  <msg time='2012-05-06T19:14:51.721+04:00' org_id='oracle' comp_id='tnslsnr'
                  type='UNKNOWN' level='16' host_id='HOME'
                  host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                  <txt>06-МАЙ-2012 19:14:51 * (CONNECT_DATA=(SID=LogistDB)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Admin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50621)) * establish * LogistDB * 12505
                  </txt>
                  </msg>
                  <msg time='2012-05-06T19:14:51.750+04:00' org_id='oracle' comp_id='tnslsnr'
                  type='UNKNOWN' level='16' host_id='HOME'
                  host_addr='fe80::cd1d:33c3:f2cc:7ca0%17'>
                  <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
                  </txt>
                  </msg>
                  some JAVA code is requesting to connect to SERVICE LogistDB & the listener does about anything about this SERVICE
                  • 6. Re: java.sql.SQLException: Listener refused the connection
                    krramnik
                    Not sure, if your Java program is on the same machine as database.
                    You may need to check the SID used in your Java Program setting(in the so called, 'connect descriptor') , and then try tnsping for that SID from the Java machine itself.

                    Also verify the correctness of username and password used by the Java program to connect to the database. Check whether those credentials work , if you try to connect to the database through sqlplus.

                    Edited by: krramnik on May 7, 2012 5:27 AM

                    Edited by: krramnik on May 7, 2012 5:29 AM
                    • 7. Re: java.sql.SQLException: Listener refused the connection
                      sb92075
                      krramnik wrote:
                      Not sure, if your Java program is on the same machine as database.
                      Why are you not sure?

                      *(HOST=127.0.0.1)*

                      No remote system can get localhost; 127.0.0.1!
                      • 8. Re: java.sql.SQLException: Listener refused the connection
                        935331
                        i'm sorry, but how to do that: "You may need to check the SID used in your Java Program setting(in the so called, 'connect descriptor') , and then try tnsping for that SID from the Java machine itself."
                        here my tnsnames.ora:
                        XE =
                        (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = Home)(PORT = 1521))
                        (CONNECT_DATA =
                        (SERVER = DEDICATED)
                        (SERVICE_NAME = XEXDB)
                        )
                        )

                        EXTPROC_CONNECTION_DATA =
                        (DESCRIPTION =
                        (ADDRESS_LIST =
                        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                        )
                        (CONNECT_DATA =
                        (SID = PLSExtProc)
                        (PRESENTATION = RO)
                        )
                        )

                        ORACLR_CONNECTION_DATA =
                        (DESCRIPTION =
                        (ADDRESS_LIST =
                        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                        )
                        (CONNECT_DATA =
                        (SID = CLRExtProc)
                        (PRESENTATION = RO)
                        )
                        )


                        username and login are correct.
                        • 9. Re: java.sql.SQLException: Listener refused the connection
                          sb92075
                          932328 wrote:
                          i'm sorry, but how to do that:
                          Good Luck on your Snipe Hunt

                          http://en.wikipedia.org/wiki/Snipe_hunt
                          • 10. Re: java.sql.SQLException: Listener refused the connection
                            935331
                            dear sb92075, it's not a snipe hunt. i really need help
                            • 11. Re: java.sql.SQLException: Listener refused the connection
                              sb92075
                              932328 wrote:
                              dear sb92075, it's not a snipe hunt. i really need help
                              some JAVA code is requesting to connect to SERVICE LogistDB & the listener does about anything about this SERVICE


                              Either change Java code to ask for known SERVICE or provide LogistDB instance
                              • 12. Re: java.sql.SQLException: Listener refused the connection
                                935331
                                thanks a lot for your help, i'm trying to do something now using your prompts.