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 name Username : ABC PASS: ****
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
i am giving databse service name to access db .
Kindly help.
Thanks
Rohit
2 Answers:
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-listene...
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-lo...
Can you please help me on that ?
Thanks
Kindy suggest community member