1 Reply Latest reply: Nov 14, 2012 7:55 AM by PeakIndicators_Alastair RSS

    ODI Connection for RAC database

    Saurabh Gupta-OC

      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:

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:280)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:361)
      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
      at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java......

      Below is the detail given in Url field:


      Please assit if you have solution.