Re: Oracle Issue Report

CS wrote:

> DA,
> This is from an 8.17 script
>
> oradim -new -sid MYDB -startmode manual -pfile
> D:\ORACLE\ora81\database\initMYDB.ora
> ...
> oradim -edit -sid MYDB -startmode auto
>
> The newbie
> CS
>
> "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3E668F05.7C6CFF57_at_exesolutions.com...
> > Just got done solving a very nasty little problem with 9.2.0.1.0 on
> > Win2K and thought I'd let everyone know as apparently no similar problem
> > has been previously reported.
> >
> > 9:00pm last night Oracle had a normal shutdown as evidenced on-screen
> > and in alert, trace, and log files
> >
> > This morning about 12 hours later startup resulted in a core dump and an
> > alert log none of which indicated a specific problem.
> >
> > Attempting to log in returned a message that startup/shutdown was in
> > progress.
> > Attempts to shutdown and restart all resulted in numerous non-specific
> > error messages.
> > One of which led me to the registry where the NLS_LANG parameter was
> > converted to 'NA' in three entries.
> > Fixed those rebooted no change.
> > Sent Oracle support the alert log and core dump and they could identify
> > nothing and found no similar reports
> > Finally solved the problem by using oradim to drop and recreate the
> > service.
> >
> > What is critical and has not apparently been previously documented is
> > that when using oradim with 9i
> > to recreate Windows services ... when it asks for pfile it means the
> > initSID.ora ... not the spfile.ora.
> >
> > Thought some of you might want to know in case you ever need it.
> >
> > Daniel Morgan
> >

It is also the same in 9.2. But the documentation all over metalink, otn, etc. is not at all clear.

Not just to me ... also to Oracle's support staff.

Daniel Morgan Received on Thu Mar 06 2003 - 10:34:17 CST