Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN nocatalog, insufficient privileges

EmApr 13 2007 — edited Apr 13 2007
WARNING: I am an oracle/db newbie.

I have two databases that were set up by our HRIS vendor, and the RMAN routines were also set up for us.

I am moving one of those databases to a new server. I created the new database just fine; however, when I try to recreate the RMAN backup, I'm running into problems.

I thought I duplicated the setup but, when the RMAN connection is attempted, I'm now getting "insufficient privileges."

In the batch file that starts RMAN, the command line is:
rman target / nocatalog log P2KLIVE-rman.log @backup_P2KLIVE.rman

The backup_P2KLIVE.rman file contains no userid or password or database name, so I'm not sure how the batch is connecting, on the database where this is working, but I cannot get it to work on this new server/database.

I'm wondering if I have control or password file issues (their location, maybe?), but I don't know enough about what's in those files or what they do to be sure.

Can anyone offer either any advice, or resources for the uninformed to quickly get RMAN backing up their database?

Thanks
MK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2007
Added on Apr 13 2007
3 comments
3,251 views