Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"sqlplus sys/<password>@SERVICENAME as sysdba" is not working

JesraOct 14 2020 — edited Oct 14 2020

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.

Comments
Post Details
Added on Oct 14 2020
4 comments
6,380 views