Any scripts to show status of instance and oracle

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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