Replies to This Discussion

Permalink Reply by Hobert Sorkin on September 13, 2013 at 4:44pm

I don't know if you are aware of this, but most beginners confuse this about Oracle:

In Oracle, a database means a collection of data files and control files stored on disk. You can have only one database with Oracle XE. A database is mounted by a Oracle instance, which means all the background daemons and programs that you can see with ps.

You probably want a schema, which is what other DBMS products (e.g. MySQL) often refer to as a "database". IIRC there was no limit on the number of schemas in Oracle XE. You can create those from the APEX UI that comes with XE, or from command line (with CREATE USER -- again, confusingly, a user and schema are largely synonymous in this case).

I recommend reading the Concepts guide from Oracle documentation, most of this basic stuff (e.g. how things are called in Oracle-lingo) is covered there.

• ▶ Reply

Permalink Reply by Martin Ross on September 13, 2013 at 4:45pm

No. It's not possible to install multiple XE instances. Oracle XE only allows one instance by machine from the Oracle XE home page you can read:

Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.

To add more instances you can:

• Use virtualization with an XE instace by virtual machine.
• Download for free dev/personal use any other Oracle Database edition, for instance Oracle Standard Edition One.

Anyway, in most of the cases only one instance is enough for all the scenarios. Explain why do you need more instance to assistance about solutions.

To recreate the Xe instance, i thing the best and easy way is uninstall i and install again.

• ▶ Reply

▶ Reply to Discussion