# Configuring Oracle XE 11g to Connect with Ignition Database **URL:** \ **Category:** General Discussion\ **Created:** [March 11, 2012, 4:59am UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132 "2012-03-11T04:59:24Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![kilas78](https://avatars.discourse-cdn.com/v4/letter/k/ed655f/32.png) [@kilas78](https://forum.inductiveautomation.com/u/kilas78)\ **Post date:** [March 11, 2012, 4:59am UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/1 "2012-03-11T04:59:24Z")
Hello, I am new to this ignition service, can anyone please help me out configuring the igntion server to connect to Oracle Application express DB. I have read all instructions here : [inductiveautomation.com/supp … 33B2A9D81A](http://www.inductiveautomation.com/support/quickstart/db;jsessionid=9366C6A371453F793D213833B2A9D81A) and followed them, but still my database is faulted in the igntion gateway server. Attached are files containing the errors and how im following the instructions, Im sure that the DB tables are created automatically when the ignition gateway is connected to the DB. Thanks, Syed. ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/399e21caf615caa788af1b7845d21aff4c886e9f.jpg) ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/3d694d96bf621e346e2870c0a6118bb304e9ef4f.jpg) ---
**Author:** ![kilas78](https://avatars.discourse-cdn.com/v4/letter/k/ed655f/32.png) [@kilas78](https://forum.inductiveautomation.com/u/kilas78)\ **Post date:** [March 11, 2012, 5:02am UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/2 "2012-03-11T05:02:16Z")
One more Image, showing configuration of the ProcessDB in Igntion server. ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/a10837b9314a9f778b52e4d08b410617503c2901.jpg) ---
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [March 12, 2012, 2:36pm UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/3 "2012-03-12T14:36:44Z")
I’ve never set up Ignition with Oracle, but is the username case sensitive? The Oracle console is showing the username is ‘TEST’ and in Ignition you have ‘test’. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [March 12, 2012, 4:00pm UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/4 "2012-03-12T16:00:50Z")
Usually the connect url for the expression edition is: jdbc:oracle:thin@localhost:1521:XE with username SYS or SYSTEM (all uppercase) and whatever password you used in the installation. ---
**Author:** ![kilas78](https://avatars.discourse-cdn.com/v4/letter/k/ed655f/32.png) [@kilas78](https://forum.inductiveautomation.com/u/kilas78)\ **Post date:** [March 12, 2012, 6:43pm UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/5 "2012-03-12T18:43:42Z")
Hi Travis, Thanks for replying. I have changed the SID to XE as mentioned and the username to SYS & SYSTEM, with the password that I specified during installation and that works in Oracle Application express. But still the database connection is Faulted in Ignition gateway. pls help. Thanks. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [March 12, 2012, 8:18pm UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/6 "2012-03-12T20:18:13Z")
Please go to the Database Connection Status page in Ignition - this will help you narrow down the reason that the connection is faulted. ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [March 12, 2012, 8:27pm UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/7 "2012-03-12T20:27:32Z")
Hi, If you click over to “Status” and then “Database Connections”, you will see more information about why the connection is faulted. Posting this will help us offer suggestions. Regards, ---
**Author:** ![kilas78](https://avatars.discourse-cdn.com/v4/letter/k/ed655f/32.png) [@kilas78](https://forum.inductiveautomation.com/u/kilas78)\ **Post date:** [March 15, 2012, 11:47am UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/8 "2012-03-15T11:47:28Z")
Travix, Carl , Colby … Thank you very much for your kind help. I have the database connected, up and running now on my PC. The username is SYSTEM and the settings as you mentioned are XE. Thanks. Please guide me further on how to link this with my organizations ERP, Oracle E-business Suite 11i Thanks once again. ---
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [March 15, 2012, 1:36pm UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/9 "2012-03-15T13:36:56Z")
I guess the question at this point is where and how do you want to integrate Ignition with Business Suite? I’m guessing you want to pull information into Oracles SCM module? ---
**Author:** ![kilas78](https://avatars.discourse-cdn.com/v4/letter/k/ed655f/32.png) [@kilas78](https://forum.inductiveautomation.com/u/kilas78)\ **Post date:** [March 17, 2012, 2:47am UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/10 "2012-03-17T02:47:38Z")
Well you can say that, the production data needs to be linked to SCM module, OEE needs to be linked to HRM module, and CpK links to something different, has anyone done this before ? ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [March 21, 2012, 5:47pm UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/11 "2012-03-21T17:47:02Z")
People have done this, but as I understand it the variations that occur from install to install prevent a nice clean “How-to” on accomplishing this. That, and we just aren’t familiar enough with Oracle SCM to guide you much. Basically, your question is too broad to be answered simply. Now you get the the hart part: good old-fashioned integration work. You’re going to need to bring in someone who’s familiar with how your Oracle install is set up. ---
**Author:** ![kilas78](https://avatars.discourse-cdn.com/v4/letter/k/ed655f/32.png) [@kilas78](https://forum.inductiveautomation.com/u/kilas78)\ **Post date:** [March 23, 2012, 3:59pm UTC](https://forum.inductiveautomation.com/t/configuring-oracle-xe-11g-to-connect-with-ignition-database/4132/12 "2012-03-23T15:59:43Z")
Thanks Carl, yeah we had external company setup oracle for us, we will contact them. Thanks for your help.