Hi,

I am getting the below error upon connecting to the repository using command:
sh kitchen.sh -rep=DWH_ETL_REPO -user=admin -pass=passwd -listdir

error:
Error occured while trying to connect to the database

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
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:
cc2pre01cl:1521:NWH

My repositories.xml file looks like this:
<?xml version="1.0" encoding="UTF-8"?>
<repositories>
<connection>
<name>DWH_ETL_REPO</name>
<server>"ORACLE_RAC_CLUSTER_NAME"</server>
<type>ORACLE</type>
<access>Native</access>
<database>"DATABASE_NAME"</database>
<port>1521</port>
......
.....

Can anyone please point me in the right direction so as to what should the repositories.xml look like for an Oracle RAC database.

Many thanks in advance!

Regards,
Kirti