I have installed oracle 12c in my ubuntu can successfully connect to my
hr user with
sqlplus hr/hr@pdborcl through command prompt.
oracle@ubuntu:~$ sqlplus hr/hr@pdborcl SQL*Plus: Release 18.104.22.168.0 Production on Mon Nov 16 21:57:24 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Last Successful login time: Mon Nov 16 2015 21:24:32 +05:45 Connected to: Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL>show user; USER is "HR"
I am however trying to use sqldeveloper for ease. In the create connection option in sqldeveloper when I give the following credentials
However connection with
And same all other credentials work fine.
My tnsname.ora has
PDBORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )