topic Re: finishing Oracle proccess in Operating System - HP-UX

finishing Oracle proccess

Domingo Muñoz — Fri, 01 Feb 2002 12:20:16 GMT

a DBA from BBDD Deparment asked to me a doubt:
Who is it sending the petition of stopped of the proccesses oracle, oracle or system operation?

In our server the instance oracle is started by means of scripts.

I think that oracle sends a petition to the sytem operation and this close this proccesses. Is correct?

Re: finishing Oracle proccess

Corthouts Carlo — Fri, 01 Feb 2002 12:42:59 GMT

Are you talking about how the dba is stopped?

Re: finishing Oracle proccess

Alexander M. Ermes — Fri, 01 Feb 2002 12:58:56 GMT

Hi there.
Stopping Oracle is mostly a dba task.
Oracle dba's should never get the root password
( exception one person doing both jobs ).
Rgds
Alexander M. Ermes

Re: finishing Oracle proccess

Domingo Muñoz — Fri, 01 Feb 2002 13:46:50 GMT

I believe that I have explained bad.

Do I want to know if oracle stops all the proccesses oracle or Oracle sends a petition to the operating system to stop this processes?

Re: finishing Oracle proccess

Tom Dawson — Fri, 01 Feb 2002 13:49:31 GMT

Domingo,

Oracle distributes two scripts, dbstart and dbshut. These scripts will start and stop all Oracle instances listed in /etc/oratab.

Typically, the dbstart and dbshut scripts are executed from /sbin/init.d during the system start and stop sequence. We start the databases in run-level 2 ( rc2.d ).

Tom

Re: finishing Oracle proccess

Chris Vail — Fri, 01 Feb 2002 15:49:35 GMT

This is question is one being constantly asked around here. Traditionally, Oracle is started by the dbstart and dbshut commands that are in the /sbin/init.d directories and are linked from /sbin/rc2.d.

However, our lead Oracle administrator has told us that we will NOT use these scripts. The reason is simple: he wants the Oracle DBA's intimately involved in every startup and
shutdown. He wants them to ensure database integrity at every step of the way, and the startup/shutdown scripts can't do that.

So this is more of a political/management question than a technical one. Each company will have a different answer to this question.

Regards
Chris

Re: finishing Oracle proccess

Domingo Muñoz — Mon, 04 Feb 2002 16:13:17 GMT

Thank you very much.