Interested to Buy Any Domain ? << Click Here >> for more details...
how will you check whether database active or not from OS level?
- 11 Answers
- 33288 Views
- I also Faced
- E-Mail Answers
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
Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
How to deactivate IPC in standalone CRM.
How to make security authorization reports?
I am attempting to complete a system copy of bw. When I try to go in to rsa1 afterwards I get the error message, "entry in inbound table already exists." What should I do to solve the problem?
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
you want to do a system-copy. List the steps you will take.
If a user complaints that he could not execute some of the transaction codes then what will you do?
How to perform a sap-export and import tables in sap from os level?
How do you check the users logs in your system and how many sessions each user is generating?
list some common errors faced with jspm while updating java stcks.and solutions.
TMS Configuration?
What is R/3? and what is basis version?
Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.
What is the difference between developer trace, system log and system trace?
