Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Failed Logon Trigger on DATABASE
Raymond wrote:
> I am playing around with trigger (luckily in a test machine) and now cannot
> login anymore (even sys). Could anyone help me to resolve the problem.
>
> Using 'user1' account, I defined a DDL trigger for logon to log all user's
> logon:
>
> CREATE OR REPLACE TRIGGER all_user_logon
> AFTER LOGON ON DATABASE
> BEGIN
> INSERT INTO scott.user_session_log (user_log_id, username,
> action_type,action_dt)
> VALUES (user_log_id_SEQ.NEXTVAL, USER, 'LOGON', SYSDATE);
> END;
>
> Unfortunately, I forgot to grant 'user1' insert right for scott's table and
> the above trigger always fails whenever someone logon (including SYS). Now
> I got this error whenever I try to logon with iSQLPLUS and the logon attempt
> fails:
>
> ERROR:
> ORA-00600: internal error code, arguments: [4406], [0x67B7F044],
> [0x67B7F420], [], [], [], [], []
> ORA-00600: internal error code, arguments: [17034], [0x31C3274], [0], [],
> [], [], [], []
>
> Is there anyway to disable the trigger without logon?
you could try to set temporary in your init.ora :
_system_trig_enabled=false
also, check the list of fixed bugs
regards
s.kapitza Received on Wed Jul 06 2005 - 05:49:40 CDT