Exadata Software - Oracle Exadata Recipes: A Problem-Solution Approach - page 44

ONLINE ONLINE cm01dbm01
ONLINE ONLINE cm01dbm02
ora.DBFS_DG.dg
ONLINE ONLINE cm01dbm01
ONLINE ONLINE cm01dbm02
ora.LISTENER.lsnr
ONLINE ONLINE cm01dbm01
ONLINE ONLINE cm01dbm02
ora.RECO_CM01.dg
ONLINE ONLINE cm01dbm01
ONLINE ONLINE cm01dbm02
... Additional CRS resources omitted
[root@cm01dbm01 ~]#
As you can see, we have several Oracle Clusterware resources running under Oracle Grid Infrastructure CRS
services. Query your Oracle CRS version by running crsctl query crs activeversion :
[root@cm01dbm01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.3.0]
[root@cm01dbm01 ~]#
From this listing, we know that on this Exadata compute server we're running Oracle Clusterware 11.2.0.3.0.
From the crs_stat output, we see four database resources (one of which is shut down), ASM resources, and Grid
Infrastructure network resources.
You can examine the resource configuration of one of your databases using srvctl :
[oracle@cm01dbm01 ~]$ srvctl config database -d visx
Database unique name: visx
Database name: visx
Oracle home: /u01/app/oracle/product/11.2.0.3/dbhome_1
Oracle user: oracle
Spfile: +DATA_CM01/visx/spfilevisx.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: visx
Database instances: visx1,visx2
Disk Groups: DATA_CM01,RECO_CM01
Mount point paths:
Services:
Type: RAC
Database is administrator managed
[oracle@cm01dbm01 ~]$
Our VISX database consists of two instances, visx1 and visx2 , configured with Oracle RAC. We can also see that
this database uses the DATA_CM01 and RECO_CM01 ASM disk groups, the binary server parameter file ( spfile ) resides
in the DATA_CM01 ASM disk group, as well as the instance's Oracle software home. Let's validate which server each
instance runs on:
[oracle@cm01dbm01 ~]$ srvctl status database -d visx