on 07-19-2009 8:23 PM
Does anyone have scripts that they could share to show if SAP is up/down and Oracle up/down?
I realize grep awk etc etc...but if anyone has any complex queries to query multiple instance maybe via remsh?
Thanks
Mikie
Hi,
One is option as you know ps -aef|grep ora,ps -aef|grep smon etc ...
second you can check tnsping service if not able to ping that means db not available.$ tnsping <sid/servicename>
third if you have mulitple instances then run below query
SQL> conn / as sysdba
SQL>select instance_number, instance_name,status from v$instance
SurendraJain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Not sure for a script on SAP but you can use the following command to check the status of oracle.
brspace -p init<DBSID>.sap -s 20 -l E -f dbshow -c dbstate
Regards
Anil Verma B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.