rohitit3031 Posted October 9, 2018 Share Posted October 9, 2018 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.ThanksRohit Link to comment Share on other sites More sharing options...
rohitit3031 Posted October 9, 2018 Author Share Posted October 9, 2018 Kindy suggest community member Link to comment Share on other sites More sharing options...
hozawa Posted October 9, 2018 Share Posted October 9, 2018 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/ Link to comment Share on other sites More sharing options...
rohitit3031 Posted October 11, 2018 Author Share Posted October 11, 2018 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-fontsCan you please help me on that ?Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now