I'm trying to connect to an Oracle DB on a remote server. I have verified that all the entries are correct & that the listener is active on the remote server. I can also access the server from another server. But in AED I keep getting this error:
Error getting Input Schema for Read DB Task: java.lang.IllegalStateException: Failed to initialize the DB connection: DB URL = jdbc:oracle:thin:@//135.122.28.36:1521/A
2 things I have observed on the Attributes form:
- There is no example for the Oracle DBType. I used Oracle- is that correct?
- The db class example is oracle.jdbc.driver.OracleDriver, but the one we've been usin is oracle.jdbc.OracleDriver
For the URL, I thought the tool would plug in the Database Name & Port but since it showed it in the example, I tried it both ways (with & w/o that info), to no avail.
Also, is it safe to "assume" that even though the password field has 5 dots, it does not indicate the actual length of the password?
This is AEDP 3.0.3.0.303003 & AED 3.0.4.0.281
Thanks.