Home » RDBMS Server » Server Administration » How to add HR Schema (Oracle 12c, window 7)
How to add HR Schema [message #643384] Tue, 06 October 2015 09:42 Go to previous message
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
Senior Member
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
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: I've been getting the error In the alert log since the database was built using an rman clone.
Next Topic: Inventory load failed... OPatch cannot load inventory for the given Oracle Home
Goto Forum:
  


Current Time: Wed Apr 24 14:36:10 CDT 2024