Showing posts with label check. Show all posts
Showing posts with label check. Show all posts

Monday, 12 September 2011

How will you check whether database active or not from OS

There are so many options to check whether DB is active or not1. ps -ef |grep ora2. ps -ef |grep ora_3. ps -ef |grep pmon4. R3trans -d ; give RC - 0000 means active other than 0000 is error5. 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 s6. we can also check for SQLSQL> select status from v$instance;STATUS------------OPEN7. From SAPDBA, it will show the status on top.

Friday, 2 September 2011

How do I check for errors in R3

Run transaction SM21 for read the System Log.

Sorry, I could not read the content fromt this page.