Thanks a bunch Richard. I appreciate your help. Actually, while I posted the
reply I was scanning the Internet for resolution. Basically, I found almost
exactly what you advised. I went to sqlplus as internal(userid) and
oracle(password) and of course specifying the host string. At this point it
got me to the sql engine in idle mode. I issued command startup from sql
prompt. At this point the database mounted. And I am good to go.
From your note, it sounds that "/ as sysdba" will do the same job. Here, I
have one one question. Where are you issuing the command: sqlplus " / as
sysdba" ? Is it from dos prompt c:\ ? In my resolution, I was in the sql
window all the time. Thanks.
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:oHmv9.64566$g9.181684_at_newsfeeds.bigpond.com...
> 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 - 21:45:01 CST
