Hi Dave - Your post on hammerora was incredibly useful. Thanks for taking the time to put together the information. I did think however, that there were some small details that you left out (may have been obvious to those experienced with Oracle but confused me for some time):
1) It seems necessary to install hammerora inside the Oracle (OXE in my case) installation folders or set up an ORACLE_HOME environment variable. In my case having installed Oracle Express 10g under the C: drive my ORACLE_HOME environment variable needed to be set to "C:\oraclexe\app\oracle\product\10.2.0"
2) The target Oracle RAC instance needs to be correctly set up in the Oracle tnsnames.ora file.
3) The latest version of hammerora may not need the tablespace, user etc to be set up by hand, but if people do need to do it, then I think you need to update your 'Create Schema' section to include the tablespace creation for TPCC. You covered TPCH correctly I think
Let me know if you agree with these updates
Thanks, Saikat.
Hammerora
Hi Dave - Your post on hammerora was incredibly useful. Thanks for taking the time to put together the information. I did think however, that there were some small details that you left out (may have been obvious to those experienced with Oracle but confused me for some time):
1) It seems necessary to install hammerora inside the Oracle (OXE in my case) installation folders or set up an ORACLE_HOME environment variable. In my case having installed Oracle Express 10g under the C: drive my ORACLE_HOME environment variable needed to be set to "C:\oraclexe\app\oracle\product\10.2.0"
2) The target Oracle RAC instance needs to be correctly set up in the Oracle tnsnames.ora file.
3) The latest version of hammerora may not need the tablespace, user etc to be set up by hand, but if people do need to do it, then I think you need to update your 'Create Schema' section to include the tablespace creation for TPCC. You covered TPCH correctly I think
Let me know if you agree with these updates
Thanks, Saikat.