ORA-12518: TNS: 监听程序无法分发客户机连接
/*ORA-12518: TNS: 监听程序无法分发客户机连接*/
[oracle@m1hfdata oracle]$ oerr ora 12518
12518, 00000, "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.
// *Comment: The problem can be worked around by configuring dispatcher(s)
// to specifically handle the desired presentation(s), and connecting
// directly to the dispatcher, bypassing the listener.
12518, 00000, "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.
// *Comment: The problem can be worked around by configuring dispatcher(s)
// to specifically handle the desired presentation(s), and connecting
// directly to the dispatcher, bypassing the listener.
SQL> sho parameter process
NAME TYPE VALUE
------------------------------------ ----------- ---------
aq_tm_processes integer 0
cell_offload_processing boolean TRUE
db_writer_processes integer 2
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150
SQL> select count(*) from v$process;
------------------------------------ ----------- ---------
aq_tm_processes integer 0
cell_offload_processing boolean TRUE
db_writer_processes integer 2
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150
SQL> select count(*) from v$process;
COUNT(*)
----------
149
----------
149
SQL> sho parameter session
NAME TYPE VALUE
------------------------------------ ----------- ---------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
session_cached_cursors integer 50
session_max_open_files integer 10
sessions integer 256
shared_server_sessions integer
SQL> select count(*) from v$session;
------------------------------------ ----------- ---------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
session_cached_cursors integer 50
session_max_open_files integer 10
sessions integer 256
shared_server_sessions integer
SQL> select count(*) from v$session;
COUNT(*)
----------
145
----------
145
--其中调整参数process即可解决此问题。
--如下：
--alter system set processes=500 scope=spfile;
--shutdown immediate;
--startup
--如下：
--alter system set processes=500 scope=spfile;
--shutdown immediate;
--startup
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26143577/viewspace-719803/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
