Re: ora-01034 and ora-27101 after reboot

timbedford_at_hotmail.com (Tim Bedford) wrote in message news:<a411bafb.0306250615.2362f17b_at_posting.google.com>...
> drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0306240452.55ba8d6e_at_posting.google.com>...
> > linda_68_at_hotmail.com (sien) wrote in message news:<31d3e92a.0306232349.59647171_at_posting.google.com>...
> > > Hello!
> > >
> > > I have looked for the solution for this problem in this newsgroup and
> > > tried every possibility but it doesn't work yet.
> > > I install oracle enterprise edition 8.17 on windows 2000 server. The
> > > machine is pentium 4, 2GHz, 512 MB ram.
> > > I just have one database running on this server. Everytime I reboot
> > > the server and I try to connect to the database I get this error:
> > > ORA-01034: ORACLE not available
> > > ORA-27101: shared memory realm does not exist
> > > If I look at control panel/services, the database oracle service and
> > > the listener service are started.
> > > What I can do to be able to connect to the database is to start
> > > Database configuration assistant, select 'Change database
> > > configuration' option and click on next, next, finish.
> > >
> > > This is the init.ora
> > >
> --- snip ---
> > >
> > > Thanks a lot in advance.
> >
> > I'd guess that you have not installed the 8i Admin Assistant for
> > NT/W2K.
> > If you have, use it to "start the instance when the service is
> > started".
> > If you have not, edit the registry key:
> >
> > HKLM\SOFTWARE\ORACLE\HOME0\ORA_%ORACLE_SID%_AUTOSTART = TRUE.
> >
> > Also - might you be running the base release 8.1.7.0.0?
> > There is a known issue in that release that was fixed in 8.1.7.0.2.
> > If you have a metalink account, you can download the patchset.
> > I'd recommend using at least the 8.1.7.4.1 patchset, and apply the
> > 8.1.7.4.10 patchset if you can afford time for testing on another
> > server. Multiple security fixes are included in that patchset, but if
> > you use cursor_sharing = FORCE, do not apply 8.1.7.4.10.
> >
> > Btw - you're running in archivelog mode but do not have archiving set
> > to autostart?
> >
> > Pd
>
>
> I've had the same problem and its been doing my head in. What's the
> actual patch number that fixes this? Is seeing ORA-27101 related to
> Windows not giving an Oracle service enough time to shut down? I've
> been trying all kinds of automated shutdown setups and I always still
> get "crash recovery" in the alert log.
>
> Tim

Tim,

The patchset 8.1.7.0.2 included a fix for this. As far as your unclean shutdowns, did you reset the following:

HKLM\SOFTWARE\ORACLE\HOMEn\ORA_%ORACLE_SID%_SHUTDOWN_TIMEOUT = 300 HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout = 300000

Also, just to double-check, make sure that the following entry is set:

HKLM\SOFTWARE\ORACLE\HOMEn\ORA_%ORACLE_SID%_AUTOSTART = TRUE

I have not had a problem with this since 8.1.7.0.2.

hth,

Paul Received on Wed Jun 25 2003 - 12:01:43 CDT