If you're installing your SCM Server component (broker and hservers) to a Unix/Linux machine that also has the 64-bit Oracle server (database) software installed, SCM cannot connect directly to your database since it's a 32-bit application. What you can do is install the 32-bit Oracle client software and let SCM use that to connect to your 64-bit Oracle database instead. Here's how:
cp /app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora /app/oracle/product/11.2.0/client_1/network/admin
chmod a+r /app/oracle/product/11.2.0/client_1/network/admin/tnsnames.ora
where: <userid> is the Harvest database schema owner userid <service> is the tns service name found in the tnsnames.ora file <password> is the Harvest schema owner passwordexample: sqlplus harvest@orcl/harvest
After this, hdbsetup should be able to create your database and ODBC connection with no problems.