How to check oracle is running or not

[Former Member]

Hi,

Can any one help me the command to check whether oracle is running or not, in UNIX flatform.How to check the Disk+Work proess is running or not.

[Former Member · Accepted solution]

Hi Surya,

In Unix, please execute

ps -ef |grep ora - This will shows all oracle running processes

ps -ef |grep sap - This will show all disp+work running processes

Hope this helps.

regards,

VInodh.

[Former Member · Accepted solution]

Hi Surya,

To check whether oracle is running or not, you can also use brspace command to check the status of oracle database.

login to ora<sid>.

execute brspace command.

This shows the status of your database. If you are using versions below 4.6C, then this command will not be found. Instead you have to use sapdba.

Thanks and Regards,

Sailesh K

[Former Member · Accepted solution]

Option1 :Logon to SAPDBA...U will be able to see whether Oracle is running or not.

Option 2:

Sqlplus /nolog;

connect / as sysdba;

startup;

If it is already running: you will get msg that Oracle is already running

Oprion 3: ps -eaf|grep ora

to determine whether disp+work is running or not:

Option 1: ps -eaf|grep sap

Option 2: dpmon pf = <path of instance profile>

Reward Points if helpful!

[Former Member]

Hello,

Simple way to check if the DB is up and the connectivity to DB is fine is as follows:

1.Loginto the Central Instance Box as user <sid>adm

2. Execute R3trans -d

It should get complete with the error code 0000

Simpleway to check is disp+work is running is as follows:

1.Loginto the Central Instance Box as user <sid>adm

2. Go to your exe directory

3. Execute the following:

dpmon pf=<path of your instance profile/instance profile>

This will give you the same WP table which you do see in transaction SM50

Regards,

Mathan.