Clues on instance failed to start?

From: Joel Garry <Joel.Garry_at_pebble.org>
Date: 1997/01/23
Message-ID: <66c_9701231522@pebble.org>#1/1

 LT> From: lesliet_at_u.washington.edu (L. Tseng)

 LT> On time, a DBA accidentally altered a letter on one of the 
 LT> init parameter name and as a result, the instance refuses
 LT> to start. The funny thing is that Orcale virtually says
 LT> nothing in its log file except a clueless 'instance failed
 LT> to start.' 

 LT> Has this ever happened to you? what are the other intelligent

 LT> ways to identify one mispelled init parameter name in your  LT> init.ora file?

I habitually keep the original file, and always put in a notation of what has been changed. Then a simple diff can be quite helpful, not much intelligence required, just obsessive-compulsiveness.

jg

--
Standard disclaimer: The views of this user are strictly his own.

Received on Thu Jan 23 1997 - 00:00:00 CST