Home » RDBMS Server » Networking and Gateways » clients connections failed intermittently (Oracle 11.2.0.2.0 on RHEL 5)
clients connections failed intermittently [message #560750] Mon, 16 July 2012 12:21 Go to next message
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 #560751 is a reply to message #560750] Mon, 16 July 2012 12:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
you did a fine job of obfuscating reality

bcm@bcm-laptop:~$ oerr tns 12542
12542, 00000, "TNS:address already in use"
// *Cause: Specified listener address is already being used.
// *Action: Start your listener with a unique address.
bcm@bcm-laptop:~$
Re: clients connections failed intermittently [message #561895 is a reply to message #560751] Thu, 26 July 2012 03:04 Go to previous message
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
Previous Topic: Connecting two oracle database in different server
Next Topic: Steps for Access remote Oracle Db [VB-Oracle-10G]
Goto Forum:
  


Current Time: Thu Mar 28 03:07:29 CDT 2024