When you trying to create new Data Sources - JDBC source (Navigate to Administrator link --> Manage BI Publisher -->JDBC Connection) -- with Oracle Database you may face 'Could not establish connection.' With this you will not be able to identify root cause.
Go to EM (Fusion Middleware control) check logs you may able to see some useful information.
If you see following error then change the connection string from jdbc:oracle:thin:@databasehost:post_number:your_sid to jdbc:oracle:thin:@//databasehost:post_number/your_sid
Error message: Message java.sql.SQLException: Listener refused the connection with the following error:
Supplemental Detail ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:482)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:678)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:238)
Supplemental Detail ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:482)
at oracle.jdbc.driver.PhysicalConnection.
at oracle.jdbc.driver.T4CConnection.
Thank you Chris Tanabe for helping me on this.
Regards,
Srinivas Malyala
