Thinking Out Loud

June 19, 2007

Cannot start DB using spfile

Filed under: oracle — mdinh @ 6:26 pm

I am currently running Oracle 9.2.0.8.0 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.

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: