Not able to connect to oracle database

[rohitit3031]

Hi ,

I am trying to connect to oracle data base in jaspersoft studio 6. 6.0 using  "oracle.jdbc.driver.OracleDriver" . and i am giving below db details to connect to db :

jdbcurl : jdbc:oracle:thin:@172.168.1.1:1521:database Service nameUsername : ABCPASS: ****[/code]

while testing i am getting below error :

Caused by: 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[/code]

i am giving databse service name to access db .

Kindly help.

Thanks

Rohit

[rohitit3031]

Kindy suggest community member

[hozawa]

This is more of a Oracle question than JasperReports question. Should ask at Oracle forum instead of here.

FYI, have you read the following page?

https://chartio.com/resources/tutorials/how-to-fix-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-connect-descriptor/

[rohitit3031]

Hi Hozawa ,

 

Actaully you are right.I was using wrong syntax to call service name .

It is fixed now . But now i am getting one more error. I have already asked question in cummunity for that . Below is the link :

https://community.jaspersoft.com/questions/1107931/severe-error-while-loading-available-fonts

Can you please help me on that ?

Thanks