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
Where is the Deletion Flag or Indicator used in archiving process?
Explain the system trace?
Where will u find transport error logs?
In a situation where my sap system is down (users unable to login to sap system), how to analyze the problem?
What is password policy?
What are the daily transactions?
what are the pre-requisites to apply support patch?
A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?
How to apply java stacks ? expalin step by step prcoess
How many types of printer you have configured? How do you differentiate between them?
Explain what is business kpis ?
list some common errors faced with jspm while updating java stcks.and solutions.
What are the different user types in sap system that an admin can use while creating a new user?
What are the activities you done in PI?
can any send unix admin doc? if u have please send it to chanduk29@gmail.com