Skip to Main Content

APEX

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 do i connect to my workspace(s) from SQL Plus.

691512May 9 2009 — edited May 10 2009
Hello

I've 2 question here:

1. after downloading OEHR sample objects as describes here:
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28551/get_start.htm#BABGAFBD

I downloaded and unzipped the oehr_sample_objects.zip which gives me the oehr_sample_objects_installer.sql file.
I imported it to my workspace (Train) and it's working fine but as i was reading through different documents like this one:

http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10771/installation002.htm

it says:: All scripts necessary to create sample schemas reside in $ORACLE_HOME/demo/schema/order_entry (for oracle 9i, 10g,) but in my machine i have only HR in that directory which is carried over from original db10gxe and i don't see the oe_main.sql which would instal Order Entry (OE) Schema and its Online Catalog (OC) Subschema.

but my question is howcome the oehr_sample_objects.zip only gives my one oehr_sample_objects_installer.sql file?
which doesn't contain the:

Product Media (PM) Schema, Information Exchange (IX) Schema, Sales History (SH) Schema

I couldn't find the sample schemas download link\file which contains all the PM,IX,SH.

Please let me know where can i download the entire sample schemas as i did search but couldn't find it.

The 2 question is:

How can i log in to my workspace(s) from SQL Plus?
Do I need to modify tnsnames.ora?

all my HR,OEHR schemas are in XE database.

from sql plus i can connect as hr/hr@xe but when i spacify oe/oe@xe it says: Invalid username/password.
(password is absolutely correct).

I am wondering since i unzipped and instal the oehr_sample_objects_installer.sql file in the related workspace i can see all the oehr tables but howcome i can't login to it from sql plus and unlock oe user??

Thanks for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2009
Added on May 9 2009
4 comments
2,690 views