| 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: 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: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
-----Original Message-----
From: Koivu, Lisa [SMTP:lisa.koivu_at_efairfield.com]
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: BoivinP_at_mar.dfo-mpo.gc.ca
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Tue Aug 14 2001 - 12:26:31 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |