Help...insufficient privileges error...

[Chewie71]

Greetings,

I'm trying to setup a second db server using RMAN DUPLICATE. I've gotten the connection working, but it seems my sysdba user on the auxiliary box doesn't have the right privileges to it's own database? I've created the password file in $ORACLE_HOME/dbs so that shouldn't be the problem.

$ rman target sys/syspass@dbname

...gets this result...

RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

Going into SQLPlus...
$ sqlplus /nolog
SQL> connect sys/syspass@dbname as sysdba

gets this result...

ERROR:
ORA-01031: insufficient privileges


Any help is appreciated...

Thanks,
Matt

 

[Chewie71]

I think I figured it out. I guess an empty database has to be in place first so you can assign a PW to SYSDBA? I created one with dbca then went through the duplicate steps and it seems to be fine now.

Nowhere in the RMAN duplicate stuff I was looking at did it say the db had to be pre-created. I figured going through all the steps and precreating the directories, pfile/spfile, and orapw file was it, and RMAN would take care of the rest.

Guess not...

Thanks,
Matt