Home » Infrastructure » Windows » how to start database automatically? (Oracle 9i, Windows Xp)
how to start database automatically? [message #308073] Fri, 21 March 2008 01:14 Go to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
Hi all
My database on oracle 9 ,on windows machine..
It is in no archivelog.
when I shut down the machine and startup again my database doesn't up automatically .
I have to start it manually every time by giving the startup command.
what is the procedure to start database automatically with machine startup?

Thanks
Re: how to start database automatically? [message #308083 is a reply to message #308073] Fri, 21 March 2008 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORADIM: <command> [options].  Refer to manual.
Enter one of the following command:
Create an instance by specifying the following options:
     -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
 [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
 [-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
Edit an instance by specifying the following options:
     -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
 [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
 [-SHUTMODE normal|immediate|abort] [-SHUTTYPE srvc|inst] [-RUNAS osusr/ospass]
Delete instances by specifying the following options:
     -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
Startup services and instance by specifying the following options:
     -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
 [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename | -SPFILE]
Shutdown service and instance by specifying the following options:
     -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
 [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE normal|immediate|abort]
 Query for help by specifying the following parameters: -? | -h | -help

Note the -startmode and -srvcstart options with -EDIT

Regards
Michel
Re: how to start database automatically? [message #308089 is a reply to message #308073] Fri, 21 March 2008 02:06 Go to previous messageGo to next message
Littlefoot
Messages: 19691
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Open Administrative Tools - Services and check startup type of Oracle services; should be "Automatic" if you'd like them to startup automatically (perhaps they are set to "Manual" or even "Disabled" at the moment).
Re: how to start database automatically? [message #308094 is a reply to message #308089] Fri, 21 March 2008 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
oradim handles both database and service.

Regards
Michel
Re: how to start database automatically? [message #308095 is a reply to message #308083] Fri, 21 March 2008 02:36 Go to previous message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
Thanks a lot/..i solved the problem
Previous Topic: Checking Oracle Instance
Next Topic: problem with my batch file that run the oracle
Goto Forum:
  


Current Time: Thu Oct 23 04:30:03 CDT 2014

Total time taken to generate the page: 0.15056 seconds