how will you check whether database active or not from OS level?
- 11 Answers
- 31230 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
Where is the Deletion Flag or Indicator used in archiving process?
Explain deletion flag. Where is it used in archiving process?
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
What are the errors you got while applying support pack?
How can you find a list of objects that have been repaired in the system?
What is the difference between Party & Service without party in XI (ID)?
what is your project architecture?
Which transport directory is used to implement support package and add-ons?
You want to find out which users have an access to a particulat transaction. How would you do that?
in oracle script @? "?" question mark means what it indicate?
What do you understand by sap client administration?
What is upgrade process? And how u will do that?
What are the different user types in sap system that an admin can use while creating a new user?
Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?
Explain what is heterogenous system copy and homogenous system copy ?
