I am trying to create master repository in ODI. We have RAC database and I want to give scan ip for making connection in URL field.
I started repcreate.sh script to open "Master Repository Creation Wizard" and in URL text field I tried to connect by giving single instance detail and its connecting fine.
But when I tried to give scan ip its throwing error message:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
Had the same thing before (in a Hurry) so I created it against one of the Rac Nodes, then edited my Topology connections (Data servers , Work Repos connections, User login profiles) to use the RAC connection and it was fine.
It might be something to do with the RCU not liking RAC conns.
Hope this helps,