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 is BEx?
How do you handle the lock entries?
What is difference between oracle 9i and oracle 10g?
How to define Logon groups? And what is Logon load balancing?
Hello Guys, If any body looking for "SAP Vendor Invoice Management (VIM) Training", Please Contact Me,We will covers all SAP VIM topics along with end to end ICC, Document pipeline xECM, Enterprise scan etc. Email ID :kakumanusasikanth@gmail.com
After client copy is table space and database sizes will be increased or not?
What is the T code to start the livecache ? how to start the live cache if you could not able to login to the SAP System ?
How many types of Work Process.and types of roles. how will assign the role to the user.
HOW MUCH RATED YOUR SELF IN "BASIS" ? IS IT INTERVIEW QUESTION? WHY INTERVIEWERS ARE ASKING THESE TYPE OF QUESTIONS INSTEAD OF ASKING TECHNICAL QUESTIONS IN TECHNICAL ROUND ?
How can we see system logs os SAP at OS level?
How to define instances and operation modes?
how do you troubleshoot when user complains that he is not getting login screen?