Cluster package ..strt up databse in customer-defined scripts..

[boomer_2]

hi guys,
I have 2 node cluster....
In which i hv a package for which i have included the startup and haltdown database scripts in it ..
the databse is up fine .but when i check it through ps -ef|grep pmon its showing

ps -ef|grep pmon|grep daemon
daemon 18244 1 0 Jul 13 ? 0:13 ora_pmon_gb567890
daemon 17536 45678 1 0 Jul 13 ? 0:13 ora_pmon_g0
daemon 16630 1 0 Jul 13 ? 0:15 ora_pmon_g054346


i am seeing they r running as daemon...unlike the others which r running thr oracle user...

[Ralph Grothe · Accepted solution]

In my view this can only be owe to some startup script part in your customer_defined_run_commands.

I have to look after several MC/SG clusters that run Oracle DBMS as packages.
These are usually started by some here file command to the Oracle utility sqlplus within an su to the user (usually oracle) under which the ora_* procs should run.
Check your run_commands block.

[Ninad_1]

This is probably because you are not using su - oracle [ or whatever your oracle user is ] while running the script.
e.g. I have a script named ora_start_stop, which starts/shuts down oracle database through cluster package control script. In the Cutome defined scripts for start cmds I use
su - oracle -c "/var/oracle/admin/scripts/ora_start_stop start"

How are you calling your script ? Are you running it as oracle user in the 1st place ?

Regards,
Ninad

[boomer_2]

Hi Ninad and Ralplh,
U r absolutely right wer not using
su - oracle...
we r planning to take a downtime and just reconfigure the scrpt...
Bur just tell me 1 one thing oracle running as daemon wont hamper my producn database right ?????.

[Ninad_1]

Did the database start without any errors ? If so and otherwise I dont believe, it would hamper your database.
Your database knows exactly which user is allowed what accesses and privileges.
And further more, once your database is up, it has its own users with privileges to carry out tasks according to their roles and privileges.
Just take an outage, bring down the database cleanly and start database with user oracle.
Only one thing I would suggest you check is (Which I am not sure, but believe should not be a problem) is the ownership of the data and control files of your database, has it changed ?

Regards,
Ninad

[boomer_2]

Hi Ninad,
Thanx 4 ur suggestion....i have checked data and control files ..all r fine and owned by oracle only.......

[Ninad_1]

Then it doesnt seem any problem to me at all.
Please bounce the database (starting as oracle user) and it should be fine.
By the way, thanks to you too as your points have enabled me to achieve my next milestone of 2500 points.

Regards,
Ninad

[boomer_2]

Hey Ninad,
U truly deserve those points...
I have posted one more query ,could u also look into it..subject being :->

Want to run a script/job as soon as file comes at a particular directory


Regards,
Boomer.