Shulou(Shulou.com)06/01 Report--

Environment master library rac 11.2 backup library stand-alone 11.2:

Phenomenon: one of the log node files in the two nodes of the master database can be transferred to the slave database, and the other node reports an error in the password file:

2019-03-22 10 purl 25 purl 30.445000 + 08:00

Error 1017 received logging on to the standby

Check that the primary and standby are using a password file

And remote_login_passwordfile is set to SHARED or EXCLUSIVE

And that the SYS password is same in the password files.

Returning error ORA-16191

PING [ARC2]: Heartbeat failed to connect to standby 'app'. Error is 16191.

2019-03-22 10 Suzhou 2515 32.519000 + 08:00

Check to see if the main library password is case sensitive:

SQL > show parameter sec_case_sensitive_logon

NAME TYPE VALUE

-

Sec_case_sensitive_logon boolean TRUE

So manually rebuild the password file, and note that ignorecase=y is case-sensitive when ignoring password authentication:

Orapwd file=orapsid password=password#123 entries=10 force=y ignorecase=y

After reconstruction, the synchronization is normal, and the password file error disappears. If you do not specify ignorecase=y, you will still report the same error.

Oracle 11g by default, password files are case-sensitive if you do not specify ignorecase, and if you specify ignorecase=y, Oracle ignores the case of the password during password authentication.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.