how will you check whether database active or not from OS level?

Answer Posted / 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.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between synchronous and asynchronous transport

650


What is “data sets” in sap?

680


What will you do if u got Update failure?

1367


Do? If another user wants to share that lock but the user using that

1291


Mention what is the purpose of table usr02?

655






What are common background jobs that will run in your system?

2125


How you can apply sap notes to sap system?

648


For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?

1435


How you will do that?

1635


What do you understand by sap client administration?

616


What is a developer key? and how to generate a developer key?

653


What are the daily transactions?

646


Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?

1863


What is your UNIX experience and the types of UNIX systems you have worked on.

1589


What is the difference between asynchronous and synchronous transport?

613