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.

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