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.

What to do if If Buffer Hit ratio is less than 95%

3 Answers  

What will you do when there is a performance issue?

2 Answers  

How to login in to SAP from command level?

2 Answers  

What is sap netweaver administrator tool?

0 Answers  

how can u connect sap and non sap systems?

1 Answers   iGate,

How do find the SNOTE?

1 Answers  

Explain how to define logon groups?

0 Answers  

In CUA, I am unable to changes from DEV to QAS or PRD.How to troubleshoot this problem?

2 Answers   Terrenos,

How do you create an instance?

0 Answers  

how many printers are there in the land scape

1 Answers   L&T,

1.How could an user know in which instance he has logged on if there is one central instance and four dialog instances 2.in ecc system how to know up to what package level the basis and abap support packs needs to be updated. Depending upon the remaining components(hr,appl...)

1 Answers   CTS,

1.why we configure the domain controle in production why sap recommended? 2.what is the use of 001 client?

3 Answers   HCL,