Adds a database configuration to Oracle Clusterware.
Use the srvctl add database
command with the following syntax:
srvctl add database -db db_unique_name [-eval] -oraclehome oracle_home [-node node_name] [-___domain domain_name] [-spfile spfile] [-pwfile password_file_path] [-dbtype {RACONENODE | RAC | SINGLE} [-server "server_list"] [-instance instance_name] [-timeout timeout]] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY"] [-startoption start_options] [-stopoption stop_options] [-dbname db_name] [-acfspath "acfs_path_list"] [-policy {AUTOMATIC | MANUAL | NORESTART}] [-serverpool "server_pool_list" [-pqpool "pq_pool_list"]] [-diskgroup "disk_group_list"] [-verbose]
Table A-8 srvctl add database Parameters
Parameter | Description |
---|---|
-db db_unique_name |
Unique name for the database. |
-eval |
Use this parameter to hypothetically evaluate the impact of the command on the system. Note: You can only use this parameter with a policy-managed database. |
-oraclehome oracle_home |
The path for the Oracle database home directory. |
-node node_name |
Node name on which you want to register a noncluster, or single instance, Oracle database. Note: This parameter can be used only with Oracle Clusterware and can be used with the |
-___domain db_domain |
The ___domain for the database Note: You must use this parameter if you set the |
-spfile spfile |
The path name of the database server parameter file. |
-pwfile password_file_path |
Enter the full path to the ___location of the password file. |
-dbtype {RACONENODE | RAC | SINGLE} |
The type of database you are adding: Oracle RAC One Node, Oracle RAC, or single instance. The default is |
-server server_list |
List candidate servers for Oracle RAC One Node databases. Notes: You can use this parameter only with administrator-managed Oracle RAC One Node databases. If your Oracle RAC One Node database is policy managed, you cannot use this parameter. |
-instance instance_name |
Instance name prefix for Oracle RAC One Node databases. The default value for this parameter is the first 12 characters of the global unique name of the database. Notes: You can use this parameter only with administrator-managed Oracle RAC One Node databases. If your Oracle RAC One Node database is policy managed, you cannot use this parameter. |
-timeout timeout |
Online database relocation timeout, in minutes, for Oracle RAC One Node databases. The default is |
-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY} |
The role of the database in an Oracle Data Guard configuration. The default is See Also: Oracle Data Guard Concepts and Administration for more information about database roles |
-startoption start_options |
Startup options for the database, such as Notes:
See Also: SQL*Plus User's Guide and Reference for more information about startup options |
-stoption stop_options |
Stop options for the database, such as See Also: SQL*Plus User's Guide and Reference for more information about shutdown options |
-dbname db_name |
The name of the database, if it is different from the unique name given by the |
-acfspath "acfs_path_list" |
A single Oracle ACFS path or a comma-delimited list of Oracle ACFS paths enclosed in double quotation marks ( Use this parameter to create dependencies on Oracle ACFS file systems other than |
-policy {AUTOMATIC | MANUAL | NORESTART} |
Management policy for the database.
|
-serverpool "server_pool_list" [-pqpool "pq_pool_list"]] |
Comma-delimited list of server pool names used to control database placement. If you do not specify this parameter, then it defaults to the Generic server pool. You can optionally also specify a comma-delimited list of parallel query server pool names to be used by the database. Notes:
|
-diskgroup "disk_group_list" |
Comma-delimited list of Oracle ASM disk groups if database uses Oracle ASM storage |
An example of this command to add a policy-managed Oracle RAC database is:
srvctl add database -db crm -oraclehome /u01/oracle/product/12c/mydb -___domain example.com -spfile +diskgroup1/crm/spfilecrm.ora -role PHYSICAL_STANDBY -startoption MOUNT -dbtype RAC -dbname crm_psd -policy MANUAL -serverpool "svrpool1,svrpool2" -diskgroup "dgrp1,dgrp2"
An example of this command to add an administrator-managed database is:
srvctl add database -db crm -oraclehome /u01/oracle/product/12c/mydb -___domain example.com