Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPLUS 3.3 Connect Error

Re: SQLPLUS 3.3 Connect Error

From: Chaim Katz <katz_at_cae.ca>
Date: 1997/07/16
Message-ID: <33CD29C3.43E9@cae.ca>#1/1

terryg8 wrote:
>
> Bill Richardson wrote:
> >
> > Version 3.3 of SQLPLUS comes as part of the new Discoverer 2000 package.
> >
> > I can't connect to my Oracle Server (version 7.3.2.1.0). I get an
> > ORA 12705 error (invalid or unknown NLS parameter specified).
> > I can connect with SQLPLUS 2.2 just fine.
> >
> > Anyone else encountered this problem? Is there anything I can do?
> >
> > many thanks,
> >
> > Bill Richardson
> > Extension Information Systems
> > Virginia Tech
> > Blacksburg, Va
>
> Yeah, I've pulled my hair a few times over that one but just yesterday
> stumbled on to a workaround (at least it works for me).
>
> Tne NLS_LANG parameter in your oracle.ini file is the culprit if your
> situation is like mine. Get rid of it and the nls_lang gets a default
> value upon connecting that should work just fine.
> By the way, you don't have your oracle client software installed on
> a network do you? Seems to me that local install never had this
> problem.
>
> Anyway, good luck,
> Cheers
> Terry

You are right, but I don't believe you have to remove the parameter, I think the name of the parameter changed from NLS_LANG to NLS_LANGUAGE. Chaim Received on Wed Jul 16 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US