Re: monitoring a database

Michael Scheinost wrote:

> Yes, I checked it. But nothing was written into it (at least at that
> time range I'm interested in).
>
> >>>>>>>>>>>>>>>>>> Ursprüngliche Nachricht <<<<<<<<<<<<<<<<<<
>
> Am 03.08.2000, 20:24:21, schrieb "Klaus Zeuch"
> <KZeuch_at_nospamhotmail.com> zum Thema Re: monitoring a database:
>
> > Hi,
 

> > did you check the alert file (sidalrt.log, e.g. orclalrt.log)?
 

> > Klaus
> > "Michael Scheinost" <mis_at_bestwestern.de> schrieb im Newsbeitrag
> > news:20000803.14483652_at_mis.configured.host...
> > Hi,
 

> > we are using Oracle 8.0.5.1 under Linux that runs two instances. One
> > instance is permanently used by WebObjects (Apple, under Solaris 7).
> > The other database is used by a crs (customer relationship). The
> > database which feeds the WebObjects is up 24/7.
> > Now we have the problem that every one or two weeks oracle and
> > webobjects loose connection. The logfile of webobject reports:
> > GeneraAdaptorException: ORA-00911: invalid character
>

You could try to insert the follwing entry in your init.ora event="911 trace name errorstack level 3" I would test this before on a test machine.

Hope this helps
Stefan

>
> > The Linux system seems to be very stable all the time and doesn't
> > report anything important in its logs.
 

> > What I want to know is: is there a possibility to verify ORA-00911 on
> > the oracle side? I can't see that oracle creates any log files. Is
> > there a posibility to monitor the oracle database 24/7 so I can see if
> > oracle recognizes that something is going wrong?
 

> > TIA, Michael Scheinost
Received on Thu Aug 03 2000 - 00:00:00 CDT