How to Connect Jmeter JDBC Connection with Oracle OCI Driver

1.Open Jmeter Instance

2,Create New JDBC Recording

3.Save it as JDBC.jmx

4.In Test Plan add below jar, you can find in Oracle 11g client which is installed n your Machine.
ojdbc5.jar
ojdbc5_g.jar
ojdbc5dms.jar
ojdbc5dms_g.jar
ojdbc6.jar
ojdbc6_g.jar
ojdbc6dms.jar
ojdbc6dms_g.jar

simplefan.jar

5.Database URL =jdbc:oracle:oci:@jdbcconnection

6.JDBC Driver Class=oracle.jdbc.driver.OracleDriver

7.Username=xxxxx

8.Password=xxxxx

9.Add Script like "Select * from dual"
10.Run the Jmeter Script.
11,.Find the Result.
Thanks~

If you have any question,Please reply back to me.

How to Connect JDBC with Oracle RAC for Failover Testing.

Hi Guys,

Please follow below Steps to connect JDBC with Oracle.

1.Install Oracle 11g CLient in your Machine.

2.Create JDBC Program in Eclipse

3.in JDBC Program mention below thng in code

                 user = xxx

password = xxxxx

database = xxxxx    //TNSnames.ora file 

           URL("jdbc:oracle:oci:@" + database);

4.Go to XXXXX\product\11.2.0\client_2\network\admin\tnsnames.ora

database=

    (DESCRIPTION =  (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))

           (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxxxx)))

5.InEclipse Add Jar

     xxxxx\product\11.2.0\client_2\jdbc\lib

6.Set Class Path

7.Run your Program.

8.Go to Oracle Server

9.Down Any Node

10.The traffic should move to another Node.

Thanks~

If you have any concern,Please revert back to me.