# JDBC Oracle thin connection string

**URL:** <https://community.smartbear.com/t/jdbc-oracle-thin-connection-string/256>\
**Category:** ReadyAPI\
**Tags:** readyapi, api, migrated, data-driven-testing, rest\
**Created:** [February 6, 2023, 2:11pm UTC](https://community.smartbear.com/t/jdbc-oracle-thin-connection-string/256 "2023-02-06T14:11:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@system](https://community.smartbear.com/u/system)\
**Post date:** [February 6, 2023, 2:11pm UTC](https://community.smartbear.com/t/jdbc-oracle-thin-connection-string/256/1 "2023-02-06T14:11:07Z")

</div>

> Originally posted by **armygrad** on February 06, 2023

HI

I have the connection string below

dbc:oracle:thin:A\_USER[IRM]/PASS\_VALUE@oda23:1111:DBSCHEMA

And im getting the error below, i am using the details from the connection for this schema that is in PL/SQL Developer, and its connecting to the DB

With no issues, what am i doing wrong?

Cannot get a connection for the specified properties java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor (CONNECTION\_ID=Ks5zc1X4QcCabkq8DQ6lxQ==)

This is my connection string template

jdbc:oracle:thin:/@HOST:127.0.0.1:PORT:1111:

Thanks

---

<div class="post-metadata">

**Author:** ![system](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@system](https://community.smartbear.com/u/system)\
**Post date:** [February 7, 2023, 3:07am UTC](https://community.smartbear.com/t/jdbc-oracle-thin-connection-string/256/2 "2023-02-07T03:07:51Z")

</div>

> Originally posted by **nmrao** on February 06, 2023

Suggest you to check oracle forums.

Can you connect using sqlplus command line with the same details?

---

<div class="post-metadata">

**Author:** ![system](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@system](https://community.smartbear.com/u/system)\
**Post date:** [February 7, 2023, 10:05am UTC](https://community.smartbear.com/t/jdbc-oracle-thin-connection-string/256/3 "2023-02-07T10:05:33Z")

</div>

> Originally posted by **armygrad** on February 07, 2023

I think its because there are no listeners configured see image below

 ![armygrad_0-1675764216820.png](https://canada1.discourse-cdn.com/flex049/uploads/smartbear_prod/original/1X/47ed4e69068e81c510f327a89d38bdd6a6b72724.png)

when i open the demo listeners file

 ![armygrad_1-1675764284415.png](https://canada1.discourse-cdn.com/flex049/uploads/smartbear_prod/original/1X/3cd68e319273e1941f03faa256e2bdb265ffc774.png)

could this be the issue?

Thanks