Re: SHared REALM Memory ....... ORA817R3

Crikey! 8.1.7 on 64Mb is pushing it a bit (as you discovered). You'll love 9i -the recommendation is for 512Mb!!

If this is a test platform -and I sincerely hope that's all it is!! ;-) -, I'd strongly recommend rushing out and purchasing enough RAM to push you up to 256Mb. Here in Australia that's selling for a crazy $55 or so. Makes things much more workable, even when just testing.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Schemrooster" <WAGates_at_Microsoft.com> wrote in message
news:3bdf36af$0$1541$e4fe514c_at_newszilla.xs4all.nl...


> Howard,

>

> Thanx for your quick response. After inserting another 64Mb the problem

was


> solved. (Even manually stopping and starting services is working) It's

> running ok now on 128Mb.

>

> Thanx for your reply,

>

> Peter

> "Howard J. Rogers" <howardjr_at_www.com> wrote in message

> news:3bdf34e5$0$3561$afc38c87_at_news.optusnet.com.au...

> > I think that error usually indicates that the service hasn't started, or

> > (rather more precisely) that the service has not *completed* its startup

> > routine.

> >

> > Certainly, I can simulate the same error by (a) stopping my 817 service

> then

> > (b) restarting the service but (c) immediately issuing the connect / as

> > sysdba command in a SQL Plus session -i.e., without waiting for the

> service

> > restart to finish.

> >

> > The question would therefore really boil down to what happens when you

> > manually restart the service (and I'm talking about the

> "OracleServiceXXXX"

> > one).  Does it restart without a problem?  Does it keel over?  What does

> the

> > alert log record if it does keel over?

> >

> > The database creation assistant does its stuff by re-starting instances,

> so

> > I think in future, if it happens, just try doing that directly with the

> > services applet, and seeing what happens.

> >

> > How much memory does this box have, by the way?  And what settings for

the


> > various bits of the SGA did you have when the problem first materialised

> > (its possible the assistant set them back to smaller defaults, and thus

> > allowed things to start again).

> >

> > Regards

> > HJR

> > --

> >

> > Oracle Resources : http://www.geocities.com/howardjr2000

> > ========================================

> >

> >

> > "Schemrooster" <WAGates_at_Microsoft.com> wrote in message

> > news:3bdf3274$0$1507$e4fe514c_at_newszilla.xs4all.nl...

> > > Hi there,

> > >

> > > Sorry if this question was posted already, but i wasn't paying much

> > > attention.

> > > I have a problem with ORACLE 8.1.7. on W2K

> > >

> > > I have a "standard" Database created on my server, and everything went

> > > smoothly. But after 13 days I got the message "Shared Realm Memory

> doesn't

> > > exist, ORACLE not available" when i tried to connect with SQL_Plus.

> > >

> > > Rebooting the server had the same result... Nothing

> > >

> > > After I started the Database creation tool and said "Edit" and changed

> > > nothing, but went through all the screens, ORACLE was up and running

> > again.

> > > Can someone please explain this to me? I'm puzzled.

> > >

> > > Thanx in_at_vance

> > >

> > > Peter

> > >

> > >

> > >

> >

> >

>

>