Step 4. Specify Target Oracle Server
At this step of the wizard, specify connection settings required to access the target Oracle server. The set of connection settings depends on the OS type of the target server: Windows or Linux.
Windows-Based Oracle Server
For a Windows-based Oracle server, do the following:
- In the Server name field, specify the name of the target Oracle server.
- In the Specify user account to connect section, enter credentials to connect to the target Oracle server.
Consider the following:
- The user account must be a member of the local Administrators group and have sysdba privileges.
- The user account must be granted appropriate permissions to access Oracle databases; Read and Write are minimum required, Full Control is recommended.
- To copy archived logs to the specified server, the user account must be granted sufficient permissions to access the administrative share.
Linux-Based Oracle Server
For a Linux-based Oracle server, do the following:
- In the Server drop-down list, specify a target Oracle server. You can select an Oracle server from the list or enter a DNS name of the target Oracle server.
- In the SSH port field, specify the port number of the selected Oracle server.
- In the Account filed, specify an account under which to connect to the specified server.
- In the Password field, enter the password.
- If you have specified a non-root account that does not have root permissions on the target server, click Advanced to grant sudo rights to this account.
- To provide a non-root user with root account privileges, select the Elevate specified account to root check box.
- To add the user account to the sudoers file, select the Add account to the sudoers file automatically check box. In the Root password field, enter the password for the root account.
If you do not enable this option, you will have to manually add the user account to the sudoers file.
- If the sudo command is not available or may fail on the target Linux server, you have an option to use the su command instead. To enable the su command, select the Use su if sudo is unavailable check box and enter the password for the root account in the Root password field.
- If a private key is required to connect to the selected server, do the following:
- Select the Private key is required for this connection check box.
- In the Private key filed, specify a key.
To select a key, click Browse and select a key.
- In the Passphrase field, enter the passphrase.
Consider that the user account must be a member of the dba group.