Database Networking (MOSC)

MOSC Banner

TNS-12518: TNS:listener could not hand off client connection

edited Jul 7, 2021 1:28AM in Database Networking (MOSC) 6 commentsAnswered
  • 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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center