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

I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?

1863


Hi I am new in this forum and in this practice. can anyone help me out in finding out how to get training material for SAP CRM 2007.

1759


What is the use of kernel in sap system? How do you check the current kernel version in sap system?

605


In what ways you would know whether a system is unicode or non-unicode?

580


What is development class? Why to create the development class?

597






describe how SAP handles Memory Management?

645


What is the use of profile paramater ztta/roll_area?

673


what is the common storage file for oracle ?

1643


Explain logon groups?

728


what post steps and pre steps db refresh

2679


i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com

1665


What is the different architecture between SAP 4.7EE & ECC5.0

2581


When should we use Transactional RFC?

643


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

667


What do you understand by executing background jobs in sap system?

581