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


Please Help Members By Posting Answers For Below Questions

What is the system's configuration required to implement SAP.

881


How to make security authorization reports?

1665


Have u applied patches what is the transaction code?

632


What is you allocate disks to different areas in sap?

766


Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.

2201






Explain kernel upgrade?

609


What are the activities you done in PI?

2563


What is the need of having Development system?

1327


While doing implementation do you get any issues?

1255


please share sap basis admin interview questions .. thanks sadik

875


How to setup RFC connection in ecc6 tells me steps involved?

1675


What is the difference between consolidation and development route ?

730


Explain what are the functional modules used in sequence in bdc?

590


Difference between system refresh and client copy?

2318


Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.

1764