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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Installing Example Schemas

DigsJun 5 2016 — edited Jun 7 2016

I have windows7(64)

I have installed the Oracle Developer Database for 12c (latest version) on my localhost PC

Trying to install the example schemas running this code in SQL*Plus
2.3 Invoke the Sample Schema creation script. Using the values listed
in Sections 2.1 and 2.2, the command would look like this:

SQL> @?/demo/schema/mksample <SYSTEM_password> <SYS_password>
<HR_password> <OE_password> <PM_password> <IX_password>
<SH_password> <BI_password> EXAMPLE TEMP
$ORACLE_HOME/demo/schema/log/

The mksample script lists all the objects created in the data dictionary.

I get this error for the HUMAN_RESOURCES (same for all) example schema.

******************************************************

de: [Select all] [Show/ hide]

DROP USER hr CASCADE

ERROR at line 1:

ORA-01918: user 'HR' does not exist

CREATE USER hr IDENTIFIED BY HR

ERROR at line 1:

ORA-65096: invalid common user or role name

ALTER USER hr DEFAULT TABLESPACE EXAMPLE_TEMP

ERROR at line 1:

ORA-01918: user 'HR' does not exist

ALTER USER hr TEMPORARY TABLESPACE $ORACLE_HOME/demo/schema/log/

ERROR at line 1:

ORA-00911: invalid character

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

Connected.

GRANT execute ON sys.dbms_stats TO hr

ERROR at line 1:

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

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

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

******************************************************

QUESTION: What do i do to make this work??

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2016

Added on Jun 5 2016

#general-database-discussions

4 comments

6,017 views

Oracle Database Discussions

Installing Example Schemas

Comments

Post Details