Oracle Not Start With Windows Start up

Today, a coworker ask me about a problem with a database. He reboot the windows system but the database doesn’t started. He talk me the windows service is in automate state, in fact, the service started but no the database.

Tooking a look a regedit We can see the next photo;

foto_oradim_v1

in the picture, you can see the ora_sid_autostart entry, in this case is set to false. This the problem. With the next command you can change this value, in a official way, (is not recommended edit ora_sid_autostart entry and modified it);

C:\Users\admbbdd>oradim -EDIT -SID dbfin -STARTMODE auto

After refresh the regedit (or close and open again), the ora_sid_autostart entry has changed;

 

foto_oradim_v2

Oradim command has a log of activity located at $ORACLE_HOME\database named oradim.log.

HTH – Antonio NAVARRO

Advertisements

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