(DP) Support Tip: ORA-01017: invalid username/password; logon denied

If you are trying to integrate Oracle into Data Protector and getting this message :

       ORA-01017: invalid username/password; logon denied

try running rman manually with a script that does a simple connection and uses Oracle's DISK subsystem to remove Data Protector from the command :

        CONNECT TARGET rman/<password>@DEF
        CONNECT CATALOG rman/<password>@rmancat
        RUN {
                  ALLOCATE CHANNEL 'DP_TEST' TYPE DISK;
        }
        EXIT

As is turns out, the Oracle target instance above was in a clustered enivornment and the solution was to run the following sqlplus command as the DBA administrator on each node of the cluster.  By running this on each node, the password file was now sync'd up.

       alter user rman identified by <password>;

Tags: