Hi Experts,
I've installed Oracle 12C on my PC ( Windows7). And I've named CDB as ORCL and PDB as PDBORCL.
I'm able to connect CDB but getting an error while connecting to user HR which is exist in PDB.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name from v$database;
NAME
---------
ORCL
SQL> select name from v$pdbs;
NAME
------------------------------
PDB$SEED
PDBORCL
I've updated the tnsnames.ora file with PDBORCL, still I'm getting below error.
Enter user-name: hr/hr@pdborcl;
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Please help me in resolving the issue ?
Cheers,
Suri ;-)