Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-1033,ORA-00020 : ERRORS WHILE STARTING UP OF DATABASE

Karan KukrejaNov 11 2010 — edited Jan 20 2011
hi... i am on oracle 11G(11.1.0.7.0) database and here is the snapshot from the alert.log.

it seems 2-3 processes had problem while starting up.. but later on they started... i checked that in the alert file.

________________________________________________________________________________________
ksuapc : ORA-1033 foreground process starts before PMON ksuapc : ORA-1033 foreground process starts before PMON ksuapc : ORA-1033 foreground process starts before PMON ksuapc : ORA-1033 foreground process starts before PMON
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00444: background process "CJQ0" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00450: background process 'CJQ0' did not start
ORA-00444: background process "CJQ0" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00444: background process "CJQ0" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00444: background process "CJQ0" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00450: background process 'CJQ0' did not start
ORA-00444: background process "CJQ0" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00444: background process "CJQ0" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00444: background process "SMCO" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00444: background process "SMCO" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00444: background process "SMCO" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00444: background process "CJQ0" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00444: background process "SMCO" failed while starting
ORA-00020: maximum number of processes () exceeded
ORA-00020: maximum number of processes 0 exceeded ORA-20 errors will not be written to the alert log for the ORA-20 errors.


________________________________________________________________________________________


This doesn come very often , but once in a blue moon... so is there any reason behind it ? because it seems an error while starting up only ?
This post has been answered by Hoek on Nov 11 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2011
Added on Nov 11 2010
5 comments
3,207 views