ora-12518 and ora-12547

[llo599]

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.

[llo599]

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.

[davey23uk]

problem solved then

[llo599]

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.

[PAVB]

If you want to go with SERVER=SHARED you probably want to fine tune SQLNET.inbound_connect_timeout parameter.

[davey23uk]

i presume you do actually have shared server set up on the database?

[Bore]

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

[llo599]

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.

[Bore]

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

[dbasan]

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.