1

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!!

PhilTM
32k10 gold badges86 silver badges108 bronze badges
asked May 14, 2015 at 3:51
0

3 Answers 3

2

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 !!

Paul White ♦
95.3k30 gold badges439 silver badges689 bronze badges
answered Aug 12, 2017 at 22:06
1
  • It's really strange, but when I create the user and password by using all caps, it works fine. But if I use lower case letters, I get the exact same issue Commented Jul 21, 2020 at 8:17
2

In the tnsnames.ora file, I added an entry for PDBORCL in which the SERVICE_NAME=pdborcl. Just changed it to uppercase like SERVICE_NAME=PDBORCL and the problem was solved.

0

You can also connect directly with below syntax:

sqlplus TEST/test@localhost:1521/pdborcl

pdborcl is pluggable database name

answered Dec 31, 2016 at 11:50

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.