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 is the difference b/w ECC5.0 & ECC6.0?

2 Answers   Logica CMG,

What is check point?? chkpt??

2 Answers   HCL,

How to configure web ui in crm 7.when i am trying to access web ui it gives some error like "Business Server Page (BSP) error What happened? Calling the BSP page was terminated due to an error. SAP Note * The following error text was processed in the system: Die URL enthält keine vollständige Domainangabe (mgpl0001 statt mgpl0001.<domain>.<ext>). Exception Class CX_FQDN Error Name Program CX_FQDN=======================CP Include CX_FQDN=======================CM002 ABAP Class CX_FQDN Method CHECK Line 10 Long text -" what i need to do?.Notify me of follow-up comments via email.my email id is mvraghunatha@gmail.com.Please advice if anybody faced such kind of issue.Could any one help in this regards. It is very urgent. Thanks in advance RAGHUNATH

1 Answers  

What does Sap_All and Sap_New Parameters define for a user who is granted with permissions?

5 Answers  

What is organization level ?

3 Answers   Wipro,

Is there any report or table in which user log off time is stored in sap?

0 Answers  

What is supplementation language?

3 Answers   IBM, TCS,

what is authorization profile?

1 Answers  

Hi Al I have a small querry in SAP there are different type of Users one of them is System User I want to know why the system user is created and if created what is use of them and how they are associated with the Dialogue User ,As we all know Dialogue user can perform all work in Sap by logging in the sap server , so why the system user is created and how they are associated with Dialogue user With Rgds

8 Answers  

Why can't we do it thru some other client?

0 Answers  

How to Start & Start Java at OS level (Windows)

7 Answers   Wipro,

How you will give new authorizations?

0 Answers