Home » SQL & PL/SQL » Client Tools » Installing example Schemas v2...Help (Oracle 12c)
Installing example Schemas v2...Help [message #652269] Sun, 05 June 2016 22:35 Go to next message
icm63
Messages: 22
Registered: December 2007
Junior Member
Oracle 12c
DEV Database

Intention to install the sample schemas for study. HR, OE, PM, IX, SH


I have installed a Container DB : defualt name : orcl

I have installed a Pluggable Database called PDBORCL

I have intalled a pluggable dataBASE called SAMPLEDB to hold all the sample schemas.

I installed them following this video: https://www.youtube.com/watch?v=iVo6Xnzeteg

I have unlocked all users HR, OE, etc

However I cant log on via SQL DEVELOPER to hr/hr to see any hr schema or data

I cant see under other users : HR or OE or any of them.

See image or file attached: http://www.screencast.com/t/7x5d9eYbKK

What have I missed??
./fa/13158/0/


[mod-edit: image inserted into message body by bb]

  • Attachment: SH_0001.png
    (Size: 32.49KB, Downloaded 244 times)

[Updated on: Mon, 06 June 2016 01:30] by Moderator

Report message to a moderator

Re: Installing example Schemas v2...Help [message #652270 is a reply to message #652269] Sun, 05 June 2016 22:39 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

post SQL & results that HR or OE actually exist in your database.

They won't exist if they have not been loaded.
Re: Installing example Schemas v2...Help [message #652272 is a reply to message #652269] Sun, 05 June 2016 23:05 Go to previous messageGo to next message
icm63
Messages: 22
Registered: December 2007
Junior Member
here is another image showing SH, IX open etc
./fa/13159/0/


[mod-edit: imaged inserted into message body by bb]
  • Attachment: SH_0002.png
    (Size: 8.37KB, Downloaded 230 times)

[Updated on: Mon, 06 June 2016 01:31] by Moderator

Report message to a moderator

Re: Installing example Schemas v2...Help [message #652275 is a reply to message #652272] Mon, 06 June 2016 00:21 Go to previous messageGo to next message
icm63
Messages: 22
Registered: December 2007
Junior Member
THE READ ME FILE of the WINDOWS sample scripts says this, scroll down to 4.1

README.txt

Created 25-NOV-2003

Updated 25-FEB-2013

------------------------------------------------------------------------


This document describes the structure of the Schema directory, and

provides instructions for creating the Sample Schemas.

========================================================================

1. Structure of the Schemas directory

1.1 The Schema directory contains the following files:

1.1.1 mksample.sql
This script erases and recreates all Sample Schemas.
CAUTION: This script contains directory paths that may
work only for one specific installation.

1.1.2 README.txt
This file explains the process of creating Sample Schemas.

1.2 The following folders contain scripts to DROP and CREATE database
objects, and for loading data. These scripts are called by
the mksample.sql script.

1.2.1 human_resources

1.2.1.1 The hr_main.sql script creates or recreates the HR schema.

1.2.1.2 The hr_drop.sql script drops all objects of the schema, but
does not remove the HR user.

1.2.2 order_entry

1.2.2.1 The oe_main.sql script creates or recreates the OE schema.

1.2.2.2 The oe_drop.sql script drops all relational objects, but
does not remove the OE user.

1.2.3 product_media

1.2.3.1 The pm_main.sql script creates or recreates the PM schema.

1.2.3.2 The pm_drop.sql script drops all objects, but does not
remove the PM user.

1.2.4 info_exchange

1.2.4.1 The ix_main.sql script creates or recreates the IX schema.

1.2.4.2 The dix_v3.sql script drops all objects, but does not remove
the IX user.

1.2.5 sales_history

1.2.5.1 The sh_main.sql script creates or recreates the SH schema.

1.2.5.2 The sh_drop.sql script drops all objects, but does not remove
the SH user

1.2.6 bus_intelligence

1.2.6.1 The bi_main.sql creates user BI and grants SELECT
privileges on specific OE and SH objects.

========================================================================


2. Instructions to create the schemas:


2.1 Decide on passwords for the Sample Schemas. Here, we are using
placeholder names inside "<" and ">" brackets:

SYSTEM: <SYSTEM_password>
SYS: <SYS_password>
HR: <HR_password>
OE: <OE_password>
PM: <PM_password>
IX: <IX_password>
SH: <SH_password>
BI: <BI_password>

2.2 Verify the value for the default tablespace, the temporary
tablespace, and the log file directory. For illustration purposes,
the values are:

default tablespace: EXAMPLE
temporary tablespace: TEMP
log file directory: $ORACLE_HOME/demo/schema/log

NOTE: Use your own passwords.


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.

========================================================================

3. Schema dependencies and requirements:

3.1 The OE schema requires that the database be enabled for spatial data
and that the HR schema exists.

3.2 The PM schema requires that the database be enabled for Intermedia,
which itself requires a Java-enabled database, and that the OE
schema exists.

3.3 The SH schema uses Partitioning and requires that the OE schema
exists.

3.4 The BI schema requires that the OE schema exists.

3.5 Refer to Oracle Database documentation for more detailed
information about the Sample Schemas.

========================================================================

4. Known bugs

4.1 The Sample Schema scripts do not work with pluggable databases.

========================================================================


QUESTION: Can sample scripts be installed in 12c or NOT ???????

Can they be installed in the SEED DB or orcl ???



Re: Installing example Schemas v2...Help [message #652280 is a reply to message #652275] Mon, 06 June 2016 01:38 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8751
Registered: November 2002
Location: California, USA
Senior Member
Since it says:

4.1 The Sample Schema scripts do not work with pluggable databases.

It looks like your choices are either do without the stuff the sample schema scripts would create or start all over with installing a non-pluggable database. The installation of the examples that I did on a standard database was real simple and no problems. That is what I would recommend and I think some others have tried to point you in that direction as well on your other threads here and on the OTN forums.
Re: Installing example Schemas v2...Help [message #652283 is a reply to message #652280] Mon, 06 June 2016 03:09 Go to previous message
icm63
Messages: 22
Registered: December 2007
Junior Member


Just found out sample schemas are in pdborcl plugin DB.

This link made it happen for me:

https://community.oracle.com/thread/2624011?start=0&tstart=0

Samples HR and SCOTT installed!

yippee! Smile
Previous Topic: Oracle number format
Next Topic: Turning Off "Generate DDL" In Data Modeler
Goto Forum:
  


Current Time: Mon Nov 20 11:24:08 CST 2017

Total time taken to generate the page: 0.02240 seconds