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 10 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 storage policy to use for log backups
  • The storage policy to use for command line backups

Procedure

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

    The Instances page appears.

  2. Determine the operation that you want to perform.
    • To create a instance, select Add database 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. In the Instance name box, type the instance name.
  4. In the Oracle home box, type the Oracle application installation path.
  5. In the OS user name box, type the credentials for a user that can access the Oracle client.
  6. 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, and then 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 the User catalog connect check box, and then 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.
  7. Click Save.

Result

The software creates the instance and a default data and a default log subclient.

What to Do Next

  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: 11/5/2018 10:08:29 PM