Oracle Cloud Infrastructure Documentation

Managing Oracle Homes Manually

This topic describes how to manage Oracle Homes using the dbaascli utility. Oracle Homes are also called Database Homes.

An Oracle Home is a directory location on the compute nodes that contains Oracle Database binaries. Exadata DB systems enable multiple database deployments to share a set of Oracle Database binaries in a shared Oracle Home directory location.

Viewing Information About Oracle Homes

You can view information about Oracle Home directory locations by using the dbhome info subcommand of the dbaascli utility as follows.

  1. Connect to a compute node as the opc user.

    For detailed instructions, see Connecting to an Exadata DB System.

  2. Start a root-user command shell:

    $ sudo -s
    #
  3. Execute the dbaascli command with the dbhome info subcommand:

    # dbaascli dbhome info
  4. When prompted, press Enter to view information about all Oracle Homes registered in your Exadata DB system, or specify an Oracle Home name to view information only about that Oracle Home.
  5. Exit the root-user command shell:

    # exit
    $

Moving a Database to Another Oracle Home

Moving a database to another Oracle Home enables you to consolidate existing Oracle Homes and manage the storage that they consume. You can move a database to another Oracle Home by using the database move subcommand of the dbaascli utility as follows.

  1. Connect to a compute node as the opc user.

    For detailed instructions, see Connecting to an Exadata DB System.

  2. Start a root-user command shell:

    $ sudo -s
    #
  3. Ensure that all database instances associated with the database deployment are up and running.

    # dbaascli database status --dbname <dbname>

    In the preceding command, <dbname> specifies the name of the database that you want to check.

    Restart any database instances that are not running and open.

  4. Execute the dbaascli command with the database move subcommand:

    # dbaascli database move --dbname <dbname> --ohome <oracle_home>

    In the preceding command:

    • <dbname> — specifies the name of the database that you want to move.
    • <oracle_home> — specifies the path to an existing Oracle Home directory location, which you want the specified database to use.

    When performing a move operation to an Oracle Home with a different patch level, if the database is part of an Exadata DB system Data Guard implementation, then ensure that you move the standby database to the new patchset before you move the primary database.

  5. Exit the root-user command shell:

    # exit
    $

Creating an Oracle Home

You can create an Oracle Home directory location and software installation, without creating a database, by using the dbhome create subcommand of the dbaascli utility as follows.

  1. Connect to a compute node as the opc user.

    For detailed instructions, see Connecting to an Exadata DB System.

  2. Start a root-user command shell:

    $ sudo -s
    #
  3. Run the dbaascli command with the dbhome create subcommand:

    # dbaascli dbhome create --version <software_version>

    In the preceding command, <software_version> specifies an Oracle Database software version. For example, 19000, 18000, 12201, 12102, or 11204. The latest available bundle patch for the specified software version is automatically used.

    To see information about Oracle Database software images that are available in your Exadata DB system, including software version and bundle patch details, use the dbaascli dbimage list command.

    When prompted, type yes to confirm that the installation is based on a local software image.

  4. Exit the root-user command shell:

    # exit
    $

Deleting an Oracle Home

If an Oracle Home directory does not support any databases, you can delete it by using the dbhome purge subcommand of the dbaascli utility as follows.

  1. Connect to a compute node as the opc user.

    For detailed instructions, see Connecting to an Exadata DB System.

  2. Start a root-user command shell:

    $ sudo -s
    #
  3. Execute the dbaascli command with the dbhome purge subcommand:

    # dbaascli dbhome purge
  4. When prompted, enter: 

    • 1 — if you want to specify the Oracle Home name for the location being purged.
    • 2 — if you want to specify the Oracle Home directory path for the location being purged.
  5. When next prompted, enter the Oracle Home name or directory path for the location being purged.

    If your entries are valid and the Oracle Home is not associated with a database, then the Oracle binaries are removed from the Oracle Home directory location and the associated metadata is removed from the system.

  6. Exit the root-user command shell:

    # exit
    $