Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT! shared memory realm does not exist

Re: URGENT! shared memory realm does not exist

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Thu, 22 May 2003 11:53:38 -0700
Message-ID: <3ECD1CB2.EF891514@exxesolutions.com>


Sybrand Bakker wrote:

> On 22 May 2003 10:39:15 -0700, drak0nian_at_yahoo.com (Paul Drake) wrote:
>
> >"elziko" <elziko_at_NOTSPAMMINGyahoo.co.uk> wrote in message news:<3ecc8cf1$0$12999$afc38c87_at_news.easynet.co.uk>...
> >> I have an Oracle server running (Personal Edition 8.1.7) and on that I'm
> >> using two databases. When my machine starts up I try and access one of the
> >> databases and I get the following error:
> >>
> >> ORA-0134: ORACLE not available
> >> ORA-27101: shared memory realm does not exist
> >>
> >> Some times this happens for both my databases, sometimes just for one of
> >> them, sometimes for both.
> >>
> >> I have absolutely no idea why this is happening but from looking around in
> >> Google if I:
> >>
> >> Run: svrmgrl.exe
> >> Then I type: 'connect internal' followed by the password.
> >> Then: 'startup open'
> >>
> >> This causes both databases to startup again just fine. However, this machine
> >> is going to a client as a demo and it will be restarted often! How do I
> >> solve the above problem without having to resort to svrmgl.exe every time?
> >> This is really urgent!
> >
> >known issue in 8.1.7.0.0 on win32.
> >what patchset are you running?
> >I'd recommend that you apply the latest full patchset (8.1.7.4.1)
> >after thoroughly reading the readme.htm for that patchset.
> >
> >check that the service is set to automatic.
> >check that the instance is set to start when the service is started.
> >
> >Pd
>
> The OP is using *Personal* Oracle. so: NO services at all, and AFAIK
> only *1* (ONE) single database. He is not going to resolve this.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

From my experience this is sometimes the result of: 1. Incompatibility between the Oracle install and the operating system 2. Problem with Oracle Services that can be solved with oradim by deleting the existing service and creating a new one with the same name.

I'd suggest checking both before throwing in the towel.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu May 22 2003 - 13:53:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US