Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Logon trigger not firing - solution
Paul Brewer wrote:
> "Lisa McGrath" <lmcgrath_at_uwsa.edu> wrote in message
> news:3DE263EC.1B6C1ADC_at_uwsa.edu...
> >
> > Thanks to everyone who gave us suggestions for our logon trigger
> > problem.
> >
> > The solution was commenting out a line in the init.ora file. That file
> > still had the line " _system_trig_enabled=false" being executed. Once
> > that was commented out and the database restarted the logon triggers
> > worked.
> >
> > Thanks again for the suggestions.
> >
> > Lisa
> >
> > --
> > Lisa McGrath
> > Lmcgrath_at_uwsa.edu (608) 263-4535
> > Office of Information Services
> > University of Wisconsin System Administration
> > --
> >
> Lisa,
>
> I'd recommend against using *any* parameters which start with an underscore
> unless you're absolutely sure what is going on.
>
> Regards,
> Paul
When the DBA applied a patch the instructions said to add that line to the init.ora file. He just forgot to remove the line after the patch was installed. We don't normally mess around with any undocumented stuff.
Lisa Received on Mon Nov 25 2002 - 15:17:02 CST