| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle on NT startup question
In UNIX there is not service process, but Win NT/2K requires it, something I discovered when I started to working on WIN env. Confusing if you do come from a UNIX env. Look at it this way the Service + the Database( Datafiles, redologs, controlfiles etc) are the instance. The Service is a process which is started "in preparation" for the mounting of the instance, in otherwords setting up the memory and so on. If you start up the service and not the instance(Database) you will get an error from the listener(also a service) stating that Oracle is not available. You will then be required to start the instance(Database) from svrmgrl/Sqlplus.
But as you have already discovered, the service can be setup to automatically start the instance(Database) once the service has started, making it almost UNIX like in that sense.
Come to think of it, if you open the services facility in the ControlPanel, right click on the oracle service, properties, you can change the startup mode from automatic to manual. Which will then not start the service or the instance at startup of the server. It will require you to start it manually very time.
HTH
Denham
-----Original Message-----
From: tday6_at_csc.com [mailto:tday6_at_csc.com]
Sent: Thursday, November 01, 2001 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle on NT startup question
I'm sorry. I thought that you mounted a database and that the instance was the area in memory (corresponding to the SGA and PGA) that Oracle used. So what is the instance?
Denham Eva
<EvaD To: Multiple recipients of list ORACLE-L
@TFMC.co.za> <ORACLE-L_at_fatcity.com>
Sent by: root cc:
Subject: RE: Oracle on NT startup question
11/01/2001
12:25 AM
Please
respond to
ORACLE-L
I am not sure I understand you correctly, but on NT Oracle runs as a service and an instance(the mounted database). The service must be started for the instance to be able to mount and connected to. However the service can be started without having to mount the instance.
HTH
Denham
-----Original Message-----
Sent: Wednesday, October 31, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L
My understanding is that the instance is the service. Can you start the instance without a mounted database?
Andrey
Bronfin To: Multiple recipients of
list ORACLE-L
<andreyb <ORACLE-L_at_fatcity.com>
@elrontelesof cc:
t.com> Subject: Oracle on NT startup
question
Sent by: root
10/31/2001
04:35 AM
Please
respond to
ORACLE-L
Dear list !
If my NT server (which runs an Oracle instance) gets rebooted accidentally, how can i bring up the Oracle services without starting up the instance ? I want to startup the instance with a script later . I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.
Thanks in advance.
DBAndrey
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: andreyb_at_elrontelesoft.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tday6_at_csc.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tday6_at_csc.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Nov 02 2001 - 00:31:20 CST
 |
 |