After creating a RAC One Node database using SQL statements, you want to register this database with Oracle Clusterware as a policy-managed resource.
Which command, or sequence of commands, should you use?
A.
srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2
srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron
B.
srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2
C.
srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron –server 016n1, 016n2
D.
srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2
srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2
Explanation:
If your Oracle RAC One Node database did not register automatically with Oracle Clusterware, then use the srvctl add database command to add an Oracle RAC
One Node database to your cluster.
For example:
srvctl add database -c RACONENODE [-e server_list] [-i instance_name] [-w timeout]
When you add services to a policy-managed Oracle RAC One Node database, SRVCTL does not accept any placement information, but instead configures those
services using the value of the SERVER_POOLS attribute.
Note: Use the srvctl add database command to add an Oracle RAC One Node database to your cluster. For example:
srvctl add database -c RACONENODE [-e server_list] [-i instance_name] [-w timeout]
* -c {RACONENODE | RAC | SINGLE}
The type of database you are adding: Oracle RAC One Node, Oracle RAC, or single instance. https://docs.oracle.com/cd/E11882_01/rac.112/e41960/onenode.htm#RACAD8194
Hello
Correct answer should be A.
-server parameter in “srvctl add database” command can be used only with administrator-managed Oracle RAC One Node databases
Correct!
“B” doesn’t have serverpool in the command, like “D”, then, it is managed policy
“C” is incomplete, because doesn’t have a reference about a existing service, like your creation, and yet uses the sintaxe to “managed policy”
srvctl add database: Adds a database configuration to Oracle Clusterware
-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.