狂暴綿羊完勝企鵝教戰手冊

Senario: login by root account and want to su to a specific account. Can't su to this account and show this message

How to solve:

1. use "ps -ef|grep <account name>" to check if processes of this account are too much and cause to be over the process limit value in system configuration

2. the ps result showed that there were 588 processes under this account. 

3. because these processes coneected to database, it was neccesary to kill them not only in OS but also in DB

4. After DB & OS kill, this account could be su.

 

How to check PID & Oracle session:

SELECT s.sid, s.serial#, s.username, s.osuser, p.spid, s.machine, p.terminal, s.program
FROM v$session s, v$process p
WHERE s.paddr = p.addr;