Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

ORA-12163: TNS:connect descriptor is too long

ORA-12163: TNS:connect descriptor is too long..

Answer / guest

Cause: The connect descriptor corresponding to the net
service name specified as the connect identifier is too
long. The maximum length for a connect descriptor is 512
bytes and this limit has been exceeded.

Action: Check the net service name's connect descriptor in
the local naming file (TNSNAMES.ORA) or in the directory
server (Oracle Internet Directory). Use a smaller connect
descriptor. If this is not possible, contact Worldwide
Customer Support.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMP-00016: required character set conversion (type number to number) not supported

1 Answers  

ORA-13369: invalid value for etype in the 4-digit format

1 Answers  

ORA-24170: %s.string is created by AQ, cannot be dropped directly

1 Answers  

RMAN-10001: error parsing recovery catalog connect string "string"

1 Answers  

LPX-00400: an internal error has occurred in XPATH

1 Answers  

RMAN-06125: error while looking up archive log key: number

1 Answers  

LRM-00123: invalid character number found in the input file

1 Answers   BSNL, IBM,

ORA-26535: %ud byte row cache insufficient for table with rowsize=number

1 Answers  

ORA-16232: adding Logical Standby skip entry for table string.string

1 Answers  

QSM-01071: a lossy join in materialized view, string, from table, string, not found in query

1 Answers  

ORA-24806: LOB form mismatch

2 Answers  

ORA-01543: tablespace 'string' already exists

1 Answers