Connecting to JDBC system (Oracle)

[peter_jarsunek]

Hi guys,

I have a problem with connecting to my Ora DB from the Portal.

What did I do:

I created the JDBC system in my landscape, gave it an alias and in the system properties I also have: URL connection jdbc:oracle:thin:@<host_ip>:<port>:<SID>

and as a driver class I have oracle.jdbc.driver.OracleDriver .

I have created also user mapping for this system. But I still have a problem in testing my connection.

When I test the connection I get result:

Results

Retrieval of default alias successful

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.

What could be wrong?

Maybe, my JDBC driver is not installed properly. How is it possible to test it? Or, can someone send me a link to a HOW-TO guide for ora jdbc driver installation?

Thanx a lot, Peter

[Former Member]

Hi,

Please refer to the discussion

we have worked on a similar issue.

Regards,

Divakar

[Former Member]

Hi Peter,

you must use the special SAP Oracle JDCBC driver to access your Ora DB:

URL: jdbc:sap:oracle://<server>:<port>;SID=<sid>

e.g. jdbc:sap:oracle://myoracleserver:1521;sid=PIL

see the following thread:

Best regards,

Stefan Brauneis