Hello All,
Oracle 11g 11.2.0.2 Expression Edition
I made the number of processes to 1 by issuing the below command.
SQL> alter system set processes = 1;
SQL>shutdown immediate
I am getting the below error when I issued startup command.
SQL> startup;
ORA-03113: end-of-file on communication channel
alert log:
Fri Dec 28 14:09:24 2012
PMON started with pid=2, OS id=2984
Fri Dec 28 14:09:24 2012
PSP0 started with pid=3, OS id=5788
Fri Dec 28 14:09:25 2012
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process GEN0 submission failed with error = 20
USER (ospid: 4780): terminating the instance due to error 444
Fri Dec 28 14:09:25 2012
VKTM started with pid=4, OS id=1676 at elevated priority
Instance terminated by USER, pid = 4780
How to startup my database again?