# Faulted in Creating Oracle New Connection using Oracle JDBC

**URL:** <https://forum.inductiveautomation.com/t/faulted-in-creating-oracle-new-connection-using-oracle-jdbc/11069>\
**Category:** General Discussion\
**Created:** [January 20, 2016, 6:01am UTC](https://forum.inductiveautomation.com/t/faulted-in-creating-oracle-new-connection-using-oracle-jdbc/11069 "2016-01-20T06:01:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ian](https://avatars.discourse-cdn.com/v4/letter/i/bb73d2/32.png) [@ian](https://forum.inductiveautomation.com/u/ian)\
**Post date:** [January 20, 2016, 6:01am UTC](https://forum.inductiveautomation.com/t/faulted-in-creating-oracle-new-connection-using-oracle-jdbc/11069/1 "2016-01-20T06:01:50Z")

</div>

Hi,

I encountered a problem when I tried to connect to the existing Oracle database.

I am using Oracle 12c (not express)

According to the ([https://inductiveuniversity.com/video/connecting-to-oracle-express?r=/course/databases-in-ignition](https://inductiveuniversity.com/video/connecting-to-oracle-express?r=/course/databases-in-ignition))]lecture we are to set the Connect URL.

For XE, we are to put: jdbc:oracle:thin:@localhost:1521:XE

What do we put for non-express Oracle?

Then the Username must be the user name of the database, am I right? And do we need to put schema name there?

Username: schema.username or Username: username

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![ian](https://avatars.discourse-cdn.com/v4/letter/i/bb73d2/32.png) [@ian](https://forum.inductiveautomation.com/u/ian)\
**Post date:** [January 20, 2016, 6:14am UTC](https://forum.inductiveautomation.com/t/faulted-in-creating-oracle-new-connection-using-oracle-jdbc/11069/2 "2016-01-20T06:14:20Z")

</div>

I just want to update that I already found the problem with my new connection’s creation: the Database Service Name was missing.

The Connect URL should be:

jdbc:oracle:thin:@localhost:1521:MyDBServiceName

And the user name doesn’t require schema.