cksum values for primary & on DR is not matching
Error:cksum values for primary (4119705441) & on DR (3035667210) is not matching.
Cksum values for password files between primary & DR site were varying for some databases on the 4node RAC in the exadata.
Errors in primary logfile for below DB’s.
Cksum values for password files between primary & DR site were varying for some databases on the 4node RAC in the exadata.
main error for those threads on primary db
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is ‘ORA-01017: invalid username/password; logon denied.
————————————————-
cksum values for primary (4119705441) & on DR (3035667210) is not matching :
—————————————————————————–
ASMCMD [+] > cp ‘+DATAC1/OPRDB1/PASSWORD/pwdoprdb1.1027.889892159’ ‘/tmp/pwdoprdb1.1027.889892159’
copying +DATAC1/OPRDB1/PASSWORD/pwdpprdb1.1027.889892159 -> /tmp/pwdoprdb1.1027.889892159
ASMCMD [+] >
Verification:
[oracle@ORPRD_SRVR05 ~]$ cksum /tmp/pwdoprdb1.1027.889892159
4119705441 7680 /tmp/pwdoprdb1.1027.889892159
ORPRD_SRVR07:-DR >cksum orapwoprdb1DG3
3035667210 7680 orapwoprdb1DG3
Action taken:
Action taken : Copied the primary password files to DR site on all nodes & restarted standby databases.
Now the archives are shipping & recovery in progress.
Below is how to verify the cksum values:
Commands to verify checksum(cksum) on nodes 5 and 6 from the node7:
Sample output looks like below.
ORPRD_SRVR07:-DR >pwd
/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs
ORPRD_SRVR07:-DR >ssh ORPRD_SRVR06 ‘cksum /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/orapwOPRDB1DG2’
3035667210 7680 /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/orapwOPRDB1DG2
ORPRD_SRVR07:-DR >ssh ORPRD_SRVR05 ‘cksum /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/orapwOPRDB1DG1’
3035667210 7680 /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/orapwOPRDB1DG1
Summary:
After copying password files from primary to DR site , Checksum(cksum) value is matching.
See Also: