# Oracle Database connection installation

**URL:** <https://forum.inductiveautomation.com/t/oracle-database-connection-installation/43331>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [February 11, 2021, 10:22pm UTC](https://forum.inductiveautomation.com/t/oracle-database-connection-installation/43331 "2021-02-11T22:22:05Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![ggross](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ggross/32/12668_2.png) [@ggross](https://forum.inductiveautomation.com/u/ggross)\
**Post date:** [February 12, 2021, 1:04am UTC](https://forum.inductiveautomation.com/t/oracle-database-connection-installation/43331/15 "2021-02-12T01:04:54Z")

</div>

> [@peter](#):
>
> I'm not conversant in Oracle, but I think there could be an error in the DB connector configuration page for Oracle DBs.
> 
> In the Connect URL section, the format of the string is given as this example:
> 
> > jdbc:oracle:thin:@host:port:SID
> 
> But what I found worked for me was:
> 
> > jdbc:oracle:thin:@//host:1521/SID
> 
> This is using the obc8.jar file an connecting to a v12 DB

In testing against the `v18.4.0-xe` docker image with the `ojdbc8.jar` I am finding the following connection strings working in Ignition:

```auto
jdbc:oracle:thin:@localhost:1521:XE
jdbc:oracle:thin:@10.0.1.153:1521:XE #Just in case localhost is a special case
jdbc:oracle:thin:@<hostname>:1521:XE #Just to confirm my hostname works with same syntax

#Formatting you recommended
jdbc:oracle:thin:@//<hostname>:1521/XE 
jdbc:oracle:thin:@<hostname>:1521/XE

```

It could be something with the DB version, but 12 is only about 5 years old if I remember correctly and I don't think the connection strings have changed in that time. Are there any special or non-ASCII characters in either the hostname or the SID?

One thing I did find odd is this syntax faults with a port error despite Oracle claiming it should work:

```auto
jdbc:oracle:thin:@//<hostname>:1521:XE

```

Edit:

> <https://stackoverflow.com/questions/43884504/jdbc-thin-connection-string-in-oracle-uses-both-colon-and-forward-slash>

Looks like for SIDs `/` and `:` work. If you are using a service name, then only `/` will work

As I had no clue about being different types of connections for Oracle, this article looks to explain the differences:

> <https://stackoverflow.com/questions/43866/how-sid-is-different-from-service-name-in-oracle-tnsnames-ora>

---

_[View the full topic](https://forum.inductiveautomation.com/t/oracle-database-connection-installation/43331)._