JDBC Sender Adapter Error-IO Error: The Network Adapter could not establish the connection-PI 7.31

[Former Member]

Hi Experts,

Please help to resolve  following issue .

We are getting following error in SenderJDBC Channel(PI 7.31)

Error during database connection to the database URL 'jdbc:oracle:thin:@//XYZQAHOST.com:1521/XXQAYY' using the JDBC driver 'oracle.jdbc.OracleDriver':

'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.OracleDriver returns: IO Error: The Network

Adapter could not establish the connection.

: SQLRecoverableException: IO Error: The Network Adapter could not establish the connection'

In URL jdbc:oracle:thin:@//XYZQAHOST.com:1521/XXQAYY i have just mentioned dummy host(XYZQAHOST.com) and service name(XXQAYY) , in sender channel we are using correct one.

PI server-Unix(AIX/DB2)/ PI 7.31 , DB Hosts Version: Oracle Database 11g EE-release 11.1.0.7.0

After going through various threads in SCN  which are exist for the same issue, i have done following tests.

1)telnet from PI QA server(os level) to DB QA host ---It was successful, PI server able to connect to DB host--By this test it looks there is no network/firewall issue

2)we are able to connect DB QA host ( XYZQAHOST.com port : 1521 service name:XXQAYY) through oracle sql developer--means target(db qa host) and listener are up and running fine.

3)ojdbc6.jar is already deployed and  sender commcahannel in PI QA system able to connect to oracle DB DEV(XYZDVHOST.com) and extract the data-By this test we assume oracle drivers are working fine( Bothe DEV,QA hosts are same version).

But still we are getting the same error while connecting to PI to DB QA host:XYZQAHOST.com:1521/XXQAYY.

Could you please give any alternatives ways to check and resolve this issue.

[former_member186851]

Hello Ramesh,

This could be due to firewall/network issue.

Check from network side.

[Former Member]

Hi Raghuraman,

I have checked with network team they are saying there is no firewall between these servers(firewall rule is -any destination any port open).

Even we are able to connect oracle DEV system from PI QA system on 1521 port.

[former_member186851]

Hello Ramesh,

So your not able to Oracle Quality DB only?