DX Unified Infrastructure Management

 View Only
  • 1.  ORA 00942 Error on data_engine logs

    Posted Jul 31, 2020 02:50 PM
    Hi All,

    Can someone please help me to fix the issue,

    Issue: ORA 00942 in data_engine logs

    Discription: Data engine showing in green but when we checked on data engine logs we are getting ORA 00942 table and view does not exist.

    We have informed to our Oracle DBA team but from that side no issues happening. All is working fine from DB side.

    Could someone involve and help to resolve the same.


    Thanks


  • 2.  RE: ORA 00942 Error on data_engine logs

    Broadcom Employee
    Posted Jul 31, 2020 02:52 PM

    Sounds like someone deleted a table such as an RN table or DN or HN table.
    These should never be deleted.
    what table or view is it saying is missing exactly.
    Might have to see if you have it in a back up to restore.
    Or if the table is there and corrupt might have to create a new database.



    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: ORA 00942 Error on data_engine logs

    Posted Jul 31, 2020 03:02 PM
    Hi Gene,
    No one deleted and all.
    Can you help me to check backup.
    Where we can get it.
    Please help


  • 4.  RE: ORA 00942 Error on data_engine logs

    Posted Jul 31, 2020 03:16 PM
    what version of data_engine? 
    by the way Gene's guidance is based on past experience with that same error.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 5.  RE: ORA 00942 Error on data_engine logs

    Posted Jul 31, 2020 03:28 PM
    Hi David,

    data engine version is 9.02

    Thanks


  • 6.  RE: ORA 00942 Error on data_engine logs
    Best Answer

    Posted Jul 31, 2020 03:36 PM
    Then recommend updating toThen recommend updating todata_engine_9.02_HF3.zip data_engine_9.02_HF3.txtathttps://support.broadcom.com/external/content/release-announcements/CA-Unified-Infrastructure-Management-Hotfix-Index/7233

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 7.  RE: ORA 00942 Error on data_engine logs

    Posted Jul 31, 2020 03:38 PM
    just noticed you have a case open on this so not going to duplicate effort and will leave it to the case owner.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 8.  RE: ORA 00942 Error on data_engine logs

    Posted Jul 31, 2020 03:48 PM
    Does it feasible for Oracle?
    As I checked the data engine 9.02HF3 for MySQL environment...