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