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

by Harikumar Balasubramanian Author
Posted on Mon, 12/28/2015 - 05:33

It worked with this option :)

 

Driver: oracle.jdbc.driver.OracleDriver

Database URL: jdbc:oracle:thin:@IP:1523/XE

My issue got resolved. 

 

 

0
by Gerhard Müller
Posted on Tue, 01/05/2016 - 09:01

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

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • Profile picture for user frankweise
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock