database is active or not

[Former Member]

hi, tell me,

How you will check whether database is active or not from OS level? - --

[Former Member]

Hi,

Just we can check this with sqlplus.....R3trans will give us only the connectivity between database and SAP....In BRTOOOLS aslo one option to check the same that is starting/stopping database...but this is the long process than sqlplus.....

warm regards

Harish K Reddy

[Former Member]

Hello,

in command prompt

R3trans -d,, command for wether DB is up or not

in 00 -- indicates DB is connected

12 -- it indicate error..

regards,

balaram

[Former Member]

Hi,

you can check with sapdba or brtools also.

Anil

[manu_susankar]

Hi THIRU MALAI,

R3trans -d gives the connectivity to the sap to DB, to check Db is active check the status of Db processers are they running or not and check listner service too. you can also check the status of DB with the help of sapdba/brtools.

Regards,

S.Manu.

[Former Member]

Easiest way is hit

sqlplus "/as sysdba"

if it gives you your oracle version and all other info....your db is running

If you get messgae as Connected to Idle instance your db is not up.

[Former Member]

Hi,

Give the command r3trans -d by logging into SIDADM user.

Rgds,

Suman