topic Re: Oracle 10gR2 backup getting rman error in Operating System - HP-UX

Oracle 10gR2 backup getting rman error

Norman Dignard — Fri, 18 Apr 2008 18:04:58 GMT

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?

Re: Oracle 10gR2 backup getting rman error

Yogeeraj_1 — Sat, 19 Apr 2008 05:07:34 GMT

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

Re: Oracle 10gR2 backup getting rman error

Yogeeraj_1 — Sat, 19 Apr 2008 05:36:02 GMT

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

Re: Oracle 10gR2 backup getting rman error

Kapil Jha — Sat, 19 Apr 2008 05:53:34 GMT

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

Re: Oracle 10gR2 backup getting rman error

Norman Dignard — Mon, 21 Apr 2008 14:43:27 GMT

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...

Re: Oracle 10gR2 backup getting rman error

Norman Dignard — Mon, 21 Apr 2008 15:34:39 GMT

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