错误: ORA-12516: TNS: 监听程序找不到符合协议堆栈要求的可用处理程序
解决方法:加大PROCESSES
sessions=(1.1*process+5)
cmd
sqlplus
sys/sys as sysdba
sql>show parameter processes;
sql>show parameter sessions;
sql>alter system set processes=300 scope=spfile;
sql>alter system set sessions=335 scope=spfile;
需要附加的操作:
sql>show parameter SHARED_SERVERS;
sql>alter system set SHARED_SERVERS =10 scope=spfile;