Re: Clues on instance failed to start?

From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1997/01/22
Message-ID: <5c5jsj$md8_002@news.psi.net>#1/1

In article <5c3pd2$eql_at_nntp1.u.washington.edu>,

lesliet_at_u.washington.edu (L. Tseng) wrote:
>Has this ever happened to you? what are the other intelligent
>ways to identify one mispelled init parameter name in your
>init.ora file?

here's something to try:

write a pl/sql procedure that uses the file_io package to read and write initX.ora by comparing its parameter names to those in v$parameter. you could use the procedure like this: SQL> exec set_parameter('sort_area_size','20000') you could return an exception when a given parameter name isn't found in v$parameter. if it's there, re-write the init file. god i love computers.

Dave Mausner, Managing Consultant, Braun Technology Group, Chicago. Received on Wed Jan 22 1997 - 00:00:00 CST