how will you check whether database active or not from OS level?
Answer Posted / s thotla
from Ora<sid> give the following the commands
ps -ef |grep ora_
ps -ef |grep pmon
If all the Oracle background process are running we can say
that oracle is up and running.
OR
connect to the sql like sqlplus "/as sysdba"
sql> select status from v$instance;
if the output is "open" we can say that Oracle up and
running fine.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
How to define logon groups?
describe how to setup a printer in SAP or where they would look to research why a user/users can not print?
what is role of sap administrator in pi & ep?
How to assign a mass Tables in Auth Group by using T-code:se54
what are the current support stack levels at market place?
can u explain step by step procedure of DB REFRESH..Ravi
What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?
What are the Parameters need to be set when connecting EP to r/3 system what are they?
How will u send mail after completion of backup?
Explain what is “data sets” in sap?
How you will rate yourself in SAP, Oracle from a scale 1 - 10?
What is transport domain?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
can we give one check for all vendors in automatic payment run? how?