Hello team,
I am not able connect default username i.e scott and hr from SQLPLUS in Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64bit
It is showing below errors
SQL> conn scott/tiger@pdborcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
SQL> conn hr/hr@pdborcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
But able to connect from Oracle Sql developer below is the configuration for scott and hr in sql developer
and tnsname.ora and listener.ora configuration is already available for pdborcl below is the configuration details
TNSNAME.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
)
)
LISTENER.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
Please check my configuration whether i have configured wrong and advice on issue.
Thanks and regards,
Hemanth.