Re: ORA -01034 ORACLE not available

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 12 Nov 1999 10:26:55 -0800
Message-ID: <382C5BEF.C866E346@vnl.nl>

Peter Wu wrote:

> Hi, I am trying to run SQLPLUS in my HP box. The Oracle DB 8.0.5 is
> local.
>
> The ORACLE_HOME and ORACLE_SID is set in my script. However, when I
> connect to the local using sqlplus, it gives me "ORACLE not available"
> error after I put login id and passwd.
>
> Do I miss anything?
>
> Thanks
>
> P. Wu

Yep, your database is not running.
Assuming you're the correct user (oracle by default) do: oracle>svrmgrl
connect internal
startup

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Fri Nov 12 1999 - 12:26:55 CST