Displays the configuration for an Oracle RAC database or lists all configured databases that are registered with Oracle Clusterware.
Use the srvctl config database command with the following syntax:
srvctl config database [-db db_unique_name] [-all] [-verbose]
Table A-22 srvctl config database Parameters
| Parameter | Description |
|---|---|
-db db_unique_name |
Unique name for the database. If you do not specify this parameter, then the utility displays the configuration of all database resources. |
-all |
Print detailed configuration information. |
-verbose |
Display verbose output. |
The srvctl config database command returns output similar to the following:
$ srvctl config database -db myDB Database unique name: myDB Database name: Oracle home: /scott_st2/oracle Oracle user: scott Spfile: Password file: Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: myDB Database instances: Disk Groups: Services: scottsvc1 Type: RACOneNode Online relocation timeout: 30 Instance name prefix: myDB Candidate servers: node1 node2 Database is administrator managed
The preceding sample output shows the database type as RACOneNode, an Oracle RAC One Node database. Other potential types are RAC and SingleInstance. The Online relocation timeout, Instance name prefix, and Candidate servers fields only apply to Oracle RAC One Node databases and do not display for the other two database types. Similarly, the Database instances field is empty because the database type is RACOneNode.