Monitoring Oracle instance in db package near SGeSAP enviroment

[Scout (PathFinder)]

Hi,
I have two package ci00 and db00 for ERP system. In ci00 i can monitoring a Message Server and Dispatcher Server using scripts from SGeSAP. As example:
SERVICE_NAME ci00disp
SERVICE_FAIL_FAST_ENABLED yes
SERVICE_HALT_TIMEOUT 300


SERVICE_NAME[0]="ci00disp"
SERVICE_CMD[0]="/etc/cmcluster/PER/sapdisp.mon "
SERVICE_RESTART[0]=""

Testing failover ci00 package passes successfully.
But i want monitoring state of Oracle instance in db00 package. Standard scripts from SGeSAP to me will not allow to make it. Oracle toolkit not applicable for this task.
T1905CA A.11.18.00 Serviceguard
T2803BA B.04.51 Serviceguard Extension for SAP
B5140BA A.11.31.02 Serviceguard NFS Toolkit



How to me to find solution for this task using standard way?

[Volker Borowski]

Hi,

you can monitor the DB of a SAP System in several ways using SAP programs.

As user orasid:
brconnect -c -u / -f dbstate

As user sidadm:
R3trans -d

The first does a direct connect,
the R3trans call does an SQLNET connect, so if "R3trans -d" works you'll know that the listener is working as well.

There may be need to check for an archiver stuck in addition (i.E. oracle alert log).

And there may be need to validate the cpu usage is not at 100%, which could cause a timeout of one of the previous actions, but you would normally not like to initiate an immediate failover in this case.

Volker

[Scout (PathFinder)]

Hi Volker,
thanks for you reply message.
It is not a better way. I need monitor DB like using Oracle toolkit.