TNS-12514 randomly(?)

From: Alek Voronov <voronov_at_milcse.cig.mot.com>
Date: 6 Aug 2002 07:38:38 -0700
Message-ID: <8300330.0208060638.f699058@posting.google.com>

Oracle Gurus,

sometimes one of HP applications fails and this is what I get in /usr/ORACLE/u01/app/oracle/product/9.0.1/network/log/listener.log:

06-AUG-2002 14:04:20 *
(CONNECT_DATA=(SERVICE_NAME=synosrv.milcse)(CID=(PROGRAM=
)(HOST=alpha31.milcse)(USER=root))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=145.9.239.146
)(PORT=2401)) * establish * synosrv.milcse * 12514 TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect descript
or

06-AUG-2002 14:04:50 *
(CONNECT_DATA=(SERVICE_NAME=synosrv.milcse)(CID=(PROGRAM=
)(HOST=alpha31.milcse)(USER=root))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=145.9.239.146
)(PORT=2402)) * establish * synosrv.milcse * 12514 TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect descript
or

06-AUG-2002 14:05:21 *
(CONNECT_DATA=(SERVICE_NAME=synosrv.milcse)(CID=(PROGRAM=
)(HOST=alpha31.milcse)(USER=root))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=145.9.239.146
)(PORT=2406)) * establish * synosrv.milcse * 0

What does it mean? There were 3 attempts (on different ports?) to connect to the Db - 2 failed and 1 succeeded? Randomly? Why?

Any help will be very appreciated!

Thanks, Alek. Received on Tue Aug 06 2002 - 09:38:38 CDT