JDBC Sender issue

[Former Member]

hello

I have a JDBC 2 RFC scenario. my problem as you can see from the topic is that I can not pull the data from the DB. my error that I recieve is "TNS:listener does not currently know of SID given in connect descriptor The connection descriptor used by the client was:gwprd1-vip.marganit.gw.mamram:1524:MAOR"

I though the problem is due to port blocked, but it does not shout on could not connect.

the schema, host name and port came from the TNSNAMES.ora

any other suggestions?

Kfir

[Former Member · Accepted solution]

Hi Kfir,

This seems to be an Oracle issue. I have searched for it and some solutions you can try are:

http://ora-12505.ora-code.com/

http://www.dbmotive.com/oracle_error_codes.php?errcode=12505

http://dbaspot.com/forums/oracle-server/200170-ora-12505-tns-listener-does-not-currently-know-sid-gi...

Also you can do a search with your error for few more solutions.

Regards,

---Satish

[Shabarish_Nair]

are you able to ping the JDBC server? try pinging it from the PI server.

Also try to give the IP of the JDBC server instead of the host name in the connection details.