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.

How to take back up on EP?

1 Answers  

If the data buffer quality, log buffer Quality <95%, then what should be done by the Basis consultant?

3 Answers   CSC, IBM,

What is transport domain?

6 Answers   BOC,

What should be the approach for writing a BDC program?

3 Answers  

1)Have you used performance tuning? What major steps will you use for these? 2)In production what is the user exit? 3)What type of user exits have you written? 4)Difference between Search Helps and Match Codes 5)On which even we can validate the input fields in module progams? 6)what are the table controls in BDC ? 7)what is the difference between bdc and lsmw ? 8) If the scripts are client dependent, what above driver program ? (client dependent / independent) 9). I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 10) Will 50,000 records be uploaded directly into APP's Server? 11) What is the button to change the variant in ALV ? 12) If your project is support project ? when is your implementation has completed ? 13)In start of selection, if we perform validation, what happens ? 12)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 13)How to transfer data which is coming from are report as output to another report 14)How to create standard text and how do u transfer it ? 15)What are the views when we are creating Material ?

0 Answers   ABC,

What is sap netweaver administrator tool?

0 Answers  

What the immediate steps if the instance did not came up after restart in both AS ABAP and AS Java?

1 Answers   TCS,

Did you use Java stack. My answer was "No". If somebody's answer is "Yes", please elobrate what did you do, what is it and usage and etc. You might want to give some reference to read as well.

2 Answers  

What is R/3? and what is basis version?

0 Answers   IBM,

how to create list of users available in a client?

6 Answers   IBM,

sir/mam i m fresher for sap basis i need resume format for interview i have worked with HCL infosystems Ltd. for Last 4and 1\2 year as a technical suppoert and i know about logistic process in SAP...please any one help me send it to my E-mail id (charita87@gmail.com

1 Answers  

How will determine whether your sap server is unicode or ascii ?

0 Answers