| Service and Instance Query [message #408385] |
Tue, 16 June 2009 01:33  |
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 #408447 is a reply to message #408412] |
Tue, 16 June 2009 04:36  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
