Maintenaince flag for Oracle Script

[Manuel Carbajal]

Hi,

i have several databases and a few are put together as a package.

My problem is that the dba has to stop from time to time the databases to make mainteinance, but one at a time, does someone has the way to enable a maintenace flag in order to bring down a database and not activate the cluster??

Thanks in advance,

Regards,

[Robert Gamble]

Yes, there are many ways to do this.

My preference would be to have the package control look for a flag before looking for processes. If the flag is present, do not monitor the processes. If the flag value is zero, then monitor the normal processes.

Good Luck!

[Robert Gamble]

In my prior post, make sure the DBA can write to the flag file. I recommend owner is root, with dba group permissions to write.

Hope this helps!

[Manuel Carbajal]

Thanks,
but you have any way or script to do this?

i can see the monitor section in the oracle script, i guess i shuold modify the controls script in this part.

thanks in advance,

Regards,