Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: HELP HELP : ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist

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

From: DBA Infopower Support <support_at_dbainfopower.com>
Date: Fri, 6 Feb 2004 21:17:23 -0800
Message-ID: <QZ-dnTool5Ht7rndRVn-hQ@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 Fri Feb 06 2004 - 23:17:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US