Siebel Tools >  How To Reset A Siebel Tools IP2016 Oracle XE Database

How To Reset A Siebel Tools IP2016 Oracle XE Database

Starting from Siebel IP16.0 the only option is Oracle XE database for Siebel developers. How can we reset Oracle XE database (without having to reinstall Siebel Tools)?

Say once we have downloaded/initialised a local database for a developer (let's say on machine ABC).
This developer leaves the company.
Someone else will now use machine ABC.
But this new user wants to initialise his own local database and does not want the already existing local database on this machine.
Siebel Tools should not be reinstalled; existing Siebel Tools installation will be used.
So, only the local database should be reset.

SOLUTION

For Siebel IP16.0 there is a special utility available for customers deployment with Oracle XE.

Basically for Siebel IP 16.0 version there is a configuration utility called "OracleXEConfig.bat" which can be found under the Siebel Tools BIN directory (SIEBEL_TOOLS_ROOT\bin directory). This utility will be helpful to create, manage, and switch between different installed instances of Oracle Database XE databases.

Information about Oracle XE backups and instances on a specific deployed machine: Generally all backup's are stored in the filesystem specified while taking backup. Non-Running instance is always present at oraclexe/app/oracle/oradata. This folder will contain all instances available on machine, so it is recommended to run OracleXEConfig.bat utility to find out the current instance. Current Instance and XE folder under oraclexe/app/oracle/oradata should not be deleted, otherwise Oracle XE will stop working. However, it is safe to delete the backup or any non-running instance available in machine.

In summary, by taking a backup of folder TOOLS_ROOT_FOLDER\oraclexe before starting the DB Initialization task, you can always reset the Oracle XE without having to reinstall Oracle XE for a clean new database instance.