2021-05-24

ORA-12518: TNS:listener could not hand off client connection

oracle  11.2.0.3
HU-UX
问题原因：数据库进程出超出系统进程限制
ps -ef|grep ora|wc -l
kcture |grep nproc(root用户限制)
kcture |grep maxuprc(普通用户限制)
处理办法：
方法一：
查询连入数据库的连接,然后杀掉无效会话，释放进程
select count(*),username,machine,program,status from v$session group by username,machine,program,status;
select 'alter system kill session ''' || sid || ',' || serial# || ',@' || inst_id || ''' immediate;'
from v$session
where username='xxxx' and status='inactive';
select spid from  v$process where addr in(select  paddr  from v$session where username='xxxx' and status='inactive');
kill -9 
方法二：
增加系统进程限制数
kctune maxuprc+=1024（增加1024个立即生效）