FMS logs "ORA-04098: trigger 'SYS.XDB_PI_TRIG' is invalid and failed re-validation" (4324680)

立即与支持人员聊天

获得即时帮助
完成注册

登录

请求定价

联系销售人员

反馈已提交

本文是否解决了您的问题？

选择评级

标题

FMS logs "ORA-04098: trigger 'SYS.XDB_PI_TRIG' is invalid and failed re-validation"
说明

We're trying to determine why we see these messages in our Foglight Management Server (FMS) logs:

An error occurred while truncating table obs_metric_scalar_0108: java.lang.RuntimeException: java.sql.SQLException: ORA-04098: trigger 'SYS.XDB_PI_TRIG' is invalid and failed re-validation"
原因

This issue is due to the Oracle setup. Foglight is just trying to truncate one of its own tables and the Oracle DDL triggers are interfering.

Appears that someone may have mistakenly installed in the SYS schema by performing the Foglight script installations as user SYS rather user Foglight. When Foglight was installed, the first two scripts are run a user 'sys', then remaining two run as user 'foglight.
NOTE: These of course wipe out any existing database as they reinitialize/create the database.

USER 'SYS'
<foglight_home>/scripts/sql/oracle_drop_db.sql
<foglight_home>/scripts/sql/oracle_create_db.sql

USER 'FOGLIGHT'
<foglight_home>/scripts/sql/oracle_create_schema.sql
<foglight_home>/scripts/sql/oracle_populate_db.sql
解决办法

Suggested resolution was to remove the Foglight installation and perform the correct steps to initialize/populate the back-end database. Some of the configuration can be saved by exporting before removing the FMS installation, then importing this information into the new installation.
One can export any custom dashboards, rules, registry variables before performing the uninstall, then reimport the exported text files. Exporting custom dashboards SOL39370
Below is an example procedure where I modified step 5 for a uninstall/reinstall. The CAVEAT about Catalyst rules doesn't apply since you will be importing into essentially the same hostname FMS.
See SOL46240
Export/Import Rules PROCEDURE:
CAVEAT: The Rules export file will contain 'Catalyst' rules which are specific to the original FMS. If one is attempting to import ALL the rules from an exported file into another FMS of a different name, these 'Catalyst' entries should be edited/removed from your final version rules file before importing . Also, the installed cartridges on the target server MUST match the cartridges installed from the source FMS.

1) Access the jmx-console and login with foglight user and password:
http://<your_fms>:<port>/jmx-console/

2) Scroll down to service=import/export and select

3) Search this page for void exportRulesToFile(); enter the Rules filename desired in the ParamValue field & select Invoke.
(this saves the file in %FGLHOME% on the Foglight Management Server (FMS) )

4) Search the same page for void exportRegistryVariablesToFile() - enter the Registry filename desired in the ParamValue field & select Invoke. (file saved in same location as step 3)

5) Move your exported files to a 'safe' directory outside of $FGLHOME and then Uninstall/Reinstall your FMS. Install all the same cartridges as existed previously.

6) Move your exported files to $FGLHOME and Import the registry and/or rules file via the jmx-console | service=import/export |void importFromFile(). Enter the registry or rules filename in the ParamType field and select Invoke.

反馈已提交

本文是否解决了您的问题？

选择评级

Request a KB Article

建议的内容

产品：: Foglight
5.5.8, 5.5.5, 5.5.4.1, 5.5.4, 5.5.2, 5.5

主题：: Troubleshooting

文章历史记录：: 创建时间： 2/24/2011
上次更新时间： 5/7/2023

搜索所有文章

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

FMS logs "ORA-04098: trigger 'SYS.XDB_PI_TRIG' is invalid and failed re-validation" (4324680)

标题

说明

原因

解决办法

Leave a Comment