How to Create Foglight Oracle PI agents for monitoring (4227370)

To create a new Oracle database agent with SQL Performance Investigator monitoring

1. Login to the Foglight console
2. From the databases dashboard (Global View) click the Monitor button, then Oracle. 
3. Fill in the Connection Details, either a TNS file can be used to populate the connection information or the Host and Port information can be manually added along with the Service Name or SID. Then specify the Username and Password, as well as if SSL is used.
4. Configure the LISTENER, Sensitivity Level, and agent name if desired.
5. Then click the Operating System entry
6. Add the OS connection information with the connection type, userid, and password details, a stored login can be used if an agent used the same credentials was previously configured and added to the lockbox. Then click the OK button
7. Update the VMWare connection information if desired
8. Click the SQL PI checkbox or entry
9. Accept the licensing agreement
10. Select the Foglight Agent Manager (FglAM) where the SQL PI agents will be created
11. Fill in the SQL Server connection details where the SQL Server instance used as the SQL PI repository will be located, and then click the Next button
12. Choose the radio button to either create a new SQL PI repository or use an existing PI repository.  
13. Either use the default database name, primary file group, and transaction log location, or optionally enter a new value
14. Add a file directory location on the SQL Server instance to store 1m data. This folder must already exist on the server.
15. Click the Finish button
16. Click OK to create the repository
17. Click Monitor to begin creating the new agent
18. Click the button to either Add Another Database or Close the dialog when the agent creation process completes.
19. The new agent should now be created and after a few minutes data should be visible in the databases dashboard.
    
    

The following video details how to create a Foglight for Oracle agent with Performance Investigator (PI) monitoring.