Life Sciences

What Is OracleXEConfig?

A new utility was provided with Siebel version 16.0 (i.e., IP2016) that is quite useful. OracleXEConfig allows you, as a developer, to have multiple Oracle XE instances on your computer and enables you to quickly switch to one that is active. It also allows you to create empty local databases. This is extremely useful if you support multiple clients or work on multiple projects.

The utility resides in the Tools\BIN directory:

Launching this utility brings up this tab:

Life Sciences - How Artificial Intelligence Can Enhance the Clinical Data Review and Cleaning Process
How Artificial Intelligence Can Enhance the Clinical Data Review and Cleaning Process

This guide analyzes how artificial intelligence – including machine learning – can be used by pharmaceutical and medical device companies to improve the clinical data review and cleansing process.

Get the Guide

 

What is the instance name? What is the username/password you want created? What is the pick directory? The pick directory is the only tricky one: it is requesting is the install directory in which the .DBF files are located. For most people, creating a local DB will be:

C:\Siebel_Install_Image\16.0.0.0\Windows\Client\Siebel_Tools\Disk1\stage\XE\Utils\Local\64bit

Of course, if your OS is 32-bit, you should choose that one.

After clicking [Setup], here is the end result (after about five minutes):

Now, on my MacBook, I have two different databases to choose from: one for the ASCEND project and one for the Sun project.

Two final notes:

  1. I found that after switching databases, I needed to reboot. There is probably a way to avoid this, but it was easy enough to do.
  2. The database is initially empty, as mentioned in a previous blog post.
About the Author

With 20 years of life sciences experience and 10 of working with Siebel, Rene is a Lead Technical consultant @ Perficient. Originally from Montreal, PQ, Rene now resides in Augusta, GA.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up