how will you check whether database active or not from OS level?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bishnu lal sahu
use command in os level
R3Trans -d
if the return code is 000, means the connection is good.
Bishnu Lal Sahu
SAP BASIS Consultant
Yogik Tech Pvt. Ltd
bishnulalsahu@rediffmail.com
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / jayesh selokar
at unix O/S
type ps -ef|grep ora
will tell you the database status
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / m.balarami reddy
Hello,
U can check on windows -- R3Trans -d
UNIX ----- ps -ef|grep ora
regards,
balaram
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
Answer / ashley
First login to the database, with the dbmcli command with
appropriate user and password.
The use the below command
>db_state
It lists
OK
State
ONLINE/OFFLINE/ADMIN
Regards,
Ashley
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ranjeet.thind
Yeah... the status can be checked from brtools.........go
to instance management ..check system status........
gud luck
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ganesh varma
sql> select status from v$instance;
when we executed this command the status should be "OPEN"
then we can come to conclusion that the database is up and
running.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / s.m.feroz ahmed
Hi,
By running the command niping -t to self test whether the
SAP Application Server is Installed and working properly
from OS Level.
Is This Answer Correct ? | 0 Yes | 0 No |
what u mean by check point in the database of oracle& what return code 247 in TMS mean...
What is the difference between SDM and JSPM?
In nw7.1 the Jstart program is requied to start the central instance
How to make a copied client from the Client 000 cannot be customized?
How to update SAP
best site to download free sap tutorials?
Explain reference and service user in sap. What are their uses?
what is front-end printing
How do you kill a job in SAP?
which is the t- code for system landscape
is it essential to create role name with customer name space 'Z'? (or)is there any rules to create role name?
How to do transport at OS level?