Environment Overview: LoadRunner 9.0 sitescope 9.0 Windows 2003 Oracle Database 10g
1. Use the monitoring engine that comes with LR
1. 1. Install the Oracle client on the LR ControllerThis step does not need to be said. Install setup directly, and the installation will be OK. 1. After installation, configure net configuration assistant. Remember the configured service name. If the configuration is successful, the connection... test is successful. 2. Connect with sqlplus to see if the connection is successful. Open sqlplus and enter the Oracle username and password and host string. Check whether the logon is successful.
1. 2. Add Oracle counters3. After successfully logging on, open the controller of LR. Select oracle in the available graph, click Add measurements, and then click Advanced, as shown below: We use LR native monitors here. 4. In the monitored server machines area, add the IP address of the Oracle server. 5. Click Add in the resource measurements on: IP area. The pop-up dialog box is as follows: 6. Enter the corresponding information. Here, orcl is the service name configured in net configuration assistant. 7. Click OK. here we can see that the Oracle counter can be added, as shown below:
2. Use the sitescope EngineYou do not need to configure net configuration assistant. 1. Select sitescope In the first choose monitor engine, and click Add in the monitored server machines area as follows: You can select the local or other machine's sitescope here, if the account authentication is enabled for sitescope, enter the username and password. 2. In resource measurements on: IP, click Add. The displayed dialog box is as follows: 3. Enter the information. Click OK as follows: Now you can monitor oracle.