I want to thank everyone who replied. Everyone suggested checking shared
memory but that was not our problem.
Bryan Fredrick came up with the correct solution. Upon following his
sugestion, we were able to restart Oracle. His reply is below:
Look at the files $ORACLE_HOME/otrace/admin/*.dat. If they are getting
large,
you have the problem we experienced.
With 7.3 release, Oracle added a bunch of new optimizer code that they
acquired
from DEC when they bought RDB. One of the neat features of this (completely
undocumented, of course) is that ORACLE Trace is turned on when you install.
This gathers information about SQL optimization, stores it in the SGA, and
conviently saves it in the $ORACLE_HOME/otrace/admin files process.id and
regid.dat. Eventually, the data gets so large that you're unable to allocate
any more memory to save additional information. Once that happens, you
will be
unable to start a new server, 'cuz it tries to load up the same garbage
from the
fore-mentioned files when it starts up. Gives you an error just like you've
gotten. The trick is to turn off ORACLE tracing, but setting the environment
variable:
EPC_DISABLED=TRUE
This must be set anytime you start the server (ie system startup, backups,
manual startup, etc.) otherwise the oracle starts saving more tracing data.
Before you can start a new server you need to go to $ORACLE_HOME/otrace/admin
directory and get rid of the *.dat files. There is a oracle utility that
makes
a default version of these, but I believe just 86-ing them will solve the
problem.
Ok, I remember the name of the Oracle utility to make a start-over copy of
the
$ORACLE_HOME/otrace/admin files, it's called otrccref and it's in
$ORACLE_HOME/bin. Just run it and it will make clean process.dat and
regid.dat
files.
Regards,
Mike Ferris
******************************************************************
Technical Operations Manager
ShareLine Systems Ph: (506) 858-9191
55 Highfield St. Fx: (506) 855-0004
Moncton, New Brunswick email : mike_at_pps.ca
Canada E1C 5N2
http://shareline.com/
******************************************************************
Received on Mon Feb 09 1998 - 22:29:51 NZDT