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

Answer Posted / gopi

login to the DBhost then
sqlplus "as/sysdba"
select status from v$instance;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2131


I would like to know the version or name of SAP that is implemented in real time?

678


What is the importance of table t000?

681


You want to find out which users have an access to a particulat transaction. How would you do that?

650


How would you troubleshoot the 'system seems slow'?

665






what is role of sap administrator in pi & ep?

2026


Explain what is the importance of table t000?

715


what is the common storage file for oracle ?

1663


What is Unit Testing in SAP?

784


what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?

2010


Explain logon groups?

746


What are the tools to install java patches?

629


Which table contains the details related to Q defined in SPAM? Is there a way to revert back the Q defined? If yes, How?

795


suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?

1571


what is garbage collector. is there any way to set the time to gc?

3635