Oracle 12c database cannot log in as a local user

oracleoracle-12c

I met a problem from Oracle 12C Database, when I try to login to the user account with commandconn test/test, I got prompt of "invalid username/password, logon denied". invalid nsername/password
when I use conn test/test@PDBORCL, I got "Could not resolve the connect identifier specified"Could not resolve identifier
Can anyone please help me out? I really appreciate!!

Best Answer

Strangely, changing my service name to UPPERCASE has helped!

  1. Changed case of service name to UPPERCASE in tnsnames.ora for pluggable database ("ORCLPDB" in my case).

  2. Follow below commands:

    enter image description here

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

    Not sure why this has worked for me !!