Patrice, thank you so much for sending this to me (and the list). This explains a lot.
Also, thanks to Kevin Lange.
Now I need to get over my initial nauseous feeling from running an oracle database on Windows.
LK
-----Original Message-----
From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: I admit this is dumb. NT/W2K Services?
I haven't worked on Windows2000, but if it's like NT, you have two things to
worry about when starting Oracle in the Windows environment:
The background service has to be running, to provide a context.
The instance has to be started otherwise it is in shutdown mode.
On NT 4, there is an NT Service that runs like a daemon in the background.
When you start the service it automatically tries to start the instance like
when we issue startup open at the svrmgrl prompt in UNIX.
On Windows2000 it must be trying to do the same thing.
Usually on NT if the service hasn't started and you try to access the db
from svrmgrl, it tells you there has been a protocol error. This is
misleading, in fact the problem is that there is no context for Oracle to
run in, i.e. the NT Service hasn't been started.
In Oracle 7.3. you can tell that Oracle hadn't finished porting their rdbms,
because there were two separate NT services - one to provide the context,
one to issue startup open. In Oracle 8I there is only one NT service that
tries to do both.
I suspect that if you are low on memory, the NT / Win2K service may be able
to "create" a context for Oracle to run in, but not have enough memory
available to effectively start the Oracle instance. So you may end up with
Win2K service showing up as started, when in fact the db is half opened and
therefore not usable. You can try opening a DOS box and shutting it down
then re-starting it from the command prompt if that happens, DK if it will
work.
HTH
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst�mes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | R�gion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L
Subject: I admit this is dumb. NT/W2K Services?
I'm playing with Oracle on w2k out of sheer boredom. So now I'm
forced to learn a little bit about w2k.
I was looking at oradim and it has starttype and shuttype with
options srvc and inst. OK, I understand the instance part. But what on
earth are services? Below is what the help says about it. So to translate
this into Unix-speak, is this similar to a daemon? I guess I'm confused
because as far as I know there's nothing additional that needs to be running
on Unix to just start up a database.
If that's the case, then why would you want to shut down an instance
and not services? For RMAN? I guess I'm at a loss here. Can someone give
me an example of when you'd want to do this?
Plus, there's notes on Metalink about recreating services. Why/when
would you want to do that?
Here's the overly-generic definition I found.
A program, routine, or process that performs a specific system
function to support other programs, particularly at a low (close to the
hardware) level. When services are provided over a network, they can be
published in Active Directory, facilitating service-centric administration
and usage. Some examples of Windows 2000 services are Security Accounts
Manager service, File Replication Service, and Routing and Remote Access
Service.
Any descriptions or web sites that can describe this would be
appreciated.
Lisa Koivu
Oracle Database Administrator and Self-Professed W2K Idiot.
Fairfield Resorts, Inc.
954-935-4117
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
