How to Upgrade Foglight Cartridge for Oracle to Version 5.7.5.X Converting Foglight Oracle PA ?Integrated Agents into the Foglight Oracle? SQLPI Extension
This video is applicable for Foglight 5.6.11, 5.7.1, and 5.7.5
Once you have extracted the DB_Oracle 575.car file locally to your desktop, access and login to the Foglight console.
Click on databases for reference
Notice that the Foglight Oracle PA integrated agent is displayed signified by the PA enabled flag indicator. When the upgrade concludes the indicator should update reflecting to SQL PI.
To install the cartridge proceed under Dashboards | Cartridges | Cartridge inventory
click on install cartridge and browse to the directory until the extracted DB_Oracle5751.car file is located and select it. Click open and install cartridge.
The installation process will initiate. Below left corner shows the install status. The procedure may take a few minutes to complete. When the operation has finished a successful completion message will popup. The cartridge has successfully updated superseding the previous version acknowledged by a green check mark next to its corresponding components.
Next step is to upgrade the Foglight agent manager Domain and Oracle agents. To progress the upgrade click on databases and the process will either continue directly to the upgrade wizard or revert to the databases dashboards where a Clickable upgrade button should display to enter the upgrade wizard. Click the upgrade button to enter the upgrade wizard if this occurs.
Select Foglight for Oracle cartridge domain to upgrade. What’s new in this version is specified at this point in the upgrade wizard. Please take some time to review those items prior to progressing,
The following screen shows all the Foglight agent managers associated with Foglight Oracle agents needed for upgrade. Select all and Click on upgrade the Selected Agent managers to begin the process. The operation shall begin to upgrade the foglight agent managers and discovered Oracle agents. When the process is complete, the Foglight agent manager status will display a green indicator and the Foglight Oracle version should change to 188.8.131.52 reflecting the upgrade operation success. Click next.
In the validate connectivity panel. It’s always good practice to validate connectivity checking for any new elevated permission required in this version. Select the agents and click validate connectivity.
If an insufficient privileges status displays, there are two options to execute the grant privileges script that requires a sysadm user to run. One option is to click on view script located in parentheses bottom left. Copy the script and run it in the database with a sysadm user against the foglight database user, then validate connection again. Or click on insufficient privileges, and a box pops. Supply a sysadm user to execute grant scripts and click grant. The grant process starts updating the database user with the necessary credentials.
Once the validation is successful with connection validated click next.
The following screen will convert any Foglight Oracle/ PAO integrated agents over to Foglight Oracle SQL PI. This step is not applicable to Non PA integrated agents. Foglight Oracle PA Oracle Integrated agents are shown with a green indicator under status.
To begin the SQL PI update, click on Assign SPI Repository. A banner pops up with a brief overview on SQLPI, license information and where to address related concerns. Acknowledge reviewing the material by clicking accept.
A dialogue box displays revealing PI repository details and also showing a list of agent managers. Review the hypertext link hardware sizing guide prior to proceeding with the update. Also follow the recommendations when selecting an Agent manager to assign the PI repository to.
The list of agent managers shown with a gear icon are candidates to have a PI repository created there. Clicking the gear will allow to change the repository installation location and port. Agent managers presented with a green checkmark are hosts with existing PI repositories, including any configured for Foglight SQL Server SQLPI agents.
Select the agent manager of choice that meets the requirements and click apply.
Click update and the PI repository setup or creation commences
For the agent managers selected that fails to meet the resource requirements another box will pop up indicating with some options
Once the update is done, repeat the process if there are more agents that needs updating. Notice the new indicator for SQL PI after the update and the listed PI repository for the agent. Click next for the success banner. At this point the install and upgrade has been completed. Click finish to view the agents in the corresponding databases dashboards. The new SQL PI indicator reference will also be prominent there.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책