Oracle Database XE is a great starter database for:
- Developers working on Node.js, Python, PHP, Java, .NET, XML, and Open Source applications
- DBAs who need a free, starter database for training and deployment
- Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
- Educational institutions and students who need a free database for their curriculum
With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations.
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 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.
Support is provided through a free Oracle Discussion Forum monitored by Oracle employees as well as community experts.
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.
To recreate the Xe instance, i thing the best and easy way is uninstall i and install again.
