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