DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-04098: trigger 'APPS.LOGON_TRIG' is invalid and failed re-validation

Hybrid View

  1. #1
    Join Date
    Mar 2010
    Posts
    35

    Question ORA-04098: trigger 'APPS.LOGON_TRIG' is invalid and failed re-validation

    Hello Dear All,

    i am getting this following error in my alert log file of 11i applications database.
    "ORA-04098: trigger 'APPS.LOGON_TRIG' is invalid and failed re-validation"

    According to the Metalink (ORA-04098 Trigger '%s' Is Invalid and Failed Re-validation [ID 1035837.6])..

    I recompiled

    SQL> alter trigger logon_trig compile;
    Warning: Trigger altered with compilation errors.


    It compiled with Error

    SQL> show errors trigger logon_trig;
    Errors for TRIGGER LOGON_TRIG:

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    2/1 PL/SQL: SQL Statement ignored
    2/13 PL/SQL: ORA-00942: table or view does not exist

    Here is my dought..

    From the above result there is a table is missed from the compiled trigger was dropped. is it so,, then i have to run CATALOG and CATPROG to recreate all the default trigger and view.

    Ok fine,, i suppose to run those scripts, but my drought is.. my Application have lot of customization updates day by day, and some users creates Triggers and all,,

    If i run Catprog it will recreate the default "TRIGGERS". then what will happen to the user created TRIGGERS.. it will be there or not !
    Kindly help me

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Would you mind in identifying the missing table or view?
    Is it a sys/system table or view or is it an user table or view?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Mar 2010
    Posts
    35

    Smile Table missing .. its belongs to APPS schema

    its a Missing Table,, which is taking some value from "LOGON_TRIG" Trigger...


    here am going to Post the Trigger:

    DROP TRIGGER APPS.LOGON_TRIG;
    CREATE OR REPLACE TRIGGER APPS.logon_trig
    AFTER LOGON ON SCHEMA
    BEGIN
    INSERT INTO log_trig_table(user_id, log_date, action)
    VALUES (USER, SYSDATE, 'Logging on');
    END;
    /


    This Trigger Belongs to APPS schema.
    I highlighted the Trigger affecting table,, that table is missing i hope,,

    now if am running catprog.sql it may create those table, but if i ran that,, it will affect other triggers which created by my developers..(COUSTOM TRIGGERS)..

  4. #4
    Join Date
    Mar 2010
    Posts
    35

    Talking i found the solution

    i found the solution

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by 4iappsDBA View Post
    i found the solution
    Wouldn't be nice to share with the community?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Mar 2010
    Posts
    35

    Talking Disable

    alter trigger APPS.LOGON_TRIG disable;

    Once u disable it wont notify it in Alertlog file, at the same time if u down the server and restart ,, again the same error will raise..

    till now i dint found any permanent solution for this ...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width