I install oracle 12c but HR Schema is not available. and no HR user is available.
i take following step
connect with sys as sysdba
then write the following query
select name, cdb, con_id from v$database;
and then
select name, pdb from v$services order by pdb, name;
he
and the name of pdb is 'pdborcl'
then
alter pluggable database pdborcl open;
then
alter session set container=pdborcl;
and then
ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;
after that i open the TNSNAMES.ORA file, and add following code and save file
PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Izzy)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
)
)
then again try to connect with hr schema but its still not connected..
Please help me in this regards.
Thanks.
Bilal