Insufficient privilges

[dklloyd]

I'm trying to register our CMAL database in rman. I'm therefore using the command:
'rman target CMAL catalog rman/passwd@RMAN'
The system responds by asking for the target password, so I enter the CMAL 'system' password. The response then is:

target database Password:
target database Password:
RMAN-00571: =============================
RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: ORA-01005: null password given; logon denied

If I use the system user & password:
rman target system/passwd@CMAL catalog rman/passwd@RMAN
I get the following error:

Recovery Manager: Release 8.1.6.0.0 - Production

RMAN-00571: =====
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: ORA-01031: insufficient privileges

Do I need a database link or is the fault something simpler?

Look forward to hearing from you.

 

[karluk]

I think the syntax of your second connect attempt is correct. However, based on a quick check of the documentation, it looks as if the id used to connect to the target must have sysdba privileges. The "system" id isn't by default sysdba, so I would guess that's what the error message is about. Try connecting as internal, or grant sysdba to system.

 

[teser]

karluck,

You have consistently anwered many posts and helped me out in many areas.
I just wanted to say thanks again for another tip.

 

[dklloyd]

Thanks Karluk I seem to be getting somewhere now. Trying to grant sysdba to a user however gives me the error 'ORA-01994 GRANT failed: cannot add users to public password file.
I've look at documentation on this error which suggests that the remote_login_passwordfile be set to PRIVATE from PUBLIC. Looking at our init.ora file this parameter is #'d out but the remote_os_authent is set to true.
By changing the 1st parameter as suggested, what impact will this have on accessing the system?
Cheers

dklloyd