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
How can you view locked transactions?
What settings we have to do in EEWC while using slandalone SAP-CRM system.
I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?
What do you understand by executing background jobs in sap system?
If brtools is not working how you will add datafile?
What is the procedure to applying patches?
How to perform the transport?
Explain deletion flag. Where is it used in archiving process?
what are the main issues you faced in the implementation project?
What is transport domain?
What are steps for DB Refresh?
Explain what is the use of reference and service user in sap?
Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com
What is the difference between Party & Service without party in XI (ID)?
Why do you use DDIC user not SAP* for Support Packs and SPam?