How do i connect to my workspace(s) from SQL Plus.
691512May 9 2009 — edited May 10 2009Hello
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.