LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (https://www.linuxquestions.org/questions/programming-9/)
-   -   Checking Database it running or not by using shell script (https://www.linuxquestions.org/questions/programming-9/checking-database-it-running-or-not-by-using-shell-script-892878/)

ramslinux 07-21-2011 02:52 AM

Checking Database it running or not by using shell script
 
Hi,

can you please tell me how to write these scripts

1. i need to check whether the oracle database is running or not if it is running it will run auto mount script.

nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt &

nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt &

2. For every 1 hour i need to check above mount points is mounted or not if it is not mounted it should be mounted.

Thanks & Regards
Ram

catkin 07-21-2011 03:33 AM

Regards whether the/an Oracle database is running, here's a netsearch. The fifth item listed is the Oracle database FAQ. The third question is "What database aspects should be monitored?".

A few minutes more searching found a script to do it.

ramslinux 07-21-2011 04:09 AM

hi catkin
 
Hi catkin,

"Regards whether the/an Oracle database is running, here's a netsearch. The fifth item listed is the Oracle database FAQ. The third question is "What database aspects should be monitored?".

A few minutes more searching found a script to do it."

Every body knows how to searching in google.
First try to understand thread after that you can give suggestion if it is related to thread.
otherwise please don't post these type of suggestions.

If you are expert please post answer otherwise please stop these things here only.

I am not that much of expert like you.


Thanks
Ram

catkin 07-21-2011 04:57 AM

Did you click on the links in my post?


All times are GMT -5. The time now is 06:33 AM.