One other possibility is that the database is running in memory, which would
result in the startup command saying "cannot start oracle already running."
Usually this happens when the database crashes. In this case Oracle is not
available because it isn't running, yet it won't start because it is still
in memory. If this is the case, use ipcs to confirm this and then use
ipcrm -m to remove oracle from memory and ipcrm -s to remove the semaphores.
--
Dave A
"Harry Scullion" <sandlion2_at_yahoo.com> wrote in message
news:39E1D12B.6C3BCCA6_at_yahoo.com...
> Your error spawns from the SID being correct and the instance is down.
> Or and instance is up and the ORACLE_SID is wrong.
>
> DO a ps -ef |grep -i oracle - to detect the instances.
> You may have to use svrmgrl to start/stop a few.
>
>
> MfG
>
> Harry S.
>
> Matthias Kohler wrote:
> >
> > Every command I enter (example: connect internal, sqlplus create
> > table..., ...) resolves in the Error 01034 Oracle not avaible. What
> > should help the Installation is on an Sun Sparc with Solaris 8. And the
> > Installation ist Oracle 8.1.6 second Revision.
> >
> > I am very thankfully for all help iI can get.
> >
> > Matthias
Received on Mon Oct 09 2000 - 18:01:11 CDT
