Not able to connect to oracle database

0

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

rohitit3031's picture
Joined: Oct 7 2018 - 11:22pm
Last seen: 6 months 2 weeks ago

Kindy suggest community member

rohitit3031 - 1 year 1 month ago

2 Answers:

1

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...

hozawa's picture
52552
Joined: Apr 24 2010 - 4:31pm
Last seen: 5 months 1 week ago
0

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

 

 

rohitit3031's picture
Joined: Oct 7 2018 - 11:22pm
Last seen: 6 months 2 weeks ago
Feedback
randomness