how will you check whether database active or not from OS level?
Answer Posted / srinivas laddika , intelligrou
There are so many options to check whether DB is active or
not
1. ps -ef |grep ora
2. ps -ef |grep ora_
3. ps -ef |grep pmon
4. R3trans -d ; give RC - 0000 means active other than 0000
is error
5. in Brtools 1.Instance Management, 6 - Show instance
status, 3-Database instance, give the instance name i mean
Database Name and press continue....give the status
6. we can also check for SQL
SQL> select status from v$instance;
STATUS
------------
OPEN
7. From SAPDBA, it will show the status on top.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Which transport directory is used to implement support package and add-ons?
How would you troubleshoot the 'system seems slow'?
Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
Have you done any parameter changes using configtool and visual admin tool?
I would like to know the version or name of SAP that is implemented in real time?
Explain what is the purpose of tdevc ?
How much swap memory should be in the system?
While doing implementation do you get any issues?
Example you have 6 sap application servers, I want to monitor all the application servers. How to configure a CCMS?
what post steps and pre steps db refresh
What are the different types of rfc?
What is difference between oracle 9i and oracle 10g?
Explain transport domain?
What are common transport errors and their codes?