how will you check whether database active or not from OS level?
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 the different architecture between SAP 4.7EE & ECC5.0
What is the use of profile paramater ztta/roll_area?
Example you have 6 sap application servers, I want to monitor all the application servers. How to configure a CCMS?
What is the difference between – support package, kernel and sap note?
How do you distribute the load?
Have you done any parameter changes using configtool and visual admin tool?
How many types of work processes are there in sap ?
What will you do if u got Update failure?
Explain what is the importance of table t000?
How will you define logon groups ? What is load balancing in sap ?
Do you have done System copy? What are the steps?
If a user complaints that he could not execute some of the transaction codes then what will you do?
What are the different modules of SAP?
What is the system's configuration required to implement SAP.
What are the activities you done in PI?