Before you monitor Oracle, ensure that the following requirements have been met:
- Oracle Net (part of Oracle Net Services) client software is installed on the machine on which you run
Performance Explorer.
- The Oracle client must be a 32-bit version, must have DB administrator permissions and be able to recognize the targeted database
server.
- The relevant project attributes have been changed accordingly for your Oracle installation (choose
).
- SQL*Plus is available on the machine on which you want to run
Performance Explorer.
- Log on using the specified user name, password, and server information and perform the query
SELECT * FROM V$SYSSTAT.
If the logon attempt is successful, the environment is most likely set up correctly.
If the logon attempt fails, you can judge from the error messages generated by SQL*Plus what caused the problem.