PI JDBC sender wit Oracle XE

[Former Member]

Hi,

I have locally instaled Oracle XE for testing, but I can't connect to it. Error is:

Error during database connection to the database URL 'jdbc:oracle:thin:@192.168.1.103:1521:XE' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Can not establish connection:: SQLException: Io exception: The Network Adapter could not establish the connection'

I tried with std. connection string

jdbc:oracle:thin:@192.168.1.103:1521:XE

and also with TNS connection string:

jdbc:oracle:thin:@(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = komadorac)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = XE)

)

)

but no luck. JDBC driver is functioning, ojdbc14.jar is deployed and I can connect to SAP Oracle DB with user SAPSR3.

Any idea?

thx

[former_member187339 · Accepted solution]

Hi,

Try doing a telnet to the port 1521 of Oracle machine from the XI server

Also try the ping test so that we can see there is no network problem

Regards

suraj

[Former Member · Accepted solution]

ping is ok

telnet is not working, it complains about opening of port 23, also if I say server:1521

[former_member187339 · Accepted solution]

Hi Mario,

Hope you have tried the command telnet <machinename> 1521

if it didn't work that means XI server is not able to connect to port 1521. Check with the network team and if some firewall is there in between XI and Oracle serer, get it opened.

Also try a tracert <machinename> and ping <machinename>

Regards

Suraj

[Former Member · Accepted solution]

trace and ping are working fine. is there any simple way to find where is the problem, on server or on my local machine?

is it firewall, on server is turned off, but on my local machine is turned on

Edited by: Mario Slopar on Sep 17, 2009 10:10 AM

[former_member187339 · Accepted solution]

Hi Mario,

By the error it seems to be a connection problem.since trace and ping are working fine that means the requests from XI server is reaching oracle server. The only thing is the port where the request is supposed to be reached is opened or not.

To check that you need to do a telnet from XI server to Oracle machine. The command is as mentioned in my previous mail.

Please check by logging into XI server and not local machine

Regards

Suraj

[Former Member · Accepted solution]

I opened port on my local Firewall and it WORKS!!!!

thx guys

br

mario