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

    Your server is probably running out of memory and need to swap memory to disk.

    One cause can be an Oracle process consuming too much memory.


    A possible workaround is to set following parameter in the listener.ora and restart the listener:

    DIRECT_HANDOFF_TTC_LISTENER=OFF



    Should you be working with Multi threaded server connections, you might need to increase the value of large_pool_size.


Adverteren bij Daisycon
Forum Messages
07-FEB-2008 05:39:25getting error IO exeptionDeepak Pandit Reply
I am connecting Oracle 9i with Netbeans 6.0 using ojdbc14.jar driver file which I downloaded from the oracle site but I am getting this error every time I am writing jdbc:oracle:thin:@localhost:1521:ORCL
and getting the error (Unable to addd connection ) without giving any error code, when using
my IP address in place of localhost.
Kindly help. I am in between of a very important module.
07-FEB-2008 05:45:14Blocked by firewallDbMotive Reply
Can it be that the port (1521) is blocked by a firewall?
10-MAR-2008 01:42:03ORA-12518 Message 12518 not found product = RDBMS80; FACILITY=ORASaqib Reply
Dear Sir / Maadm
We have install 10G and import data from 9i. some user are connected but others get this error
ORA-12518 Message 12518 not found product = RDBMS80; FACILITY=ORA
kindly advice me urgently on my email
thanks
10-MAR-2008 04:59:05Oracle Home not setDbMotive Reply
It looks like the Oracle home is not set correctly on the failing machines.

Fix the client and choose the correct Oracle home. If this is a Windows client, you can try to use Oracle Locator Express
19-MAR-2008 16:40:23Ora-12518: TNS listener could not hand off client connectionKaren Reply
we migrated our 9.2.0.8 database to 10g. On the same win box, there are 4 databases. Others work well except the one I got error.
Can someone let me know ASAP?

Thanks.
09-APR-2008 07:19:57ORA-12518: TNS:listener could not hand off client connectionchetan Reply
When I try to connect to Oracle I get error
ERROR:
ORA-12518: TNS:listener could not hand off client connection
and I am unable to Connect to Oracle
I have Core2 Duo Processor, 1 GB RAM, only Windows XP (SP2)& Oracle Installed
: ->  09-APR-2008 08:48:00Check listener.logDbMotive Reply
Can you check the listener.log file to see if it contains errors?

If so, please post them here
11-APR-2008 13:38:26ORA-12518: TNS:listener could not hand off client connectionCHETAN Reply
some part of listener.log file is :

11-APR-2008 16:32:02 * (CONNECT_DATA=(SID=ORCL)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\AgeTak\ARCEAC\ARCMultiplexer\ARCMUX.exe)(HOST=BDIPL28)(USER=BDIPL))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.28)(PORT=4867)) * establish * ORCL * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 233: Unknown error
: ->  11-APR-2008 14:29:21Windows errorDbMotive Reply
Windows error 233 means "ERROR_PIPE_NOT_CONNECTED", so probably your database is not running.

Try to restart the OracleServiceORCL service using control panel.
11-APR-2008 18:52:25Windows ErrorCHETAN Reply
I have approx 400 concurrent connections, and approx 300 connections are running fine. on 100 connections I got the error. I search for it and got Low virtual memory, I increase virtual memory upto 12GB & Increase the RAM upto 4 GB. but I got same problem. I need approx 1000 concurrent connections, what can i do for this.
: ->  14-APR-2008 08:17:18Windows 32-bitDbMotive Reply
Windows only allows to allocate approximately 1,7Gb in a single thread.

You are probably reaching a Windows limit.

If you need 1000 concurrent connections, you might want to investigate configuring Multi Threaded Server for (some of) your database connections.
19-APR-2008 10:21:12ORA-12203 & ORA-12505 errorjo Reply
i've 200 concirrent connections to my oracle10g server(4GB RAM,2* 3.4Xeon hyper-threaded prossor).
i'm getting the above errors radomly whn i try to connect to my application.i 've set the process_limt to 500. my sga_max_target=1400MB and PGA=194MB.can u tell me wat to do to slove dis problem
05-MAY-2008 14:12:01Ora-12518fred Reply
I installed Oracle 11G on windows 32-bit with *Gb memory. I get the following in the listener.log

05-MAY-2008 09:10:19 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.AAMSUST.local)(CID=(PROGRAM=C:\PROGRA?1\EMC\AUTOST?1\eas53\modules\oraclewindows_3.1\oraclewindowsproxy.exe)(HOST=LAVL4183)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.241.135.135)(PORT=4965)) * establish * orcl.AAMSUST.local * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1073741824: Unknown error
What could be the problem?
I even put the DIRECT_HANDOFF_TTC_LISTENER=OFF in listner.ora and still the same error.
: ->  14-MAY-2008 08:53:41Incorrect PGA sizeDbMotive Reply
The value of 1073741824 is exactly 1Gb.
Can it be that you have a value for pga_aggregate_target that exceeds 1Gb?
14-MAY-2008 13:16:35ORA-12518fred Reply
The value of pga_aggregate_target is 0. I found the problem though.
It was a stupid typo between the listener.ora and tnsnames.ora
Add your message for ORA-12518
Name:email:
Validation Code:45kvxb0b0dfmxru7q
Enter Code above:
Title:
State your problem: