Unable to reverse database with Oracle 19C

General Questions/Discussions
1

I am unable to reverse database with an Oracle 19C database. When I enter the connection info and test the connection, I get an error message that it cannot connect to the database.

When I click on show details, it shows the following:

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

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
at org.orm.ertodb.DriverWrapper.connect(DriverWrapper.java:27)
at v.aam.c.a(:66)
at v.aam.c.b(:78)
at v.aam.av.run(:25)

Thanks!

2

Hi nvacin,

Thank you for your post. May I know how and where did you obtain the driver file? Could you upload a screenshot of the database configuration window?

Best regards,
Jick Yeung

3

Hi Jick,

Thanks for the response. For the driver file, I clicked on the green arrow and got it from the Oracle website. I attached a picture of the database configuration window.

database configuration
database configuration1152×797 94.7 KB

thanks,
Noel Vacin

4

Hi Noel,

It should be the connection URL configuration problem.
I don’t know your Oracle configuration, you may connect your Oracle with SID, service name, or TNS style.
You can choose the 2nd radio button to customize the connection URL.
For example:
jdbc:oracle:thin:@prodHost:1521:ORCL
jdbc:oracle:thin:@(description=(address_list=(address=(protocol=tcp)(port=1521)(host=prodHost)))(connect_data=(INSTANCE_NAME=ORCL)))

You may refer to your server configuration and Oracle documentation:
https://docs.oracle.com/database/121/TDPJD/getconn.htm#TDPJD138

1 Like