Showing results for 
Search instead for 
Did you mean: 

Connecting to JDBC system (Oracle)

0 Kudos

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:


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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos


Please refer to the discussion

we have worked on a similar issue.



Former Member
0 Kudos

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