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 |
Client export/ import pre-requisite?
How do you configure the TMS?
can i know the relation between sap security and Grc tools
Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate
0 Answers Ashok Leyland, Global Step,
How you will find if table is over flow in DB?
If a user complaints that he could not execute some of the transaction codes then what will you do?
can we transport requests from production to development for client copy using scc8?
what is the difference between pfile and spfile
i have t-code su01 in crm and r3 in a financial org.i can create sap ids , unlock /lock sap ids , assign t-code, roles & assignment to users . what else can be done ? more importantly am i eligible for a job in sap basis since i am doing this job for last 2 years ?
3. What are Unicode and non Unicode in sap?
What is the difference between transactional rfc and regular rfc
how to repair the sap* default password,r3 sys log file accur error..
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)