-
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
-
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.
-
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)..
-
i found the solution
-
Originally Posted by 4iappsDBA
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|