Loading...

Managing Oracle Database Instances

Add or modify an Oracle instance when you need to manage a database.

Tip: If you have access to more than ten server groups, use the arrow buttons at the lower-left bottom of the page to page through the server groups.

Before You Begin

Make sure that you have the following information:

  • The Oracle application installation path
  • The credentials that you use to access the Oracle client
  • The Plan to be used for data and log backups

Procedure

  1. From the navigation page, click Solutions > Databases > DB Instances.

    The Instances page appears.

  2. Determine the operation that you want to perform.
    • To create an instance, select Add instance, and then select Oracle.
    • To edit an instance, click the instance, and then under General click Edit.

    The New oracle instance dialog box or the Modify instance details dialog box appears.

  3. For a new Oracle instance, in the Server name box, select the server for this instance.

    Tip: Use the Search box to quickly navigate to the desired server.

  4. In the Oracle SID box, type the Oracle database instance name for which backups and restores are to be run.
  5. In the Plan box, select the desired Plan.
  6. In the Oracle home box, type the Oracle application installation path or use Browse to browse to the location and select it.
  7. Determine how you want to connect to Oracle.

    Note: If you want to use an account other than 'sys', you must grant the SYSDBA or SYSBACKUP (in Oracle version 12 or higher) privilege to the user account.

    • To use the Oracle connect string, in the Connect String boxes enter the following data:
      1. In the first box, enter the database user name.
      2. In the second box, enter the database user password.
      3. In the third box, enter the Oracle service name.
    • To use the Oracle catalog connect string, select Use catalog connect to activate the option, then enter the following data:
      1. In the first box, enter the catalog user name.
      2. In the second box, enter the catalog user password.
      3. In the third box, enter the catalog service name.
  8. If you are modifying an existing instance, you can modify optional Advanced settings:
    1. Optional: To modify the operating system user name, in the OS user name box, type the user name.
    2. Optional, for Windows systems: To modify the operating system user password, in the OS user password box, type the user password.
    3. Optional: By default, the TNS_Admin directory is created in the Oracle HOME\network\admin path. To modify the path, in the TNS_ADMIN folder box, enter the full path to the location of the tnsnames.ora file, or use Browse to browse to the location and select it.
  9. Click Add if adding a new instance or Save if modifying an existing instance.

Result

The software creates the instance and a default data and a default log subclient, or modifies the existing instance.

What to Do Next

If you added a new instance:

  1. On the Oracle database host, edit the oratab file and add an entry for the added instance.
  2. Create subclients for the data that you want to protect.

Last modified: 4/12/2019 8:13:30 PM