This discussion is archived
4 Replies Latest reply: Jan 27, 2013 6:19 PM by 987331 RSS

RMAN-04004: error from recovery catalog database: ORA-01017: invalid userna

987331 Newbie
Currently Being Moderated
Hi,

I have multiple production database connect to 1 catalog database. all my backup are scheduled in HPDP. suddenly the backup started to fail for 2 DB with below error.

The database reported error while performing requested operation.
SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.sl
CHILDERROR:1
Process exit code: 1, Signal: 0
RMAN PID=21394
APPERROR:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied
Recovery Manager complete.
APPERROR:
SELECT DBID FROM RC_DATABASE WHERE DBID=1300019938
sqlcode 1017
APPERROR:
ERROR:
ORA-01017: invalid username/password; logon denied

I tried to connect from my target db to the recovery database. I am getting the same error
RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied


I am able to do tnsping from the target database.
wux0077 /u03/backup/MARC300P $ tnsping rmandb

TNS Ping Utility for HPUX: Version 9.2.0.6.0 - Production on 27-JAN-2013 06:33:52

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/u01/app/oracle/local/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = XXXXX)
OK (0 msec)

when i am using the same password from other targets i am able to connect.

I checked in the rman repository and able to find the DB i am trying to take back up of

SQL> conn rman/xxxxxx
Connected.
SQL> SELECT DBID FROM RC_DATABASE WHERE DBID=1300019938;

DBID
----------
1300019938


Can someone help me.. even on my OEM grid its failing with below error. However its connecting to the controlfile and taking the backup.

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points