D The dbaascli Utility

You can use the dbaascli utility to perform a variety of life-cycle and administration operations on Oracle Database Cloud Service database deployments.

Using the dbaascli utility, you can:

  • Change the password of a database user.

  • Start and stop a database.

  • Start and stop the Oracle Net listener

  • Check the status of the Oracle Data Guard configuration.

  • Perform switchover and failover in an Oracle Data Guard configuration.

  • Patch the database deployment.

  • Perform database recovery.

  • Rotate the master encryption key.

To use the dbaascli utility:

  1. Connect to a compute node associated with the Database Cloud Service deployment.

    Commands using the patch, dbpatchm or orec subcommands must be run with root administrator privileges. In this case, first connect as the opc user and then start a root-user command shell by executing the sudo —s command.

    Otherwise, connect as the oracle user.

    For instructions, see Connecting to a Compute Node Through Secure Shell (SSH).

  2. Run the dbaascli utility using a command of the form:

    # dbaascli subcommand subcommand-options

The dbaascli utility supports these subcommands:

Subcommand Subcommand Options

database

bounce – shuts down and then restarts the database instance.

changepassword – changes the password of the specified user.

start– starts the database instance and opens the database.

status – displays the open mode of the database and additional information about the database deployment.

stop – shuts down the database instance.

dataguard

failover – performs a manual failover.

reinstate – reinstates a failed primary database.

status – checks the status of the configuration.

switchover – performs a switchover operation.

dbpatchm

apply – applies the patch.

clonedb – applies a patch to a test deployment.

list_patches – displays a list of available patches.

list_tools – checks whether any cloud tooling updates are available.

prereq – checks the prerequisites of a patch.

rollback – rolls back the last deployment patch.

switchback – restores database software to a prior state.

toolsinst – downloads and applies the patch containing the cloud tooling update.

dv

off – disables Oracle Database Vault.

on– enables Oracle Database Vault.

gg

setup – configures the database as a valid replication database.

status – indicates whether the database has been configured as a valid replication database.

listener

bounce – stops and restarts the listener.

start – starts the listener.

status – displays the status of the listener, including a summary of listener configuration settings, listening protocol addresses, and a summary of services registered with the listener.

stop – stops the listener.

netsec

config – configures network encryption and network integrity.

config encryption– configures network encryption.

config integrity – configures network integrity.

status – displays network encryption and network integrity configuration information.

orec

duplicate – updates the standby database in a Data Guard configuration.

keep list – lists the available long-term backups.

keep tag – restores a specific long-term backup and performs recovery.

latest – restores the most recent backup and performs complete recovery.

list – lists the available normal backups.

pitr – restores a specific normal backup and performs recovery.

scn – restores the most recent backup and performs recovery through the specified SCN.

patch

db apply – applies the database patch.

db cleanup – removes temporary files created during database patching operations.

db list – displays a list of available database patches.

db prereq – checks whether any database updates are available.

db switchback – rolls back the last database patch.

os apply – applies the OS patch.

os list – displays a list of available OS patches.

tools apply – downloads and applies the patch containing the cloud tooling update.

tools auto disable – disables automatic cloud tooling updates.

tools auto enable – enables automatic cloud tooling updates.

tools auto execute – downloads and applies the patch containing the latest cloud tooling update.

tools auto status – checks whether automatic cloud tooling updates are enabled or disabled.

tools list – checks whether any cloud tooling updates are available.

tde

rotate masterkey – changes (rotates) the master encryption key.

status – displays information about the software keystore, including the type and status.