Answer / s thotla

from Ora<sid> give the following the commands
ps -ef |grep ora_
ps -ef |grep pmon
If all the Oracle background process are running we can say
that oracle is up and running.
OR
connect to the sql like sqlplus "/as sysdba"
sql> select status from v$instance;
if the output is "open" we can say that Oracle up and
running fine.

Answer / bishnu lal sahu

use command in os level

R3Trans -d

if the return code is 000, means the connection is good.


Bishnu Lal Sahu
SAP BASIS Consultant
Yogik Tech Pvt. Ltd
bishnulalsahu@rediffmail.com

Answer / devender

type in cmd R3trans-d there return code 000 is active or
0012 error

Answer / jayesh selokar

at unix O/S

type ps -ef|grep ora

will tell you the database status

Answer / m.balarami reddy

Hello,

U can check on windows -- R3Trans -d
UNIX ----- ps -ef|grep ora

regards,
balaram

Answer / srinivas laddika , intelligrou

There are so many options to check whether DB is active or
not

1. ps -ef |grep ora
2. ps -ef |grep ora_
3. ps -ef |grep pmon
4. R3trans -d ; give RC - 0000 means active other than 0000
is error
5. in Brtools 1.Instance Management, 6 - Show instance
status, 3-Database instance, give the instance name i mean
Database Name and press continue....give the status
6. we can also check for SQL
SQL> select status from v$instance;

STATUS
------------
OPEN
7. From SAPDBA, it will show the status on top.

Answer / ashley

First login to the database, with the dbmcli command with
appropriate user and password.

The use the below command
>db_state

It lists
OK
State
ONLINE/OFFLINE/ADMIN

Regards,
Ashley

Answer / ranjeet.thind

Yeah... the status can be checked from brtools.........go
to instance management ..check system status........

gud luck

Answer / ganesh varma

sql> select status from v$instance;
when we executed this command the status should be "OPEN"
then we can come to conclusion that the database is up and
running.

Answer / s.m.feroz ahmed

Hi,

By running the command niping -t to self test whether the
SAP Application Server is Installed and working properly
from OS Level.

When applying a support pack to sap system. Can you tell me what are errors you are faced?

4 Answers   Terrenos,

House keeping jobs?

3 Answers  

what is different between SQL AND BRTOOLS in sap?

3 Answers   L&T,

In which frequency your TR gets transported to other system?

1 Answers   Accenture, Wipro,

What are the Prerequisite for Refresh?? If there are 100 rfc before refresh in Quality Systesm, then after refresh..do we need to create them manually in Quality sys.???

2 Answers   ABC,

somebody deleted my TMS configuration unfortunatly how to restore the same.

5 Answers   CSC,

Why is java Required while installing SAP

6 Answers  

Problem in SPAM taking lot of time? Why?

2 Answers  

As a basis consultant what we have to do if a background job is cancelled?

4 Answers   Satyam,

what is the common storage file for oracle ?

0 Answers   IBM,

How to assign a mass Tables in Auth Group by using T-code:se54

0 Answers   Accenture, SASA,

What is redolog file? Path?

0 Answers