Unix script to check oracle database 5

[praise72034]

Hey there,
I would like to know how to write a unix script to check whether the oracle database is up or not. Any tips or guidance is appreciated.
Thanks,
p.

 

[KenCunningham]

You could try connecting to the database something like this:

sqlplus user/password <<!
exit
!

and check for the return code, $?. If it's zero all is well, if not, your database isn't available for whatever reason. Be aware that this carries the security risk of a username/password in plain text within a script.

 

[KenCunningham]

That said, I guess if you created a user with the minimum permissions within the database, the security issue might not be so much of a stumbling block. Others might disagree, however....

 

[Mike042]

At the site where I work, we wanted to use a UNIX script that didn't actually access the database, so we use the following:
Pass the Oracle SID to a function
Check the existence of the 4 essential processes:
(ie ora_pmon_SID , ora_smon_SID , ora_dbw0_SID & ora_lgwr_SID)
Set a variable to the count of the ones that are present
Any value less than 4 means the database is not up
(value of 0 means not even started, values 1 to 3 mean a process is missing)

Whilst I acknowledge that a value of 4 doesn't always guarantee that a database is up, we have yet to come across a situation where the value was 4 and the database was not available.

I hope that helps.

Mike

 

[RMGBELGIUM]

You must also check if the listener( or multiple listeners) is running, otherwise the database is running, but nobody can connect

ps -ef|grep LISTENER|grep -v grep

greetz,

R.

 

[SamBones]

There's an Oracle utility called [tt]tnsping[/tt] that will ping the listener. This doesn't guarantee the database is up, but is a good first step in a script.

If the default test account has been left in, you can try the login test above using the userid [tt]scott[/tt] with the password [tt]tiger[/tt].

Hope this helps.

 

[coffeysm]

I use big brother to monitor all my services, if you goto

http://www.deadcat.net

they have some oracle scripts you will have to modify them though.

 

[stefanwagner]

instead of

ps -ef|grep LISTENER|grep -v grep

I would use

ps -C tnslsnr

if your ps supports commandnames.

To issue an 'select sysdate from dual' seems to be more secure as stated above.

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung