–The demo will cover how to create SQL Performance Investigator agents for monitoring and begin at the step of adding the Performance Investigator extension after the Foglight Oracle agent connection details has been setup.
–Applicable for both Simple and Advance types of Agent discovery methods
–For assistance with setting up the agent connection details configuration part, please consult videos How to create a Foglight Oracle Agent Using the Simple Mode or How to Setup Multiple Foglight Oracle Agents for Monitoring Using Advance Mode, depending on the deployment desire
•Prerequisites and requirements
–Instance connections are made through JDBC and the following needs to be valid as they are used to established DB connectivity to the monitored Oracle instance host:
–Valid resolvable/pingable hostname or IP
–Valid active connection port default 1521
–Valid Oracle SID or Service name as it exactly appears in the tnsnames.ora file
–Available user with sys credentials to run permissions script
–OS connections types:
–SSH, WinRM or WMI connections are needed for Operating System metric retrieval.
–If Using SSH, open port default 22
• Please review the Foglight for Oracle Permissions Guide, Hardware sizing Guide and Users Guide for additional requirements.