Wednesday, July 9, 2008

Starting Instance/DB on MS-Windows command based

c:\

c:\ edit startwplains.bat

When you get into edit mode of this file write the following command in it.

oradim -startup -sid wplains -starttype srvc,inst

Once done save and exit.Note: wplains is my instance id

Same way you can create stopping the instance/database

c:\edit stopwplains.bat

oradim -shutdown -sid wplains -shuttype srvc,inst -shutmode immediate

Once done save and exit.Note: wplains is my instance id

This gives DBA a command line interface to work with oracle on windows. I 'm used to work on UNIX and feel less comfortable on windows env so i thought of working this way.

No comments: