Re: automatic shutdown/startup

lynn344_at_cox.net (Lynn) wrote in message news:<cd7c2c1.0311180936.11de234_at_posting.google.com>...
> Does the ora_nls33 and NLSRTL33 environment variables need to be set
> when running Oracle 8.1.7 on a W2K machine? The ora-600 error refers
> to these and mine are not set. However, I've only seen references to
> them on NT, not W2K. My nls_lang environment variable is set
> correctly.

Yes, ora_nls33 needs to be set or you will get a character set mismatch.

Also see Note:114384.1 and Note:136214.1 on metalink. The solution is to have a script with oradim for starting up and shutting down, and don't try to run them automatically. I have one machine where I've crammed 9iAS and a database on there, and a shutdown abort takes an hour after a night of memory leaks. Oddly enough, no problem with the iasdb, just the higher version 9 database.

Also check %ORACLE_HOME%\database for an oradim.log

>
> Thanks,
> Lynn
> sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0311180039.4725602b_at_posting.google.com>...
> > lynn344_at_cox.net (Lynn) wrote in message news:<cd7c2c1.0311171242.4386d4cc_at_posting.google.com>...
> > > I'm running Oracle 8.1.7.4.1 on W2K and have the services for my
> > > oracle instances set to automatically startup and shutdown with the
> > > W2K server. Unfortunately, neither is working. Nothing gets logged
> > > in my alert file for the shutdown or startup, however, the databases
> > > are down and when I manually start them up, the alert log reveals a
> > > crash recovery. I've verified the settings in the registry for
> > > automatic shutdown and startup. I've done lots of searching and have
> > > seen where others have had the same problem, but have not found the
> > > solution. Any help would be geatly appreciated.
> >
> > At this stage the only way to get sensible responses is to post part
> > of the alert log and the oradim.log in %ORACLE_HOME%\rdbms
> >
> > Sybrand Bakker
> > Senior Oracle DBA

jg

--
_at_home.com is bogus.
http://www.theinquirer.net/?article=12727