Re: TNS-12514 randomly(?)

On 6 Aug 2002 07:38:38 -0700, voronov_at_milcse.cig.mot.com (Alek Voronov) wrote:

>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.

Check your listener.ora against the connection string above. If the host port service_name combo isn't exactly identical to the connection string you get 12514

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Aug 06 2002 - 12:46:52 CDT