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

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
> >
> >
> >
>
>
Received on Tue Oct 30 2001 - 17:20:44 CST