Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 448K Databases
- 221K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 520 MySQL Community Space
- 467 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.2K SQL & PL/SQL
- 21K SQL Developer
- 293.3K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 266 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 230 Portuguese
Installing schemas - starting to give up
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
Answers
-
*** 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.
-
-
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
- -
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 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!
-
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 --
-
Well they're not there, but i didn't changed anything. Downloaded, copied to folder and run.
-
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.
