Problem solve Get help with specific problems with your technologies, process and projects.

Configuring an RMAN backup

I am in the process of configuring an RMAN backup. I created a recovery catalog. I get the ORA-01031 error while trying to connect to the target database.

I am in the process of configuring an RMAN backup. I created a recovery catalog. I get the following error while trying to connect to the target database as shown:
RMAN> connect target sys/xxxxx@oratest;

Error message is ORA-01031.

You are getting this error message because the account that you are trying to connect to does not have sufficient privileges. What you may not realize is that when RMAN connects to the target database, it connects as SYSDBA whether you indicate it or not. So right now, you are probably saying that there still shouldn't be a problem because SYS and sign on as SYSDBA. But your CONNECT command includes "@oratest". This means that you are not connecting locally. Even if the target database is on the same server, it is not considered a local connection this way. Since it is not a local connection, you must have configured your database to allow SYSDBA connections remotely. This is done by creating a password file with the ORAPWD utility. Then set REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE in your parameter file and bounce the database. You should now be able to connect SYS AS SYSDBA remotely and the above will not receive the ORA-1031 error message.
This was last published in March 2004

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.