Re: ora-01034 and ora-27101 after reboot

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 Received on Tue Jun 24 2003 - 07:52:15 CDT