Re: Error 1110?

From: Rich Goldkamp <rich_goldkamp_at_my-deja.com>
Date: Mon, 20 Mar 2000 14:00:20 GMT
Message-ID: <8b5atc$b3l$1@nnrp1.deja.com>

I am seeing the same ORA-01110 error occurring only in one instance (8.0.5 on NT 4 SP 5). Here's the alert log text.

Fri Mar 17 21:21:38 2000
Errors in file E:\LLG\trace\ORA00355.TRC: ORA-01110: data file : ''
Instance terminated by CKPT, pid = 438

The only other clue is a rather benign SQL statement identified in the trace file.

• SESSION ID:(22.1007) 2000.03.17.21.21.36.921
• 2000.03.17.21.21.36.921 ksedmp: internal or fatal error ORA-01110: data file : '' Current SQL statement for this session: INSERT INTO MIP_EQUIP_DIM VALUES (:1,:2,:3,:4,:5)

Since the 1110 error failed to identify the datafile, I cross-ref'd the table in the SQL statement to its datafile and did a dbv. The file checked out cleanly.

Any ideas???

TIA,
Rich
In article <8EEA55CF6krachynec_at_204.50.1.43>, krachyn_at_evansconsoles.com (Ken Rachynski) wrote:
> Good day,
>
> I just had a problem with one of my instances shutting down with an
error
> 1110. Searching my Oracle documentation turns up nothing about this
error
> (unless I'm looking in the wrong places). The full text of this error
> message from my alert log is:
>
> Instance terminating due to error 1110
> Instance terminated by CKPT, pid = 223
>
> I am running 8.0.4.0.0 on NT 4 (SP3).
>
> Can anybody tell me what this error is supposed to mean?
>
> Thanks in advance.
>
> --
> Ken Rachynski
> Database Analyst
> Evans Consoles
> http://evansonline.com/
>

--
Rich Goldkamp, Consultant, OCP RJGoldka_at_dcss.com Digital Consulting & Software Services (504) 523-5005 x2736 --
Rich Goldkamp, Consultant, OCP RJGoldka_at_dcss.com Digital Consulting & Software Services (504) 523-5005 x2736

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 20 2000 - 08:00:20 CST