ARIS Community - We Love BPM

Unable to connect to DB

Hari1234's picture
by Harikumar Balasubramanian in MashZone posted on 2015-12-28

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

13266 Views
0 Likes
2 Comments
Sorry there are no tags
There are no attachments
Harikumar Balasubramanian posted on 2015-12-28

It worked with this option :)

 

Driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:thin:@IP:1523/XE

My issue got resolved. 

 

 

Gerhard Müller posted on 2016-01-05

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