Re: "Oracle not available" and "Shared memory realm does not exist".

Hi Gamaz,

OK, how are you trying to connect in order to startup the database ? The service from what you say appears to be started but the instance has not (note the ORADIM utility has a startup option to automatically start the instance with the service)

You need to connect into SQLPLUS as a sysdba either by sqlplus "/ as sysdba" or sqlplus "bowie/password as sysdba" where user bowie has previously been granted sysdba privileges.

You will then be connect to an "idle instance" from which you can issue the startup command

Any attempt to connect without first starting up the instance will get you your error.

Good Luck

Richard
"gamaz" <gamaz_at_earthlink.net> wrote in message news:fnmv9.401$V15.49756_at_newsread2.prod.itd.earthlink.net...
> Hi Richard,
> As per your instructions I went to the services and checked that the
> relevent service has already started and was set to automatic. I stopped
> the service and restarted it again. However, it did not solve the problem.
> Still getting the same error messages. Any idea why? Thanks.
>
>
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:sFlv9.64540$g9.181553_at_newsfeeds.bigpond.com...
> > Hi Abhijit,
> >
> > You simply need to restart the Oracle service.
> >
> > Hop into Services, find the appropriate Oracle service and click on
start.
> > Note you can change the service properties and have the startup type set
> to
> > automatic.
> >
> > Good Luck
> >
> > Richard
> > "ABHIJIT SRIMANI" <gamaz_at_earthlink.net_at_earthlink.net> wrote in message
> > news:Oylv9.304$V15.41713_at_newsread2.prod.itd.earthlink.net...
> > > Hi,
> > > I have installed Oracle 8i Enterprise Edition in Windows 2000. It was
> > > working fine after installation. However, I had to reboot the
computer.
> > > After that I am getting an error while starting the database. The
error
> is
> > :
> > > "Oracle not available" and "Shared memory realm does not exist". I
have
> > no
> > > idea about its resolution. Any help is highly appreciated in advance.
> > >
> > >
> >
> >
> >
>
>
Received on Mon Oct 28 2002 - 22:03:16 CST