|
解决方法就是下边的这段,我看不懂555555555
Ensure that the Oracle client libraries are installed on the Controller or Tuning Console machine.
Verify that %OracleHome%\bin is included in the path environment variable. If it is not, add it.
Configure the tnsnames.ora file on the Controller or Tuning Console machine so that the Oracle client can communicate with the Oracle server(s) you plan to monitor.
You can configure connection parameters either manually, by editing the tnsnames.ora file in a text editor, or using the Oracle service configuration tool (for example, select Start > Programs > Oracle for Windows NT > Oracle Net8 Easy Config).
You specify:
a new service name (TNS name) for the Oracle instance
TCP protocol
the host name (name of monitored server machine)
the port number (usually 1521)
the database SID (the default SID is ORCL)
For example:
Note: Only the 32-bit Oracle client should be installed on the Controller or Tuning Console machine running the Oracle monitor. If you have a 16-bit and a 32-bit Oracle client installation on the controller machine, the 16-bit installation should be uninstalled.
Obtain a username and password for the service from your database administrator, and ensure that the Controller or Tuning Console has database administrator privileges for the Oracle V$tables (V$SESSTAT, V$SYSSTAT, V$STATNAME, V$INSTANCE, V$SESSION).
Verify connection with the Oracle server by performing tns ping from the Controller or Tuning Console machine. T
Note: here may be a problem connecting if the Oracle server is behind a DMZ/firewall that limits its communication to application servers accessing it.
Ensure that the registries are updated for the version of Oracle that you are using and that they have the following key: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
Verify that the Oracle server you want to monitor is up and running.
Note: It is possible to monitor several Oracle database servers concurrently.
Run SQL*Plus from the Controller or Tuning Console and attempt to log in to the Oracle server(s) with the desired username/password/server combination.
Type SELECT * FROM V$SYSSTAT to verify that you can view the V$SYSSTAT table on the Oracle server. Use similar queries to verify that you can view the V$SESSTAT, V$SESSION, V$INSTANCE, V$STATNAME, and V$PROCESS tables on the server. Make sure that the Oracle bin directory is in the search path.
To change the length of each monitoring sample (in seconds), you need to edit the dat\monitors\vmon.cfg file in the LoadRunner root folder. The default rate is 10 seconds.
Note: The minimum sampling rate for the Oracle Monitor is 10 seconds. If you set the sampling rate at less than 10 seconds, the Oracle Monitor will continue to monitor at 10 second intervals.
If a problem occurs in setting up the Oracle environment, view the error message issued by the Oracle server. |
|