finishing Oracle proccess

[Domingo Muñoz]

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?

[Corthouts Carlo]

Are you talking about how the dba is stopped?

[Alexander M. Ermes]

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

[Domingo Muñoz]

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?

[Tom Dawson · Accepted solution]

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

[Chris Vail]

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

[Domingo Muñoz]

Thank you very much.