4 Replies Latest reply: Jan 27, 2013 8:19 PM by 987331 RSS

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

    987331
      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