Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Installing HR Schema in Oracle Database 12c

1062378Dec 30 2013 — edited Jan 1 2014

Hi, for the life of me I cannot get the HR Schema installed.

Using Linux OEL6 and Oracle Database 12.1c

Using the wizard, and advanced configuration, I selected to include Sample Schemas. Everything installed OK. However, no schemas were installed.

I then downloaded the examples file, unzipped, installed. All went okay.

Tried to follow: http://docs.oracle.com/cd/E16655_01/server.121/e15979/installation.htm

as well as: https://community.oracle.com/message/11234394#11234394

But to no avail. I still get the same error:

SQL> @?/demo/schema/human_resources/hr_main.sql

specify password for HR as parameter 1:

Enter value for 1: *********

specify default tablespeace for HR as parameter 2:

Enter value for 2: users

specify temporary tablespace for HR as parameter 3:

Enter value for 3: temp

specify password for SYS as parameter 4:

Enter value for 4: *********

specify log path as parameter 5:

Enter value for 5: @?/demo/schema/human_resources/hr_main.sql

SP2-0606: Cannot create SPOOL file "tvtsdb/u01/app/oracle/product/12.0.1/db_1/demo/schema/human_resources/hr_main.sqlhr_main.log"

DROP USER hr CASCADE

ERROR at line 1:

ORA-01918: user 'HR' does not exist

CREATE USER hr IDENTIFIED BY **********

ERROR at line 1:

ORA-65096: invalid common user or role name

ALTER USER hr DEFAULT TABLESPACE users

ERROR at line 1:

ORA-01918: user 'HR' does not exist

ALTER USER hr TEMPORARY TABLESPACE temp

ERROR at line 1:

ORA-01918: user 'HR' does not exist

GRANT CREATE SESSION, CREATE VIEW, ALTER SESSION, CREATE SEQUENCE TO hr

ERROR at line 1:

ORA-01917: user or role 'HR' does not exist

GRANT CREATE SYNONYM, CREATE DATABASE LINK, RESOURCE , UNLIMITED TABLESPACE TO hr

ERROR at line 1:

ORA-01917: user or role 'HR' does not exist

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.

SP2-0640: Not connected

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

SP2-0640: Not connected

****** Creating REGIONS table ....

SP2-0640: Not connected

****** Creating COUNTRIES table ....

SP2-0640: Not connected

****** Creating LOCATIONS table ....

SP2-0640: Not connected

****** Creating DEPARTMENTS table ....

SP2-0640: Not connected

****** Creating JOBS table ....

SP2-0640: Not connected

****** Creating EMPLOYEES table ....

SP2-0640: Not connected

****** Creating JOB_HISTORY table ....

SP2-0640: Not connected

****** Creating EMP_DETAILS_VIEW view ...

SP2-0640: Not connected

****** Populating REGIONS table ....

SP2-0640: Not connected

****** Populating COUNTIRES table ....

SP2-0640: Not connected

****** Populating LOCATIONS table ....

SP2-0640: Not connected

****** Populating DEPARTMENTS table ....

SP2-0640: Not connected

****** Populating JOBS table ....

SP2-0640: Not connected

****** Populating EMPLOYEES table ....

SP2-0640: Not connected

****** Populating JOB_HISTORY table ....

SP2-0640: Not connected

SP2-0641: "EXECUTE" requires connection to server

not spooling currently

Can someone please point me in the right direction?

This post has been answered by 1062378 on Jan 1 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 29 2014

Added on Dec 30 2013

#general-database-discussions

6 comments

16,408 views