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
.