General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 10gR2 backup getting rman error

Norman Dignard
Regular Advisor

Oracle 10gR2 backup getting rman error

Trying to configure a backup job with OEM. Whe I try to modify the Backup setting in OEM (logged in as sys / as sysdba) I get the following:
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12546: TNS:permission denied

RMAN>
echo set on


RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 04/18/2008 14:54:42
RMAN-06171: not connected to target database

How do I resolve this?
5 REPLIES
Yogeeraj_1
Honored Contributor

Re: Oracle 10gR2 backup getting rman error

hi,

Questions:
1. has it been working previously?

2. have you already configured the RMAN settings using the OEM?
(in the "Backup/Recovery Settings" section)


revert!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: Oracle 10gR2 backup getting rman error

hi again Norman,

can you also run the rman command manually at the OS level and see if you are getting the same error?


revert!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Kapil Jha
Honored Contributor

Re: Oracle 10gR2 backup getting rman error

from the error what i can suppose is check configuration of tnsname.ora and listner.ora.
Check the connectivity of where you taking backup to the server.
It seems to be connection issue.
BR,
Kapil
I am in this small bowl, I wane see the real world......
Norman Dignard
Regular Advisor

Re: Oracle 10gR2 backup getting rman error

We have Oracle 10gR2 setup on a Windows box (our prod server) and a test db server on HPUX. I do not recall having this issue on the Windows box in using OEM to schedule a backup and all appears to be working fine there. TNSnames etc are setup fine.

I have never used RMAN directly as I'm relatively new to this. I guess I'll need to do some reading...
Norman Dignard
Regular Advisor

Re: Oracle 10gR2 backup getting rman error

There were 2 problems
1) I did not have a sqlnet.ora file
2) the host credentials I used in OEM was root. Changed it to oracle and it's now working. Ref Oracle metalink Doc ID:453942.1