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 r errors u faced while appling patches
During backup what kind of files you take?
In sap basis what are the different types of transport requests?
How ORAARCH (:\oracle\DEV\oraarch) directory is configured, what is the maximum size of ORAARCH directory, how to see? briefly....
What are Management services in SAP BASIS?
How you can assign an object to 100 roles at time?
difference between composite role and derived role
Kernel upgrade steps in dual stack and java stack.
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
I have created a role for user. Now i want to unauthorize to user for particular TCODE. Now, what i'll do for this?
how can i check the user login details activity in a month
describe how SAP handles Memory Management?