Re: automatic shutdown/startup

Thanks for your suggestions. I have set the ora_nls33 environment variable and verified all settings referred to in both Notes mentioned below. However, the problem still persists. The problem is that I need the databases to shutdown and startup automatically when the server is rebooted. Are you saying that this just doesn't work? From what I've seen it's supposed to work for 8.1.7, but doesn't appear to all the time. I have startup and shutdown scripts that can be ran, however, the network admins may need to reboot while I'm not around and would prefer to not have to run a script. Any suggestions?

Thanks again,
Lynn

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0311181738.678cb8ce_at_posting.google.com>...
> 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
Received on Wed Nov 19 2003 - 17:36:31 CET