Connections Fail Reporting ORA-12169: TNS:Net service name given as connect identifier is too long (Doc ID 361843.1)

Last updated on APRIL 14, 2014

Applies to:

Oracle Net Services - Version 8.1.7.0.0 to 10.2.0.1.0 [Release 8.1.7 to 10.2]
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 to 11.1.1.7.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

Connections to database, over Oracle Net fail reporting error code :

     ORA-12169: TNS:Net service name given as connect identifier is too long.

or eg. tnsping may fail with:

     TNS-3505: Failed to resolve name

ORA-12169 can be reported in a error stack, similar to following, if stored procedure, database link is failing :
   
    ORA-03113: end-of-file on communication channel
    ORA-01591: lock held by in-doubt distributed transaction 3.16.62978
    ORA-12169: TNS:Net service name given as connect identifier is too long

An Oracle Net client trace of the failure may show the following symptoms, but is not limited to these examples. 

Local naming resolution, (TNSNAMES.ORA) failure to read file 100% correctly:

[16-OCT-2010 01:06:23:655] nnftmlf_make_local_addrfile: entry
[16-OCT-2010 01:06:23:655] nnftmlf_make_local_addrfile: construction of local names file failed
[16-OCT-2010 01:06:23:655] nnftmlf_make_local_addrfile: ex


dump of the entry showing address with white spaces:

[16-OCT-2010 01:06:23:655] nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (load_balance=off) (failover=on) (ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1526)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sample.com) (FAILOVER_MODE = (TYPE=session) (METHOD=BASIC) (RETRIES=180) (DELAY =5)) ) ) for name sample.com


That is white spaces after second port and delay.

(PORT = 1526)) )
(DELAY =5)) ) )

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms