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".
when I use conn test/test@PDBORCL
, I got "Could not resolve the connect identifier specified"
Can anyone please help me out? I really appreciate!!
Oracle 12c database cannot log in as a local user
oracleoracle-12c
Related Question
- Oracle 12c create user
- Windows – Oracle 12c SYSTEM user locked out
- “ORA-01017: invalid username/password” while connecting to an instance remotely as sysdba
- How to configure sql developer with oracle 12c
- ORA-01017 error when conecting to Oracle Database Standard Edition 2.12.2.0.1.0 for Microsoft Windows x64 (64-bit)
- ORA-01017 when connecting remotely as sysdba
Best Answer
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 !!