Oracle 12c database cannot log in as a local user
Strangely, changing my service name to UPPERCASE has helped!


Changed case of service name to UPPERCASE in tnsnames.ora for pluggable database ("ORCLPDB" in my case).
Follow below commands:



Note: service name in uppercase while connecting ex SCOTT/TIGER@ORCLPDB

Not sure why this has worked for me !!