Hi,
DB Version: 12.2.0.1.0, Clusterware 18.0.0.0.0.
Two Node RAC, Standby also 2 Node RAC & Active Data Guard is configured.
From Both Primary & Standby,
"sqlplus sys/<password>@SERVICENAME as sysdba" is not working (ORA-01017: invalid username/password; logon denied) But "sqlplus sys/<password> as sysdba" is working fine.
I've created DBSNMP user for OEM with SYSDBA privilege. "sqlplus DBSNMP/<password>@SERVICENAME as sysdba" is working fine.
Password file are located in ASM and there is no recent changes on Password file in both ORACLE_HOME & ASM.
Kindly help in understanding & resolving this issue.