客户端用pl/sql dev连接数据库问题重现,在登入时就提示(专用服务器模式)。
ERROR:
ORA-12516: TNS:listener could not find available handler with
matching protocol
stack
修改参数时发现启动第一个sqlplus通过系统认证可以正常连接数据库
。当启动第二个sqlplus工具,以系统认证方式连接数据库时发现连接
到一个空闲例程上。
第一个sqlplus:
[oracle@jason]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 17
18:43:11 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected.
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------
------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 22
SQL> show parameter sessions;
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
logmnr_max_persistent_sessions integer 1
sessions integer 29
shared_server_sessions integer
SQL> select count(*) from v$session;
COUNT(*)
----------
20
SQL> select count(*) from v$process;
COUNT(*)
----------
21
SQL>
第二个sqlplus:
[oracle@jason]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 17
18:39:55 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected to an idle instance.
测试尝试启动报错,证明数据库已经运行。
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down
first
SQL>
这点有点不理解,希望得到指点。
在第一个sqlplus连接中,修改processes参数。
SQL> alter system set processes=300 scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1207959552 bytes
Fixed Size 2095864 bytes
Variable Size 369100040 bytes
Database Buffers 822083584 bytes
Redo Buffers 14680064 bytes
Database mounted.
Database opened.
SQL> show parameter sessions;
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
logmnr_max_persistent_sessions integer 1
sessions integer 335
shared_server_sessions integer
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------
------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 300
SQL>
在客户端再次利用pl/sql连接数据库,测试可以正常连接.错误提示没有
再出现.
补充:sessions=(1.1 * PROCESSES
) + 5
注:本环境为测试环境。