how will you check whether database active or not from OS level?
- 11 Answers
- 29571 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
What is sap netweaver administrator tool?
Explain segment?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
How to uncar car/sar files in a single shot?
How you will give new authorizations?
How you will rate yourself in SAP, Oracle from a scale 1 - 10?
Explain deletion flag. Where is it used in archiving process?
If client copy is stopped in middle, what happens if you want to start it again?
Which are the most frequent errors encountered while dealing with transports ?
User wants lock ASAP then what will u do?
Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate
how can i change access to a user who is having access for SPRO display only to change access in sPro
Example you have 6 sap application servers, I want to monitor all the application servers. How to configure a CCMS?
What is heterogenous system copy and homogenous system copy ?
Explain logon load balancing?
