Oracle database Testing

In this blog, I’ll tell you how to load test the oracle database using loadrunner. There are different ways to achieve it and one simple way is writing SQL queries in vugen script.

In this blog I’m going to tell how to connect to database, how to execute query and how to disconnect. I will be using lr_db functions to achieve this. Loadrunner help is very useful with details about lr_db functions.


Connect to Oracle database:

lr_db_connect("StepName=Connect",
        "ConnectionString=Provider=OraOLEDB.Oracle; dbq=10.xx.xx.xx:1540; Data Source=XXXX; Persist Security Info=True; User ID=username; Password=password",
        "ConnectionName=OracleDB",
        "ConnectionType=OLEDB",
LAST );

SQL statement:
lr_db_executeSQLStatement("StepName=PerformQuery",
                "ConnectionName= OracleDB",
                "SQLStatement=SELECT * FROM \"TableName\" ",
                "DatasetName=MyDataset",
                LAST );

Disconnect from database:
                lr_db_disconnect("StepName=Disconnect",


                 "ConnectionName= OracleDB", LAST );


Pre-requisites:
Oracle Client need to be installed in load generator machine and TNS entry should be there for data source.
Use web services protocol for loadrunner vugen script.

Comments

Post a Comment

Popular posts from this blog

Lr Advance Param Function In Loadrunner With Example

This function is not recorded during recording. We manually insert this function whenever there is a need of it. lr_advance_param works depends upon the settings we give in parameter list (ctrl+L). lr_advance_param is like update value on each occurrence. Whenever we want to update a parameter value in the same iteration we use lr_advance_param. For example when we want to use two parameters Google and Bing in one Iteration. Usually the Vugen takes the first value google and if we want to use the second value in the same iteration we use  update value on each occurrence  in the parameter settings. We can do the same using lr_advance_param function. Example: I have set following settings in Parameter Select Next Row:  Sequential Update value on:  Each Iteration If we want to take the next value in the pramater list we use lr_advance_param as shown below. Parameter Name:  DomainName Google Bing Yahoo Ask Vugen Script: Action () { web_u
Read more

web_set_max_html_param_len

The  web_set_max_html_param_len  function sets the maximum length of any HTML string which VuGen can retrieve and save in a parameter. The default value for the maximum length of a parameter that can be captured during correlation is 256 characters. To retrieve a string longer than 256 characters, use  web_set_max_html_param_len  to increase the maximum valid length. An attempt to save a string whose length exceeds the maximum length will fail
Read more

Error -27492: "HttpSendRequest" failed, Windows error code=12057 (certificate revoked) and retry limit (0) exceeded for URL="

This error occurs when using WinInet replay instead of sockets with Integrated Authentication enabled in run-time settings. The purpose of this was to allow vusers to use SSO with SPNEGO authentication in an IBM WebSEAL environment. After spending some time with the mystical HP level 3 support, they identified an undocumented flag which helps out significantly in this. So, instead of using the WinInet replay engine (which is not encouraged by HP) you should do something similar to the following. vuser_init() {             // Preferred run-time settings             // Browser -> Browser Emulation        // [ ] Simulate a new user on each iteration        // Preferences -> Options        // Enable Integration Authentication [Yes]             web_set_sockets_option("INITIAL_BASIC_AUTH","1");             web_set_user("DOMAIN.LOCAL\\username",                         "password",                         "s
Read more