Introducing CA ARCserve Backup Agents and Options › Using Agents › Agent for Oracle › Troubleshooting › BackUp and Restore Problems in the Agent for Oracle in RMAN Mode › Oracle Permission Error

Previous Topic: Backups of Remote Oracle Instances Fail in RMAN Mode

Next Topic: Restore the Oracle Data Files in a Different Directory
Oracle Permission Error

Symptom:

While trying to perform a restore operation with the Until End of Logs option enabled, I get Oracle permission errors. How can I prevent the errors?

Solution:

Ensure that the Oracle user name and password you use to connect to Oracle through the Restore Manager has the permission to connect to Oracle using the as sysdba clause.

You can verify your permissions by running the following commands:

sqlplus /nolog
connect username/password as sysdba

If you do not have permission, ask the Oracle DBA to configure the security for you.