oracle11g ora 12518,ORA-12518 TNS:监听程序无法分发客户机连接 解决办法

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

connection

Cause: The process of handing off a client connection to another

process failed.

Action: Turn on listener tracing and re-execute the operation.

Verify that the listener and database instance are properly

configured for direct handoff. If problem persists, call Oracle

Support.

先试试 connect / as sysdba,看行不行，如果行的话，

再试试connect / @ as sysdba看看监听配置是否有问题。

如果这一步有问题，说明监听这块有问题。

1.cmd

2.sqlpls /nolog

3.connect sys/test as sysdba

没有问题

1.cmd

2.sqlplus /nolog

3.connect sys/test@test as

sysdba

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

说明监听有问题

The reason ORA-12518 is being throw may be because of DEDICATED

connections because Oracle 10g has a value of PROCESSES is