TNS-12518: TNS:listener could not hand off client connection
- When client use SERVICE_NAME = AOFPE001.WORLD -- works fine
- When client use SERVICE_NAME = AOFPE001 -- Does not work
- DB service_names parameter is set to 'AOFPE001.WORLD'
- sqlnet.ora file has parameter set as NAMES.DEFAULT_DOMAIN = WORLD
- So my understanding is when client use SERVICE_NAME = AOFPE001 - the connection should work seamlessly - but we are getting below error in listener.log
TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 32: Broken pipe
SQL> show parameter service_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string AOFPE001.WORLD SQL> show parameter db_domain NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_domain string WORLD SQL> show parameter global_names NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ global_names boolean TRUE SQL> LSNRCTL> status Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_REGISTER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))) Services Summary... Service "AOFPE001" has 1 instance(s). Instance "AOFPE001", status UNKNOWN, has 1 handler(s) for this service... Service "AOFPE001.WORLD" has 1 instance(s). Instance "AOFPE001", status READY, has 1 handler(s) for this service... The command completed successfully LSNRCTL>
Tagged:
0