RMAN nocatalog, insufficient privileges
EmApr 13 2007 — edited Apr 13 2007WARNING: 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