Wed, 2023-10-18 09:00
HB
Hi,
we are using Aris Mashzone 9.8 and the OS version: red hat linux.
Installed ojdbc6 "/*/MashZone/ppmmashzone/server/bin/work/work_mashzone_m/mashzone_data/jdbcdrivers" in this path (stopped and started the mash zone) and I could see the driver. Now I'm face issue in connecting to DB, tried the below options.
Provide your views, where & what's wrong at my end.
1)
Driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:thin:IP:1523:XE
Details:
The following error occurred when connecting to database "XE": IO Error: The Network Adapter could not establish the connection
2)
Driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:thin:@IP:1523:XE
Details:
The following error occurred when connecting to database "XE": Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Regards,
Harikumar B
It worked with this option :)
Driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:thin:@IP:1523/XE
My issue got resolved.
Ah, glad to hear that it works now.
As far as I know, Oracle supported the URL pattern that you've mentioned in your first post up to version 11g. Later versions only support the pattern you've mentioned in your 2nd post.
Best regards,
Gerhard