Installing schemas - starting to give up

3563056

Hey,

I'm trying to install schemas with Oracle XE or Enterprise.

I managed to unlock HR user as it's installed with XE but no luck with other schemas. They're not in demo folder, I also tried to download them but when i start oe_main.sql it crashes on creating tables like customers saying something about wrong datatype

I did found information that with full installed all schemas are installed automaticly but sadly nothing like that happened to me

I refered to this doc: https://docs.oracle.com/database/121/COMSC/installation.htm#COMSC00005  but it was crashing like i said before. It's been almost a week strugle and i'm out of ideas. Could you please help

BluShadow

*** Moderator Note: Now moved to General Database space (I was in two minds whether to put it in installation, but I think this is the better for this question).  Please note that the "Community Feedback (No Product Questions)" space is exactly what it says in the title, a space for feeding back on the actual community and NOT a place to ask product related questions.  Please ensure you search for the correct product related space for your product questions in future.

John Thorton

How do I ask a question on the forums?

Unknown

For people to be able to help you'll need to post the exact error messages you're receiving and not 'something like'

Mark D Powell

What full version of Oracle are you using?  Did you obtain the oe_main.sql script that matches the version of Oracle you have?

- -

Since as Rob noted you did not post the actual error message you are receiving I was unable to search Oracle support for known issues related to the error but perhaps the following will give you an idea

Is It Possible To Recreate The Example Schemas Hr And Oe? (Doc ID 752140.1)

- -

HTH -- Mark D Powell --

3563056

SP2-0310: unable to open file "C:\oraclexe\app\oracle\product\11.2.0\server/demo/schema/order_entry/xdbSupport.sql"SP2-0310: unable to open file "C:\oraclexe\app\oracle\product\11.2.0\server/demo/schema/order_entry/createUser.sql"Connected.Session altered.SP2-0310: unable to open file "C:\oraclexe\app\oracle\product\11.2.0\server/demo/schema/order_entry/xdb03usg.sql"Connected.Revoke succeeded.Revoke succeeded.Revoke succeeded.DROP PACKAGE xdb.xdb_configuration*ERROR at line 1:ORA-04043: object XDB_CONFIGURATION does not existDROP PACKAGE xdb.xdb_namespaces*ERROR at line 1:ORA-04043: object XDB_NAMESPACES does not existDROP PACKAGE xdb.xdb_dom_helper*ERROR at line 1:ORA-04043: object XDB_DOM_HELPER does not existDROP PACKAGE xdb.xdb_utilities*ERROR at line 1:ORA-04043: object XDB_UTILITIES does not existDROP PACKAGE xdb.xdb_tools*ERROR at line 1:ORA-04043: object XDB_TOOLS does not existDROP TRIGGER xdb.no_dml_operations_allowed*ERROR at line 1:ORA-04080: trigger 'NO_DML_OPERATIONS_ALLOWED' does not existDROP VIEW    xdb.database_summary*ERROR at line 1:ORA-00942: table or view does not exist

I removed all Oracle instances, installed XE version, unlocked HR and runned oe_main.sql from sqlplus logged as sysdba. It has created tables and views, and i'm attaching log from errors. Are they important for study?

Thanks!

EdStevens

Your log shows three messages of "unable to open file".  Show proof that those files exist.

Mark D Powell

As Ed noted, why are the files that the routine needs unavailable?  Do you have the files located in the correct location and owned by the Oracle user?  Or at least accessible by the Oracle user?

- -

HTH -- Mark D Powell --

3563056

Well they're not there, but i didn't changed anything. Downloaded, copied to folder and run.

EdStevens

74074185-0997-4dd4-b3eb-acbb19b40a1c wrote:Well they're not there, but i didn't changed anything. Downloaded, copied to folder and run.

Due to a warp in the time-space continuum (possibly a gravitational wave discovered by the recipients of this week's Nobel award in physics) I am unable to see over your shoulder to know exactly what you did.

Downloaded what?

Copied to what folder?

What did you run? from where? How?

Billy Verreynne

Also, to add to Ed's comments - the What Downloaded? is important to answer. Oracle XE, as a free and no-cost version, does not have the full Oracle RDMS feature set. The XDB component for example is a limited install. There is no Java VM runtime. Etc.

The what downloaded will point to the Oracle feature set required, whether XE can be used, and how to correctly install it in XE, if at all.