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 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,036 views