Re: ora-01034 and ora-27101 after reboot

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 Received on Wed Jun 25 2003 - 09:15:36 CDT