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
- From the navigation pane, go to Protect > Databases.
The Instances page appears.
- 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.
- 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.
- In the Oracle SID box, type the Oracle database instance name for which backups and restores are to be run.
- In the Plan box, select the desired Plan.
- In the Oracle home box, type the Oracle application installation path or use Browse to browse to the location and select it.
- 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:
- In the first box, enter the database user name.
- In the second box, enter the database user password.
- 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:
- In the first box, enter the catalog user name.
- In the second box, enter the catalog user password.
- In the third box, enter the catalog service name.
- To use the Oracle connect string, in the Connect String boxes enter the following data:
- If you are modifying an existing instance, you can modify optional Advanced settings:
- Optional: To modify the operating system user name, in the OS user name box, type the user name.
- Optional, for Windows systems: To modify the operating system user password, in the OS user password box, type the user password.
- 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.
- 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:
- On the Oracle database host, edit the oratab file and add an entry for the added instance.
- Create subclients for the data that you want to protect.
- You can configure replication for that instance. Right-click the instance, and select Configure replication.
For more information, see Configuring Live Sync Replication
Last modified: 2/12/2021 11:31:51 PM