| How to identify a DB is up or not through a script [message #97165] |
Tue, 01 January 2002 16:30  |
O. Vamsi Krishna
Messages: 3
Registered: January 2002
|
Junior Member |
|
|
Hi,
Is there anyway to identify, through a script, if a Oracle DB is up or not. We can connect using sqlplus utility and if there is any error during connecting, then we can identify it. But i want to know if there is any other method.
Regards,
Vamsi
----------------------------------------------------------------------
|
|
|
|
| Re: How to identify a DB is up or not through a script [message #97175 is a reply to message #97165] |
Fri, 04 January 2002 09:47  |
David Smelker
Messages: 2
Registered: January 2002
|
Junior Member |
|
|
There are multiple ways of testing to see if the database is up. On Unix the simplest way I know of is to check to see if the backround processes are running. This only means that the instance is up, but if you have a database failure the instnace should come down as well. Can incorporate the following line into a script and schedule it to run.
ps -ef | grep -v grep | grep ora_smon_$DBNAME
where $DBNAME is set to the name of the database you want to check.
----------------------------------------------------------------------
|
|
|
|
| Re: How to identify a DB is up or not through a script [message #97289 is a reply to message #97175] |
Mon, 25 February 2002 11:26 |
D Shashikanth
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
Hi.
I have difft. problem in this regard. On one fine morning, I found that the instance was up, but I wasn't able to access my DB. That was because due to a memory lock by some program, the DB hung, it just hung thats all. And even if I try a script as below:
sqlplus username/password <<!
exit;
!
and after this I grep for the process id of sqlplus, or check the exit status of sqlplus command, it didn't work because the shell never exited out of the sqlplus command cozz DB was hung.
How do I identify such a situation?
Regards,
Shashikanth.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
