Re: ORA-3113 Disconnected

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 11 May 2004 23:33:18 -0700
Message-ID: <1084343598.899249@yasure>

G Dahler wrote:

> "Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de
> news:1084284588.353108_at_yasure...
> 

>>Aaron wrote:
>>
>>
>>>Running 9.2.0.4 on Solaris, I try to do the following command (tried
>>>via many different approaches) and I get disconnected every time
>>>(ORA-3113):
>>>
>>>CREATE OR REPLACE TYPE FILE_NAMES AS VARRAY(5000) OF VARCHAR2(120);
>>>/
>>>
>>>This command runs fine on all my other installations, including one
>>>with exact same version o/s and database, and has run successfully in
>>>the past in this instance.
>>>
>>>Any ideas?
>>>
>>>Thanks.
>>
>>Confirm the kernel parameters in /etc/hosts are set correctly to
>>the values suggested by Oracle in the documentation.
>>

> 
> 
> /etc/hosts kernel parameters ?
> 
> Last time I checked, /etc/hosts was used by the networking resolver, not for
> kernel parameters !

My apology ... /etc/system.

I spent the previous two hours building 8 RAC nodes and had just finished editing /etc/host ... well ... 8 times.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed May 12 2004 - 01:33:18 CDT