D The dbaascli Utility

The dbaascli utility is provided on Oracle Database Cloud Service deployments to perform a variety of life-cycle and administration operations.

Using the dbaascli utility, you can perform operations like:

  • Changing the password of the SYS user

  • Checking the status of the Oracle Data Guard configuration

  • Switchover and failover in an Oracle Data Guard configuration

  • Patching the database deployment

  • Database recovery

  • Rotating the master encryption key

To use the dbaascli utility:

  1. Connect to a compute node associated with the Database Cloud Service deployment. For most dbaascli subcommands, connect as the oracle user. For the dbpatchm and orec subcommands, connect as the opc user.

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

  2. If you connected as the opc user, start a root-user command shell:

    $ sudo -s
    #
  3. Run the dbaascli utility using a command of the form:

    # dbaascli subcommand subcommand-options
  4. When you are finished using the dbaascli utility, exit the root-user command shell if necessary and disconnect from the compute node:

    # exit
    $ exit

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.

tde

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

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