How to add the PI extension to an Oracle agent (4226875)

How to add the PI extension to an Oracle agent

To add the PI extension to an Oracle database agent

1. Login to the Foglight console
   
2. Select one or more of the Oracle database agents
   
   
3. From the databases dashboard (Global View) click the Settings and then Administration link
   

   

   Click To See Full Image.

   
   

4. In the Administration panel, select SQL Performance Investigator in the panel.
   
   
5. Then choose one or more of the Foglight Agent Managers. Click the No SQL PI repository link
   
6. Review the licensing information and then click the Accept button
   

   Click To See Full Image.

   
   
   
7. Select the Agent Manager where the SQL PI agents will be created the Apply button
   

   

   Click To See Full Image.

   
   
   

8. Fill in the SQL Server connection details including the Server name (and instance name separated by a backlash if appropriate), the port (this is optional unless the default port of 1433 is not used), the connection type (SQL Server authentication or AD credentials), and the username & password. Then click the Next button
   

   

   Click To See Full Image.

   
   

9. Choose the radio button to either create a new SQL PI repository or use an existing PI repository.  Either use the default database name, primary file group, and transaction log location, or optionally enter a new value
   
   
10. Add a file directory location on the SQL Server instance to store 1m data. This folder must already exist on the server.
    
    
11. Click the Finish button
    

    

    Click To See Full Image.

    
    
    

12. Click OK to create the repository
    

    

    Click To See Full Image.

    
    
    

13. Select the checkbox for one or more of the Oracle agents to add the PI extension on, then click the Enable button
    

    

    Click To See Full Image.

14. After a few moments, the PI extension should be associated to the Oracle database agent
    

    

    Click To See Full Image.

To use PI repository in AlwaysOn Availability Group (AG):

1. Before adding a PI agent, create an Always On Availability Group (AG) and define a listener. This will require adding an existing database that is not the PI repository to the AG. Alternatively, you can choose an existing Availability Group.

2. Monitor sql server/Oracle/ssas agent and enable PI. Use the listener address of the Availability group as a database server for the PI repository and accept the default values for the database files location.

3. Once PI is enabled, run a full backup for the PI database created in step #2  and add it to the AlwaysOn Availability group created or chosen in step #1.

To add an existing PI repository database to an AlwaysOn Availability Group(AG):

1. Disable PI in database agents.

2. Remove PI agents.

3. Add the PI database to an AlwaysOn Availability Group.

4. Re-enable PI on the agents and use the existing database added to the availability group.

Notes: 

1. Choose “existing database” instead of “creating new”.

2. Use the listener address as the database server.

Video:

Please refer to the following video for details on adding the PI extension to an Oracle agent to connect to a SQL Server PI repository.