clients connections failed intermittently [message #560750] |
Mon, 16 July 2012 12:21 |
|
kroval
Messages: 1 Registered: July 2012
|
Junior Member |
|
|
Hi,
I have some problem between my database and the listener
Sometimes I have connection errors:
The error occurred intermittently
Oracle 11.2.0.2.0 on RHEL 5
My listener:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
)
)
)
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
ADMIN_RESTRICTIONS_LISTENER = ON
INBOUND_CONNECT_TIMEOUT_LISTENER=100
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
The listener starts and stops normally
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
>lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 16-JUL-2012 17:51:09
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /opt/oracle/product/EE_11.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
System parameter file is /opt/oracle/product/EE_11.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/xxxxxx/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 16-JUL-2012 17:51:09
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/EE_11.2.0/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/xxxxxx/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521)))
The listener supports no services
The command completed successfully
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
But there is an error when the database register into the listener (in listener.log):
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
Started with pid=4029
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
16-JUL-2012 17:51:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=xxxxxx)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
Error listening on: (address=(protocol=tcp)(host=)(port=1521))
16-JUL-2012 17:51:11 * service_register * MySid * 12542
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Mon Jul 16 17:51:29 2012
16-JUL-2012 17:51:29 * service_update * MySid * 0
Mon Jul 16 17:51:40 2012
16-JUL-2012 17:51:40 * (CONNECT_DATA=(SID=MySid)(CID=(USER=userinfo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.y.zz)(PORT=12867)) * establish * MySid * 0
16-JUL-2012 17:51:41 * service_update * MySid * 0
16-JUL-2012 17:51:44 * service_update * MySid * 0
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
And sometimes connection from clients failed
Errors from client side is
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
Logs from server side:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
Mon Jul 16 17:31:00 2012
16-JUL-2012 17:31:00 * (CONNECT_DATA=(SID=MySid)(CID=(PROGRAM=python)(HOST=someclient)(USER=userinfo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.y.zz)(PORT=48608)) * establish * MySid * 0
16-JUL-2012 17:31:00 * (CONNECT_DATA=(SID=MySid)(CID=(PROGRAM=python)(HOST=someclient)(USER=userinfo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.y.zz)(PORT=48609)) * establish * MySid * 0
16-JUL-2012 17:31:00 * (CONNECT_DATA=(SID=MySid)(CID=(PROGRAM=python)(HOST=someclient)(USER=userinfo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.y.zz)(PORT=48610)) * establish * MySid * 0
16-JUL-2012 17:31:00 * (CONNECT_DATA=(SID=MySid)(CID=(PROGRAM=python)(HOST=someclient)(USER=userinfo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.y.zz)(PORT=48611)) * establish * MySid * 0
Trace information written to /opt/oracle/diag/tnslsnr/xxxxxx/listener/trace/ora_20905_47072288658208.trc
Trace level is currently 0
Log messages written to /opt/oracle/diag/tnslsnr/xxxxxx/listener/alert/log.xml
16-JUL-2012 17:31:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=xxxxxx)(USER=oracle))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * reload * 0
16-JUL-2012 17:31:01 * (CONNECT_DATA=(SID=MySid)(CID=(PROGRAM=python)(HOST=xxxxxx)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.y.zz)(PORT=29599)) * establish * MySid * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
Error listening on: (address=(protocol=tcp)(host=)(port=1521))
16-JUL-2012 17:31:01 * service_register * MySid * 12542
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Mon Jul 16 17:31:16 2012
16-JUL-2012 17:31:16 * service_update * MySid * 0
Mon Jul 16 17:31:34 2012
16-JUL-2012 17:31:34 * service_update * MySid * 0
16-JUL-2012 17:31:40 * (CONNECT_DATA=(SID=MySid)(CID=(USER=userinfo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.y.zz)(PORT=43253)) * establish * MySid * 0
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
The error occur exactly twice per hour:
grep service_register listener.log | grep 12542
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
15-JUL-2012 00:01:02 * service_register * MySid* 12542
15-JUL-2012 00:31:02 * service_register * MySid* 12542
15-JUL-2012 01:01:01 * service_register * MySid* 12542
15-JUL-2012 01:31:01 * service_register * MySid* 12542
15-JUL-2012 02:01:04 * service_register * MySid* 12542
15-JUL-2012 02:31:01 * service_register * MySid* 12542
15-JUL-2012 03:01:04 * service_register * MySid* 12542
15-JUL-2012 03:31:03 * service_register * MySid* 12542
15-JUL-2012 04:01:03 * service_register * MySid* 12542
15-JUL-2012 04:31:03 * service_register * MySid* 12542
15-JUL-2012 05:01:03 * service_register * MySid* 12542
15-JUL-2012 05:31:03 * service_register * MySid* 12542
15-JUL-2012 06:01:02 * service_register * MySid* 12542
15-JUL-2012 06:31:02 * service_register * MySid* 12542
15-JUL-2012 07:01:02 * service_register * MySid* 12542
15-JUL-2012 07:31:02 * service_register * MySid* 12542
15-JUL-2012 08:01:01 * service_register * MySid* 12542
15-JUL-2012 08:31:04 * service_register * MySid* 12542
15-JUL-2012 09:01:01 * service_register * MySid* 12542
15-JUL-2012 09:31:01 * service_register * MySid* 12542
15-JUL-2012 10:01:04 * service_register * MySid* 12542
15-JUL-2012 10:31:03 * service_register * MySid* 12542
15-JUL-2012 11:01:03 * service_register * MySid* 12542
15-JUL-2012 11:31:03 * service_register * MySid* 12542
15-JUL-2012 12:01:03 * service_register * MySid* 12542
15-JUL-2012 12:31:03 * service_register * MySid* 12542
15-JUL-2012 13:01:02 * service_register * MySid* 12542
15-JUL-2012 13:31:02 * service_register * MySid* 12542
15-JUL-2012 14:01:02 * service_register * MySid* 12542
15-JUL-2012 14:31:02 * service_register * MySid* 12542
15-JUL-2012 15:01:02 * service_register * MySid* 12542
15-JUL-2012 15:31:01 * service_register * MySid* 12542
15-JUL-2012 16:01:01 * service_register * MySid* 12542
15-JUL-2012 16:31:01 * service_register * MySid* 12542
15-JUL-2012 17:01:04 * service_register * MySid* 12542
15-JUL-2012 17:31:04 * service_register * MySid* 12542
15-JUL-2012 18:01:03 * service_register * MySid* 12542
15-JUL-2012 18:31:03 * service_register * MySid* 12542
15-JUL-2012 19:01:03 * service_register * MySid* 12542
15-JUL-2012 19:31:03 * service_register * MySid* 12542
15-JUL-2012 20:01:03 * service_register * MySid* 12542
15-JUL-2012 20:31:02 * service_register * MySid* 12542
15-JUL-2012 21:01:02 * service_register * MySid* 12542
15-JUL-2012 21:31:02 * service_register * MySid* 12542
15-JUL-2012 22:01:02 * service_register * MySid* 12542
15-JUL-2012 22:31:01 * service_register * MySid* 12542
15-JUL-2012 23:01:01 * service_register * MySid* 12542
15-JUL-2012 23:31:01 * service_register * MySid* 12542
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
Have any Idea?
|
|
|
|
Re: clients connections failed intermittently [message #561895 is a reply to message #560751] |
Thu, 26 July 2012 03:04 |
nqtrung
Messages: 25 Registered: April 2007
|
Junior Member |
|
|
You try configure listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = $ORACLE_SID)
(ORACLE_HOME = $ORACLE_HOME)
(SID_NAME = $ORACLE_SID)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))
)
)
Good luck
|
|
|