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
Is it possible to install ecc 5.0 as a test system and not production, without installing solution manager?
what are the pre-requisites to apply support patch?
How do you check the installed software components and product versions on sap system?
Mention what is the purpose of table usr02?
What is sap netweaver administrator tool?
If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log
How many types of printer you have configured? How do you differentiate between them?
What are the key responsibilities of sap basis administrator?
What is JVM switch. Why JVM switch is required ?
Do you have done System copy? What are the steps?
what is sox and sod in sap ?
if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days
What is private mode? When does user switch to user mode?
What will you do if u got Update failure?
What is SSO? How to configure SSO?