We are planning to run the benchmark on our RAC database. for the doc(the Benchmark Factory user guide 6.1 for database editio), it is stated that we first should add some tnsnames entries one node by node(mytns1 for node1, mytns2 for node2, mytns3 for node3). However, we setup SCAN listener that is the RAC 11gR2 new feature.
1) Can we just add one entry by using RAC scan port, and scan IP in the tnsname.ora for benchmark testing?
2) In the doc, it is said "mytns is the root and mytns1,mytn2 and mytns3 will be used when the test is run. But how we can test the RAC load balance?
1) If using the RAC 11g SCAN listener feature you would only require one TNS entry since the Oracle client/SCAN is taking care of load balancing across the different node.
2) You would not use the BMF load balancing (Clustering enabled) if you want to test Oracle's load balancing.