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 foreground process starts before PMON

Salih Mohamed YusufNov 12 2014 — edited Nov 12 2014

Hi DBAs,

Today while working on a lower environment (test) database, i faced the Error ORA - 1033 foreground process starts before PMON.

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

Windows XP SP 2

The oracle community posts shows that it is a bug and it is solved in 11.2 Version

The error came mainly because of the following sequence of activities

1. Invoked the batch file which starts the Windows Oracle Database Service.

2. When the starting of Oracle Database is in progress, i tried to connect to the database from another command prompt window using sqlplus as sysdba and it went to a hung state resulting in ORA - 1033 error.

Please let me know your experience on this error.

Thanks,

Salih KM

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2014
Added on Nov 12 2014
2 comments
1,016 views