ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-12518: TNS: 监听程序无法分发客户机连接

ORA-12518: TNS: 监听程序无法分发客户机连接

原创 Linux操作系统 作者:YallonKing 时间:2012-03-29 12:42:19 0 删除 编辑
/*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.
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;
  COUNT(*)
----------
       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;
  COUNT(*)
----------
       145
--其中调整参数process即可解决此问题。
--如下:
--alter system set processes=500 scope=spfile;
--shutdown immediate;
--startup
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26143577/viewspace-719803/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-08-07

  • 博文量
    72
  • 访问量
    245941