Hari1234's picture

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