Re: Oracle error

From: <ddf_dba_at_my-deja.com>
Date: 2000/06/22
Message-ID: <8itto5$man$1@nnrp1.deja.com>#1/1

In article <8itjtt$8ic$1_at_bob.news.rcn.net>, "Alan" <alanshein_at_erols.spambuster.com> wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0071_01BFDC51.2A716740
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Looks to me like your database isn't up.=20
>
> Gopi Balasingam wrote in message <394D0534.75DA2752_at_home.com>...
> Hi All,=20
> Sorry for the cross-post!=20
>
> I've run in to a strange problem where, when I invoke SVRMGL I
keep =
> getting the following error :=20
>
> svrmgrl=20
> =20
> Oracle Server Manager Release 3.1.5.0.0 - Production=20
> =20
> Message 4505 not found; No message file for product=3DSVRMGR, =
> facility=3DMGR=20
> =20
> Error while trying to retrieve text for error ORA-12162=20
> SVRMGR> exit=20
> Message 37 not found; No message file for product=3DSVRMGR, =
> facility=3DMGR=20
>
> I haven't crated a database yet, but was just testing out the =
> installation before proceeding to create the database but
unfortunately =
> ran into this error.=20
>
> In addition, if SQLPLUS is invoked, the system complain with the =
> following error message :=20
>
> Error 6 initializing SQL*Plus=20
> =20
>
> Any suggestions as to why I'm having this problem ?=20
>
> Thanks in advance.=20
>
> Regards,=20
> Gopi=20
>
> ------=_NextPart_000_0071_01BFDC51.2A716740
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
> <HTML>
> <HEAD>
>
> <META content=3Dtext/html;charset=3Diso-8859-1 =
> http-equiv=3DContent-Type><!doctype html public "-//w3c//dtd html 4.0
=
> transitional//en">
> <META content=3D'"MSHTML 4.72.3713.2800"' name=3DGENERATOR>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV>Looks to me like your =
> database isn't up.=20
> </DIV>
> <DIV> size=3D3> </DIV>
> <DIV> </DIV>
> <BLOCKQUOTE=20
> style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px;
PADDING-LEFT: =
> 5px">
> <DIV>Gopi Balasingam<GOPIB_at_HOME.COM> wrote in message <<A=20
> =
>

href=3D"mailto:394D0534.75DA2752_at_home.com">394D0534.75DA2752_at_home.com</A
>=
> >...</DIV>Hi=20
> All,=20
> Sorry for the cross-post!=20
> I've run in to a strange problem where, when I invoke SVRMGL I
=
> keep=20
> getting the following error :=20
> svrmgrl   Oracle Server Manager =
> Release=20
> 3.1.5.0.0 - Production   Message 4505
not =
> found;=20
> No message file for product=3DSVRMGR, facility=3DMGR =
>  =20
> Error while trying to retrieve text for error
ORA-12162=20
> SVRMGR> exit Message 37 not found; No message
=
> file for=20
> product=3DSVRMGR, facility=3DMGR=20
> I haven't crated a database yet, but was just testing out
the=20
> installation before proceeding to create  the database but=20
> unfortunately ran into this error.=20
> In addition, if SQLPLUS is invoked, the system complain with
the=20
> following error message :=20
> Error 6 initializing SQL*Plus  =20
> Any suggestions as to why I'm having this problem ?=20
> Thanks in advance.=20
> Regards, Gopi </BLOCKQUOTE></BODY></HTML>
>
> ------=_NextPart_000_0071_01BFDC51.2A716740--
>
>

Since a database hasn't been created yet it isn't difficult to know that it isn't 'up'. The database doesn't have to be up to have svrmgrl running. I should expect that the environment isn't properly set up. Double check your installation checklist; below is a list of pertinent Oracle environment variables:

ORACLE_HOME (ex: /usr/local/oracle/8i/u01/app/oracle/product/8.1.5 )
ORACLE_BASE (ex: /usr/local/oracle/8i/u01/app/oracle)
NLS_LANG    (ex: 'american_america.US7ASCII')
ORA_NLS33   (ex: $ORACLE_HOME/ocommon/nls/admin/data)
TNS_ADMIN   (ex: $ORACLE_HOME/network/admin)

LD_LIBRARY_PATH (ex: $ORACLE_HOME/lib)
ORACLE_TERM (ex: vt100)
ORACLE_SID Don't forget to include $ORACLE_HOME/bin in your PATH as well.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Thu Jun 22 2000 - 00:00:00 CDT