Re: HELP HELP : ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist

From: <sybrandb_at_yahoo.com>
Date: 9 Feb 2004 01:11:27 -0800
Message-ID: <a1d154f4.0402090111.d1a08a4_at_posting.google.com>


alter trigger log_errors_trig disable;

correct the errors
and
alter trigger log_errors_trig enable;

Sybrand Bakker
Senior Oracle DBA

tracykim10_at_yahoo.com.hk (tracy) wrote in message news:<5c91cce9.0402081744.417c4f8f_at_posting.google.com>...
> hi,
> I had only one servererror trigger as the result of sql:
> SQL> select trigger_name , owner, trigger_type, TRIGGERING_EVENT from
> 2 dba_triggers where TRIGGERING_EVENT like '%ERROR%';
>
> TRIGGER_NAME OWNER
> TRIGGER_TYPE
> ------------------------------ ------------------------------
> ----------------
> TRIGGERING_EVENT
> ----------------------------------------------------------------------------------------------------
> LOG_ERRORS_TRIG SYSTEM AFTER
> EVENT
> ERROR
>
> Now, users can log-in the forms , but cannot do any select, insert,
> delete or update. Pls advise!
>
> regrads,
> tracy
>
>
> "DBA Infopower Support" <support_at_dbainfopower.com> wrote in message news:<QZ-dnTool5Ht7rndRVn-hQ_at_comcast.com>...
> > Hello Tracy,
> >
> > Please check if you have only one servererror trigger. I have got similar
> > errors when duplicate similar "after servererror" trigger were in place.
> >
> > use below query to check:
> >
> > select trigger_name , owner, trigger_type, TRIGGERING_EVENT from
> > dba_triggers where TRIGGERING_EVENT like '%ERROR%';
> >
> > If more then one trigger exists, check what it is doing and drop ones with
> > duplicate functions.
> >
> > set long 32000
> > select TRIGGER_BODY from dba_triggers where trigger_name =
> > <trigger_in_question>
> >
> > Let us know if any additional help is needed.
> >
> > Regards,
> >
> > Support
> >
> > DBA Infopower
> >
> > https://www.dbainfopower.com
> >
> >
> >
> > The advice provided by DBA Infopower are provided "as is" with no warranty.
> > DBA Infopower expressly disclaims any warranty, regarding the advice
> > including any implied warranty of merchant fitness for a particular purpose
> > aviating course of dealing and/or performance. DBA Infopower does not
> > warrant that the advices provided by DBA Infopower will be free from bias,
> > detests, errors, eavesdropping or listening. DBA Infopower shall not be
> > responsible for the quality of information or the authentication of the
> > services or details given by experts on the advice. By using this advice the
> > user of the advice accepts the terms and conditions of this statement.
> >
> >
> >
> >
> > "tracy" <tracykim10_at_yahoo.com.hk> wrote in message
> > news:5c91cce9.0402061848.4805c083_at_posting.google.com...
> > > Hi,
> > > I forgot to desc the error message:
> > > 04045:erros during recompilation/revalidation of log_errors_trig
> > > 01031 insufficient priv
> > > 00932: inconsistent datatypes
> > >
> > > regards,
> > > tracy
> > >
> > > "DBA Infopower Support" <support_at_dbainfopower.com> wrote in message
 news:<J7CdnUs32ONM_L7dRVn-hg_at_comcast.com>...
> > > > Hello Tracy,
> > > >
> > > > Any DDL (like "create") would perform commit internally before and
 after
> > > > DDL ix executed - I.e. you can not rollback DDL.
> > > >
> > > > Looks like you run the script as user 'SYSTEM'. As a "sys" user issue
> > > > "grant select on v_$session to system;" This would resolve issue of
> > > > "ORA-00942: table or view does not exist".
> > > >
> > > > Please, let us know if this helps.
> > > >
> > > > Regards,
> > > >
> > > > Support
> > > >
> > > > DBA Infopower
> > > >
> > > > https://www.dbainfopower.com
> > > >
> > > >
> > > >
> > > > The advice provided by DBA Infopower are provided "as is" with no
 warranty.
> > > > DBA Infopower expressly disclaims any warranty, regarding the advice
> > > > including any implied warranty of merchant fitness for a particular
 purpose
