ora-12518 and ora-12547
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: ora-12518 and ora-12547

  1. #1
    Join Date
    Mar 2007
    Posts
    5

    ora-12518 and ora-12547

    Hi, I got an "ORA-12518: TNS:listener could not hand off client connection" and added the parameter DIRECT_HANDOFF_TTC_LISTENER=OFF to the listener.ora file.

    After the restart of the listener I get an "ORA-12547: TNS:lost contact"

    Logged users before the 12518 are working but new users can┤t log, they get this 12547.

    Listener is running, so, where┤s the error?

    thanks.

  2. #2
    Join Date
    Mar 2007
    Posts
    5
    Just a tip. If I set SERVER = DEDICATED on the client machine, the user can connect but if SERVER = SHARED I get the 12547 error.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    problem solved then

  4. #4
    Join Date
    Mar 2007
    Posts
    5
    Problem workarounded, but not solved. I don┤t want all the connections to be dedicated. I still need to solve it so any help would be appreciated.

    Thanks.

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    If you want to go with SERVER=SHARED you probably want to fine tune SQLNET.inbound_connect_timeout parameter.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    i presume you do actually have shared server set up on the database?

  7. #7
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Seems that:
    Your database is not configured to use shared server(select network from v$dispatcher) or the listener do not see the dispatchers (lsnrctl services) or the shared_server_sessions parameter limits the number of the sessions that can connect as shared servers sessions (show parameter shared) or (not very probable) all the dispatchers have rached it's OS maximum limit of connections

    Please check these and let us know if that helps

  8. #8
    Join Date
    Mar 2007
    Posts
    5
    Shared server is enabled :

    (ADDRESS=(PROTOCOL=tcp)(HOST=SERVERNAME)(PORT=1165))
    (ADDRESS=(PROTOCOL=tcp)(HOST=SERVERNAME)(PORT=1167))

    Listener see dispatchers :

    El servicio "SERVICENAME" tiene 1 instancia(s).
    La instancia "SERVICENAME", con estado READY, tiene 3 manejador(es) para este servicio
    ...
    Manejador(es):
    "D001" establecidos:23 rechazados:0 actuales:0 m▀ximo:120 estado:ready
    DISPATCHER
    (ADDRESS=(PROTOCOL=tcp)(HOST=SERVERNAME)(PORT=1167))
    "D000" establecidos:37 rechazados:0 actuales:3 m▀ximo:120 estado:ready
    DISPATCHER
    (ADDRESS=(PROTOCOL=tcp)(HOST=SERVERNAME)(PORT=1165))
    "DEDICATED" establecido:19 rechazado:0 estado:ready
    LOCAL SERVER

    and shared_server_sessions = 115

    Thanks for all.

  9. #9
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Well,I'm out of ideas.
    Enable the listener tracing at level 16, try to establish a connection to reproduce the error, look at the trace file and good luck

  10. #10
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650

    Shared server is enabled :

    (ADDRESS=(PROTOCOL=tcp)(HOST=SERVERNAME)(PORT=1165))
    (ADDRESS=(PROTOCOL=tcp)(HOST=SERVERNAME)(PORT=1167))
    Have you set in the shared_servers in init file?
    Check in V$shared_server and V$circuit?

    Check the listener log for total connections on both the ports. 12547 happens if the machine is overloaded with connections. Do a netstat with grep on ports. Enabling trace can give you clues.
    "What is past is PROLOGUE"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width