Re: Theoretical Question OracleService<SID>
- From: "Rauf Sarwar" <rs_arwar@xxxxxxxxxxx>
- Date: 4 Apr 2006 14:13:36 -0700
Lanying & Manfred wrote:
ORA !=g WIN XP PROF
When shutting down an Oracle Instance via sqlplus
shutdown immediate;
the ORACLESERVICE<SID> is still running. What in the hell is the
oracleservice<SID> doing? Launch pad for a start up sequence?
startup blah blah blah?
A theoretical question only!
Regards Lanying
Have a fairly good understanding of the OS where your Oracle software
is running. It will make your job much easier.
On Windows, you need a service to run a process in the background i.e.
start a process when Windows starts up without having to first logon.
This is essential since you cannot leave a server always with a logged
on session. Oracle database on Windows runs as a single process with
multiple threads created and killed during the life of the process
(Multithreaded). Service basically just invokes this process where all
the other threads eventually end up in i.e. database, sessions etc.
Having said that, you don't need a service to startup a database e.g.
just open a DOS prompt and type,
C:\> %ORACLE_HOME%\bin\oracle.exe %ORACLE_SID%
Note the Oracle_Sid as the first parameter. This will create a process
for you to startup the database. Open up another DOS session and start
up your database from here. But for this to work... you have to first
logon to the server and the moment you logoff, your process is
history.... hence the need for a service.
If you just google, you can find plenty of material explaining Windows
Multithreaded and Unix's Multiprocess with IPC architectures.
Regards
/Rauf
.
- References:
- Theoretical Question OracleService<SID>
- From: Lanying & Manfred
- Theoretical Question OracleService<SID>
- Prev by Date: Re: Can't connect to Oracle after domain join
- Next by Date: Re: Can't connect to Oracle after domain join
- Previous by thread: Re: Theoretical Question OracleService<SID>
- Next by thread: 10g and FTE's
- Index(es):
Relevant Pages
|
