Home » Infrastructure » Windows » Starting and stopping oracle 10g services in windows (Oracle 10g Windows XP service pack 2)
Starting and stopping oracle 10g services in windows [message #404946] Mon, 25 May 2009 10:35 Go to next message
sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow
Junior Member

dear all,

how can we start and stop oracle services and database in widows xp service pack 2.
thanks in advance.........
Re: Starting and stopping oracle 10g services in windows [message #404947 is a reply to message #404946] Mon, 25 May 2009 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
C:\>oradim
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

See startup and shutdown options.

Regards
Michel
Re: Starting and stopping oracle 10g services in windows [message #404950 is a reply to message #404946] Mon, 25 May 2009 12:37 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In addition to what Michel suggested, you can also consider using:

net [stop|start] [service_name]
Previous Topic: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean?
Next Topic: MS word issue.
Goto Forum:
  


Current Time: Fri Apr 19 22:33:58 CDT 2024