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 will you observe in System log (SM21)?

1 Answers  

what is the syntax of niping command?

4 Answers   Genpact, Satyam,

What is the difference between a Transport Domain and a Transport group.

6 Answers  

If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?

2 Answers   TCS,

where can u check the sap errors in windows as the windows system was down.some have windows admin make the system up.where u check the error logs ?how to find the problem is with the os or sap?

1 Answers   Fujitsu,

Locks haven't released lock he went for holiday what will u do? This

1 Answers  

Explain deletion flag. Where is it used in archiving process?

0 Answers  

What happens when in background when we shutdown SAP (Both central & Database) & where is the log stored. Also when we apply the Patches, what exactly is running in background.. Kindly help me with this answer..

4 Answers  

What is the command to see the list of TCodes ?

5 Answers  

How to delete client?using SE37--> fucntion-> SCCR_LOCK_CLIENT, press f8 now where should i put the client number?? after that? it says import parament and value and it's greyout what to do next? pls explain me step by step.

2 Answers  

How to login in o.s level with <sid>adm user in sap basis ?  please tell me step by step ?

6 Answers   IBM,

can i know the relation between sap security and Grc tools

2 Answers   IBM,