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 |
Explain kernel upgrade?
If SAP* is not available then how u will do?
What is the difference between Central Instance & SID(system id)
how to send an email from EP Portal.
how can a User be able to access only for Customized roles when given pfcg, su53, su56 access?
what is SAPMNT?
How often u do the SSO Cofiguration...
User could not logon to the system? Why?
How many types of work processes are there in sap ?
Hi, I want to know, the detail procedure of Homogeneous System Copy and Heterogeneous System copy stepwise. Can anybody help me //
what is the difference between SAP AND ASAP
what is ora-00252 and ora-00272 error represents how can u prevent this error?how can u trouble shhot this error?