This discussion is archived
12 Replies Latest reply: May 7, 2012 1:08 PM by 935331 RSS

java.sql.SQLException: Listener refused the connection

935331 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    <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 Guru
    Currently Being Moderated
    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
    934160 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    dear sb92075, it's not a snipe hunt. i really need help
  • 11. Re: java.sql.SQLException: Listener refused the connection
    sb92075 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    thanks a lot for your help, i'm trying to do something now using your prompts.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points