modify catalog

Syntax

modify catalog [-autovncr {ON | OFF}] 
               [-oldpwd oldpassword -newpwd newpassword] 
               [-pwd password -newkeys]
               [-agent_password password]
               [-agent_port port] 
               [-region region]
               [-recover]

Options

Table 2-54 GDSCTL modify catalog Options

Syntax	Description
`-agent_password password`	Specify the agent registration password in the catalog for the remote Scheduler agent.
`-agent_port port`	Port number for XDB to use. If it is NULL and no current value is set, then it will default to 8080. Execute on catalog as well.
`-autovncr {ON \| OFF}`	This option enables (`ON`) or disables (`OFF`) autovncr mode. The default value is `ON`.
`-newkeys`	Generates a new PKI key pair.
`-newpwd newpassword`	Used along with `-oldpwd`, sets the `GSMCATUSER` password after changing it on the catalog database.
`-oldpwd oldpassword`	Used along with `-newpwd`, sets the `GSMCATUSER` password after changing it on the catalog database.
`-pwd password`	Provides the `GSMCATUSER` password to generate the PKI keys when using `-newkeys`.
`-recover`	Perform catalog recovery to the last consistent state.
`-region region`	Region that the database, catalog, shard, shardgroup, or global service manager belongs to.

Usage Notes

To use this command, there must be a least one global service manager running and a connection with the catalog database must have already been established (see the connect command).

You must connect to the catalog database as a user with the Global Data Services administrator privileges, using the connect command before running this command.

Auto VNCR is best used in environments with simple private networks where ease of configuration is the most important consideration. To have the highest level of control over which hosts may participate in a GDS configuration, disable Auto VNCR and explicitly add the IP address(es) of each database host to the VNCR configuration.

The GSMCATUSER password should be updated regularly for security reasons. Use the following command to perform this operation.

modify catalog -oldpwd oldpassword -newpwd newpassword

This command fetches the encrypted private key and encryption string, decrypts them using the old password, re-encrypts them with the new password and stores them again.

If the GSMCATUSER password is changed, you must execute MODIFY CATALOG to update catalog security scheme, with -newpwd and -oldpwd specified.

The PKI keys must be updated regularly, which is done using modify catalog -oldpwd oldpassword -newkeys. This command generates a new PKI key pair and replaces the corresponding fields in the database.

If you decide to replace the PKI keys, or just after the patchset upgrade from Oracle Database 12c Release 1 (12.1) on the catalog database, run this command:

modify catalog -pwd **  -newkeys

An arbitrary password can be stipulated for remote agent registration. If an agent registration password already exists, it will be overridden with the new password. In order to successfully execute the GDSCTL CREATE SHARD command, an agent password must be set using the CREATE SHARDCATALOG or MODIFY CATALOG command.

Examples

Turn off autovncr mode for the catalog database.

connect gsmadmin@mycloud 
GDSCTL> modify catalog -autovcnr off

Specify the remote Scheduler agent registration password.

connect gsmadmin@mycloud 
GDSCTL> modify catalog –agent_password mypass

Update catalog security scheme.

GDSCTL> modify catalog -autovncr OFF -oldpwd opwd -newpwd npwd -pwd pwd -newkeys