Thinking Out Loud

June 19, 2007

Cannot start DB using spfile

Filed under: oracle — mdinh @ 6:26 pm

I am currently running Oracle SE on  RHEL4  (Nahant Update 3).

Trying to start the database using $ORACLE_HOME/bin/dbstart resulted in the following error:

Can’t find init file for Database “TIGGER”.

Database “TIGGER” NOT started.

No parameter file exists in the directory $ORACLE_HOME/dbs, i.e. only orapwTIGGER and  spfileTIGGER.ora exist.

Manually, start the database and create pfile from spfile. 

Shutdown the database.

Executing ORACLE_HOME/bin/dbstart now works. 

dbstart requires pfile (initTIGGER.ora) even though spfile (spfileTIGGER.ora) already exists.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at

%d bloggers like this: