Home » Other » General » Service and Instance Query (Oracle 10g)
Service and Instance Query [message #408385] Tue, 16 June 2009 01:33 Go to next message
satish_j
Messages: 35
Registered: June 2009
Location: Mumbai,India
Member
Is there any difference between oracle database service and Oracle instance??
I need oracle to start with OS only with bare minimum processes.Database should not be started automatically.
As per my little knowledge,instance refers to memory structures and various processes that must be started FIRST in order to access database.Then,after the instance is started,database can be connected.
Pls help...
Re: Service and Instance Query [message #408405 is a reply to message #408385] Tue, 16 June 2009 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On Windows the service is the instance.

Regards
Michel
Re: Service and Instance Query [message #408412 is a reply to message #408405] Tue, 16 June 2009 02:49 Go to previous messageGo to next message
satish_j
Messages: 35
Registered: June 2009
Location: Mumbai,India
Member
What about Linux...Instance and service are different on Linux???
Also,how to configure service on windows to not to start the database?
Re: Service and Instance Query [message #408447 is a reply to message #408412] Tue, 16 June 2009 04:36 Go to previous message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What about Linux...Instance and service are different on Linux???

As far as I know there is no service on Linux, or maybe you mean something else, if so explain waht you mean.

Quote:
Also,how to configure service on windows to not to start the database?

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 EDIT STARTMODE.

Regards
Michel

[Updated on: Tue, 16 June 2009 04:38]

Report message to a moderator

Previous Topic: PL/SQL datawarehouse process: stability issues
Next Topic: WPG_DOCLOAD
Goto Forum:
  


Current Time: Sat Dec 27 07:01:45 CST 2014

Total time taken to generate the page: 0.14657 seconds