Re: Theoretical Question OracleService<SID>

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 Received on Tue Apr 04 2006 - 16:13:36 CDT