Re: sqlplus core dump

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Tue, 7 Dec 1999 12:09:03 -0000
Message-ID: <944568712.19410.0.nnrp-10.c2de6f3d@news.demon.co.uk>

I've had exactly the same problem (on same config) and was eventually directed to the otrace/admin directory under ORACLE_HOME.

If you find here files ending .dat (regid.dat, collect.dat, facility.dat) then delete them and restart the instance and listener.

These files are used for some unstable utility (I can't remember what) that causes sqlnet crashes and core dumps.

Other hints and tips I was given :
Set the TWO_TASK env variable to the sid name to bypass MTS. Make sure the TWO_TASK env variable has not been set and ensure MTS is being used.

Deleting the .dat files seemed to work though (obviously the other pieces of sage advice did not !).

hth
NeilC.
Emmanuel Cortes wrote in message <384CD19B.245A567B_at_aries.fr>...
>I upgrade oracle 7.3.3.4 to 7.3.4.0.
>Now i have a lot of Core Dump of sqlplus on AIX 4.3.2 (F50 - H50)
>
>has anyone known something about this problem?
>
>thanks
>
>Emmanuel Cortes
Received on Tue Dec 07 1999 - 06:09:03 CST