How to identify the RAC database?
Once we connect to RAC cluster how DBA can identify whether the database is RAC or standalone?
- There are many ways to identify
1. ps -ef|grep smon
2. using srvctl commands
srvctl config database -d DEVDB
srvctl status database -d DEVDB
3. show parameter cluster_database
4. using gv$ views
SELECT inst_id, dbid, name FROM gv$database
select INST_ID,INSTANCE_NAME,HOST_NAME from gv$instance;
5. using crsctl commands
crsctl stat res -t
#rac #database #asm #mallik034 #vismotechnologies #oracledba #oraclecarrers #oracleworld #training #onlinetraining #liveclasses #filesystem #RACdatabase
Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: mallikarjun.ramadurg@gmail.com / vismotechnologies@gmail.com / info@vismotechnologies.com
2 окт 2024