Oracle Database Discussions

*** 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.

How do I ask a question on the forums?

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

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 --

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 exist
DROP PACKAGE xdb.xdb_namespaces
*
ERROR at line 1:
ORA-04043: object XDB_NAMESPACES does not exist
DROP PACKAGE xdb.xdb_dom_helper
*
ERROR at line 1:
ORA-04043: object XDB_DOM_HELPER does not exist
DROP PACKAGE xdb.xdb_utilities
*
ERROR at line 1:
ORA-04043: object XDB_UTILITIES does not exist
DROP PACKAGE xdb.xdb_tools
*
ERROR at line 1:
ORA-04043: object XDB_TOOLS does not exist
DROP TRIGGER xdb.no_dml_operations_allowed
*
ERROR at line 1:
ORA-04080: trigger 'NO_DML_OPERATIONS_ALLOWED' does not exist
DROP 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!

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

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 --

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?

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.

All, that when I installed XE for 11.2 it did support the sample schemas.  This fact does not change the validity of Billy's point on asking exactly what was downloaded since that download may not be XE compatible or it may be and the error messages can be ignored since the tables (hopefully with data) were created per the OP.

- -

HTH -- Mark D Powell --