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

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

>

>

>