Welcome to Dell Technologies PowerProtect Data Manager 19.x How to Series.
How to do Oracle Backups using Wallet Authentication.
Reference Dell Knowledge Article number 196828.
This video shows:
How to perform Oracle backups using wallet authentication.
This video presents the general steps that will be accomplished.
1) Log in to the Oracle box.
2) Connect to Oracle and verify that wallet authentication works okay.
3) Create a protection policy.
4) Run a test backup.
This process should be followed
when there is a need to do Oracle backups using wallet authentication.
Before you begin,
have admin credentials for PowerProtect Data Manager User Interface.
Have root credentials for the Oracle box.
Have IP and Fully Qualified Domain Name for the Oracle box
and PowerProtect Data Manager.
And have Oracle service name and TNS_ADMIN directory location.
Log in to the Oracle box.
Switch to Oracle.
Set the variables needed to connect to Oracle using SQL*Plus.
Run "sqlplus".
Connect to the Oracle database using wallet authentication
to verify that it works okay.
If the connection fails, please troubleshoot the failure
before moving forward with this video.
Exit "sqlplus".
Change to the RMAN plugin config directory:
"vi rman_agent.cfg".
Create an entry for the database specifying variables
"ORACLE_SERVICE" and "TNS_ADMIN".
Save the file.
Switch back to root by exiting Oracle.
Restart PowerProtect Data Manager agent.
Go to PowerProtect Data Manager User Interface.
Go to "Protection" and click "Protection Policies".
Click "Add" to start creating a new Protection Policy.
Click "Set Credentials".
Click on "Wallet" and set "Net Service Name" and "TNS File Location".
Click on "Save" and continue creating the policy.
Select the Oracle database being set up.
Add the "Primary Backup" details needed for this Protection Policy
and complete the creation of this Protection Policy.
Select the newly created Protection Policy and run a test backup
by clicking the "Protect Now" button.
Click on "View Details"
and monitor the backup until it completes successfully.
It should be possible to set up Oracle backups using wallet authentication
after completing this video.
Reference the following for more information: KB 196828.
Thank you for watching.