Re: sqlplus core dump

Neil Cudd wrote:
>
> 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

[Quoted] There are also times when it is necessary to rebuild the sqlplus executible. I've done this before but don't have the exact instructions any longer. You should be able to get them from oracle support. Received on Tue Dec 07 1999 - 15:51:46 CET