OraFAQ Forum: Linux » Shell script to check Oracle Availability

Home » Infrastructure » Linux » Shell script to check Oracle Availability (Oracle 11g, 11.2.0.4, linux 6.9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Shell script to check Oracle Availability [message #674020]

Thu, 27 December 2018 00:38

nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN

Junior Member

Dear Friends,

I am looking for shell script that script check the database up or not if not then send the email, does any one have. Please share

Report message to a moderator

Re: Shell script to check Oracle Availability [message #674021 is a reply to message #674020]

Thu, 27 December 2018 00:56

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Try to connect with sqlplus:
echo 'exit' | sqlplus -l foo/bar@db
2/ Check return code $?, if not 0 send mail

Report message to a moderator

Re: Shell script to check Oracle Availability [message #674023 is a reply to message #674021]

Thu, 27 December 2018 01:46

nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN

Junior Member

Hi,
thanks i want to write script like that

echo "`date` "
echo "Oracle Database(s) Status `hostname` :\n"

pslist="`ps -ef | grep pmon`"
echo "$pslist" | grep "ora_pmon_$pslist" > /dev/null 2>$1
if "$pslist" | grep "ora_pmon_$pslist" is null > /dev/null 2>$1
then
echo "Oracle Instance - $pslist: Down"
else
echo "Oracle Instance - $pslist: Up"
fi

Report message to a moderator

Re: Shell script to check Oracle Availability [message #674024 is a reply to message #674023]

Thu, 27 December 2018 02:49

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So what is the problem then?

Please read How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: Shell script to check Oracle Availability [message #674025 is a reply to message #674023]

Thu, 27 December 2018 03:13

nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN

Junior Member

see the results.

[oracle@hostname ~]$ sh db1.sh
Thu Dec 27 14:10:32 PKT 2018
Oracle Database(s) Status newtest-db :\n
db1.sh: line 6: $1: ambiguous redirect
db1.sh: line 7: oracle 48883 1 0 14:04 ? 00:00:00 ora_pmon_dbse
oracle 49550 49548 0 14:10 pts/3 00:00:00 grep pmon: No such file or directory
db1.sh: line 7: $1: ambiguous redirect
Oracle Instance - oracle 48883 1 0 14:04 ? 00:00:00 ora_pmon_dbse
oracle 49550 49548 0 14:10 pts/3 00:00:00 grep pmon: Up
[oracle@hostname ~]$ vi db1.sh
[oracle@hostname ~]$

its showing database is up but if database is down so how it would capture?

Report message to a moderator

Re: Shell script to check Oracle Availability [message #674026 is a reply to message #674025]

Thu, 27 December 2018 03:14

nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN

Junior Member

when i shutdow the database its showing below

[oracle@localhost ~]$ sh db1.sh
Thu Dec 27 14:13:28 PKT 2018
Oracle Database(s) Status newtest-db :\n
db1.sh: line 6: $1: ambiguous redirect
db1.sh: line 7: oracle 49781 49779 0 14:13 pts/3 00:00:00 grep pmon: No such file or directory
db1.sh: line 7: $1: ambiguous redirect
Oracle Instance - oracle 49781 49779 0 14:13 pts/3 00:00:00 grep pmon: Up
[oracle@localhost ~]$

Report message to a moderator

Re: Shell script to check Oracle Availability [message #674031 is a reply to message #674026]

Thu, 27 December 2018 10:25

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You need to have somewhere the list of instances you want to check, it could /etc/oratab and loop on them to check if pmon exists.

Report message to a moderator

Previous Topic:	ORA-01994: GRANT failed: password file missing or disabled
Next Topic:	Perfect Linux Installations

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 26 07:19:04 CDT 2023