Solve Oracle ORA-00020 problem
ENLARGE PROCESS:
1) Login SQLPLUS as sysdba:
alter system set processes=300 scope=spfile sid='*';
alter system set sessions=450 scope=spfile sid='*';
2) restart server
KILL SESSION
1) find out session information
SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
s.username,
s.program
FROM gv$session s
JOIN
gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE
s.username='
|
2) kill session:
ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id';
restart Database
1) user oracle user, stop database:
srvctl stop database -d
2) start database
srvctl start database -d
Comments