The log in particular I would start looking at is in the
<OracleHome>\RBDMS73\trace\"<instance name>alrt.log" This has a lot of detail as to
when processes
start and stop, errors in log files, corrupt data files, etc. The Event
log also show when the service stops, etc. This should be a no-brainer
for your DBA. That's why they make the big bucks... or so they keep
telling us. ;)
Russ Braaten, MCSE MCP+I
> what do the oracle logs say? the oracle dba should be able to tell you when
> it stopped and why... mayhap there is something he doesn't want to face...
> i had to scrap our NT/oracle box... i know there are some lurkers out there
> who might be able to give you more detail... and i also know there are lots
> of trace/audits you can enable.
>
> ask the dba what he can do to monitor the db and instance to help in
> determining a cause.
>
> ===========================================
> Lerone Streeter
> System Analyst
> Abbott LBG
> [EMAIL PROTECTED]
> ===========================================
>
> -----Original Message-----
> From: Doug Lott [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 04, 2001 11:26 AM
> To: NT System Admin Issues
> Subject: Oracle just Dies on NT 4 sp6a
>
>
> We have eight NT4 sp6a servers running Oracle where Oracle just dies.
> That is Tivoli reports the srvice for Oracle is stopped. When checked it
> is stoppped and there are no errors in any eventlog nor in any Oracle
> logs. The Oracle DBA and myself are stumped. We cannot find any errors
> or records of any recent changes to the systems. These problems were
> noticed about In the past three months or so ago.
>
> Four serveres are running Oracle 7.3.4 and the other four are running
> Oracle 8.1.6. Each week at least one of them drops out (the Oracle
> service that is). A server may run for a month or two before the Oracle
> service stops. Some servers are in Dallas and some are in NY. All have a
> similare frequency of failure and it happens at various times of day.
>
> Has anyone experienced this? Or have any ideas where we can start looking
> or what we can monitor? Technet and Oracle knowledge bases do not seem to
> record any thing similar.
>
> Thanks in advance
>
> Doug.
>
> http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
