For an administrator-managed database, this command modifies the configuration for a database instance from its current node to another node. For a policy-managed database, this command defines an instance name to use when the database runs on the specified node.
Note:
You cannot use this command to rename or relocate a running instance.
This command is only available with Oracle Clusterware and Oracle RAC.
Use the srvctl modify instance command with the following syntax:
srvctl modify instance -db db_unique_name -instance instance_name -node node_name
Table A-81 srvctl modify instance Parameters
| Parameter | Description |
|---|---|
-database db_unique_name |
Unique name for the database |
-instance instance_name |
Database instance name Note: If you are modifying a policy-managed database instance, then the instance name must contain an underscore ( |
-node node_name |
Name of the node on which to run the instance. You can set the value of this parameter to |
The following example to changes the configuration of an administrator-managed database, amdb, so that the database instance, amdb1, runs on the specified node, mynode:
$ srvctl modify instance -db amdb -instance amdb1 -node mynode
The following example causes the policy-managed database pmdb, when and if it runs on mynode, to use the instance name pmdb1:
$ srvctl modify instance -db pmdb -instance pmdb1_1 -node mynode
The following example removes the directive established by the previous example:
$ srvctl modify instance -db pmdb -instance pmdb1_1 -node ""