Return
-
Title
foglight 5 installation error - Error checking Oracle status. -
Description
I received the below install error.
ERROR [QuartzScheduler.Monitor_Worker-2] com.quest.nitro.service.persistence.OracleDbMonitor - An unexpected error occurred which may cause undesired behavior. You may want to contact Quest Software customer support if you see this error again: Error checking Oracle status.
java.sql.SQLException: ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_STATS", line 4468
ORA-06512: at "SYS.DBMS_STATS", line 24597
ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
-
Resolution
The error indicates they did not run the 1st two FMS DB installation scripts ( oracle_drop_db.sql & oracle_create_db.sql) as user "sys as sysdba". This is documented in the install guide "Manual Database Configuration"