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!

How to install the OE schema in Oracle 12c using Windows 10?

talk2meNov 30 2015 — edited Dec 1 2015

Hi all,

Basically, I followed the same procedure from:

Namely, editing the .../app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora to include the PDB name, e.g. pdborcl. by adding the below:

PDBORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = vm21)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = pdborcl)

)

Then, I edited the oe_main.sql file similar to the way you edit the hr_main.sql as seen here (last comment in the thread):

This is where things go wrong. While the above procedures worked for the HR schema, I run into problem with the OE schema.

1. I log into sqlplus via:

Username: sys as sysdba

Password: <my sys password>

2. Then I type the following:

alter session set container = pdborcl;

select name, open_mode from v$pdbs;

alter USER oe IDENTIFIED BY oe ACCOUNT unlock;

3. Then I run:

@?\demo\schema\order_entry\oe_main.sql

But then I get the following msgs:

SQL> @?\demo\schema\order_entry\oe_main.sql

specify password for OE as parameter 1:

Enter value for 1: oe

specify default tablespeace for OE as parameter 2:

Enter value for 2: users

specify temporary tablespace for OE as parameter 3:

Enter value for 3: temp

specify password for HR as parameter 4:

Enter value for 4: hr

specify password for SYS as parameter 5:

Enter value for 5: <my sys-password>

specify directory path for the data files as parameter 6:

Enter value for 6: D:\app\silent\product\12.1.0\dbhome_1\demo\schema\Sample_Data

writeable directory path for the log files as parameter 7:

Enter value for 7: D:\app\silent\product\12.1.0\dbhome_1\demo\schema\log

specify version as parameter 8:

Enter value for 8: 1

User dropped.

old 1: CREATE USER oe IDENTIFIED BY &pass

new 1: CREATE USER oe IDENTIFIED BY oe

User created.

old 1: ALTER USER oe DEFAULT TABLESPACE &tbs QUOTA UNLIMITED ON &tbs

new 1: ALTER USER oe DEFAULT TABLESPACE users QUOTA UNLIMITED ON users

User altered.

old 1: ALTER USER oe TEMPORARY TABLESPACE &ttbs

new 1: ALTER USER oe TEMPORARY TABLESPACE temp

User altered.

Grant succeeded.

Connected.

Grant succeeded.

Connected.

Grant succeeded.

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

SP2-0640: Not connected

SP2-0310: unable to open file "D:\app\silentraid\product\12.1.0\dbhome_1/demo/schema/order_entry/coe_1.sql"

SP2-0310: unable to open file "D:\app\silentraid\product\12.1.0\dbhome_1/demo/schema/order_entry/loe_1.sql"

SP2-0310: unable to open file "D:\app\silentraid\product\12.1.0\dbhome_1/demo/schema/order_entry/poe_1.sql"

SP2-0640: Not connected

...creating subschema OC in OE

SP2-0640: Not connected

SP2-0641: "EXECUTE" requires connection to server

Connected.

Synonym created.

So, I guess I have several questions:

1. What is the directory path for the data files as parameter 6 used for?

2. What is the specify version as parameter 8 used for?

3. What am I missing?

Thanks!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 29 2015

Added on Nov 30 2015

#general-database-discussions

3 comments

1,579 views