> > > > aviating course of dealing and/or performance. DBA Infopower does not
> > > > warrant that the advices provided by DBA Infopower will be free from
 bias,
> > > > detests, errors, eavesdropping or listening. DBA Infopower shall not be
> > > > responsible for the quality of information or the authentication of the
> > > > services or details given by experts on the advice. By using this advice
 the
> > > > user of the advice accepts the terms and conditions of this statement.
> > > >
> > > >
> > > >
> > > >
> > > > "tracy" <tracykim10_at_yahoo.com.hk> wrote in message
> > > > news:5c91cce9.0402060057.3d6ca551_at_posting.google.com...
> > > > > Hi, I really need help.
> > > > >
> > > > > I run this script and error message appeal as below:
> > > > >
> > > > > drop trigger log_errors_trig;
> > > > > drop trigger log_errors_trig
> > > > > ERROR at line 1:
> > > > > ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist
> > > > >
> > > > > drop table log_errors_tab;
> > > > > drop table log_errors_tab
> > > > > ERROR at line 1:
> > > > > ORA00942: table or view does not exist
> > > > >
> > > > >
> > > > > create table log_errors_tab (
> > > > > error varchar2(30),
> > > > > timestamp date,
> > > > > username varchar2(30),
> > > > > osuser varchar2(30),
> > > > > machine varchar2(64),
> > > > > process varchar2(8),
> > > > > program varchar2(48));
> > > > >
> > > > > create or replace trigger log_errors_trig
> > > > > after servererror on database
> > > > > declare
> > > > > var_user varchar2(30);
> > > > > var_osuser varchar2(30);
> > > > > var_machine varchar2(64);
> > > > > var_process varchar2(8);
> > > > > var_program varchar2(48);
> > > > > begin
> > > > > select username, osuser, machine, process, program
> > > > > into var_user, var_osuser, var_machine, var_process, var_program
> > > > > from sys.v_$session
> > > > > where audsid = userenv('sessionid');
> > > > >
> > > > > insert into log_errors_tab
> > > > > values(dbms_standard.server_error(1),sysdate,var_user,
> > > > > var_osuser,var_machine,var_process,var_program);
> > > > > end;
> > > > > /
> > > > > WARINING: trigger created with compilation errors.
> > > > >
> > > > > SQL>roll back;
> > > > > Rollback complete.
> > > > >
> > > > > After that i got error message in my SQL:
> > > > > ERROR at line 1:
> > > > > ORA-04098: trigger 'SYSTEM.LOG_ERRORS_TRIG' is invalid and failed
> > > > > re-validation
> > > > >
> > > > >
> > > > > I check under user_objects & user_errors, result as below:
> > > > > 1 select * from user_objects
> > > > > 2* WHERE STATUS <>'VALID'
> > > > > SQL> /
> > > > >
> > > > > OBJECT_NAME
> > > >



> > > > --------------------------
> > > > > SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
> > > > > CREATED LAST_DDL_
> > > > > ------------------------------ --------- --------------
> > > > > ------------------ --------- ---------
> > > > > TIMESTAMP STATUS T G S
> > > > > ------------------- ------- - - -
> > > > > LOG_ERRORS_TRIG
> > > > > 47321 TRIGGER
> > > > > 06-FEB-04 06-FEB-04
> > > > > 2004-02-06:14:56:15 INVALID N N N
> > > > >
> > > > >
> > > > > SQL> select * from user_errors;
> > > > >
> > > > > NAME TYPE SEQUENCE LINE
> > > > > POSITION
> > > > > ------------------------------ ------------ --------- ---------
> > > > > ---------
> > > > > TEXT
> > > >


> > > > --------------------------
> > > > > LOG_ERRORS_TRIG TRIGGER 1 10
> > > > > 13
> > > > > PL/SQL: ORA-00942: table or view does not exist
> > > > >
> > > > > LOG_ERRORS_TRIG TRIGGER 2 8
> > > > > 2
> > > > > PL/SQL: SQL Statement ignored
> > > > >
> > > > >
> > > > > How can i fix this problem? I roll back after I run the trigger, why
> > > > > this still happened?
> > > > >
> > > > >
> > > > > Regards.
> > > > > tracy kim
Received on Mon Feb 09 2004 - 10:11:27 CET

Original text of this message