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: Oracle 8i, RH 6.1, "not logged on", and FREE BEER

Re: Oracle 8i, RH 6.1, "not logged on", and FREE BEER

From: Brice Ruth <Brice.Ruth_at_penguinboots.com>
Date: Fri, 11 Feb 2000 11:38:48 -0600
Message-ID: <38A44928.A2ADD539@penguinboots.com>


I must report: this man is a GENIUS!!! Someone GIVE THIS MAN A JOB @ ORACLE!!! My NLS_LANG was set (according to the instructions) and was WRONG!

*dear Lord*

Doeni - you want some beer? Just gimme your address & your favorite, I'll send it straight away ... I'm in Chi-town (Chicago) so I imagine I'd be able to get most anything if it ain't totally outrageous.

Brice

Matt Luker wrote:

> In article <87emakn2rc.fsf_at_freebie.evhr.net>, Doeni <doeni_at_evhr.net> wrote:
> >
> > What is your NLS settings looking like. Especially NLS_LANG.
> > The format of the variable should be something like
> > language_territory.characterset (eg. american_america.we8iso8859p1).
> >
> > Check also ORA_NLS33 (should be $ORACLE_HOME/ocommon/nls/admin/data).
> >
> > To be completely sure there is no corrupt value, unset them both (if
> > they are set) before creating the database.
> >
>
> DEAR GOD ALMIGHTY! IT WOOOOORRRRKKKKEEED!!!!!!
>
> I unset both the NLS_LANG and the ORA_NLS33, and I got this wonderful
> output:
>
> SVRMGR> spool /usr/local/oracle/product/8.1.5/install/crdb1.log
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup nomount pfile = /usr/local/oracle/product/8.1.5/admin/quark/pfile/initquark.ora
> ORACLE instance started.
> Total System Global Area 23670160 bytes
> Fixed Size 64912 bytes
> Variable Size 6656000 bytes
> Database Buffers 16777216 bytes
> Redo Buffers 172032 bytes
>
> You win. What beer do you want? Email me your address and I will ship it
> to you. Just remove the NOSPAM from the address.
>
> Thank you. THANK YOU SO MUCH. Not to sound melodramatic, but I have
> been struggling with this for a month.
>
> That will teach me to RTFM (I set those variables according to the
> installation instructions I got with my CD). That makes me pretty mad,
> in retrospect--normal I chuck the instructions and muddle through! :-)
>
> Thank you again. You made my week. Really.
>
> Matt
>
> --
> ----------------------------------------------------
> Matt Luker
> kostya_at_lucideN.OcomS.PAM
>
> PGP FINGERPRINT:
> C6E7 7209 3A67 B678 FCE4 236A 6DAA 4555 5761 30B1
> ----------------------------------------------------

--
+--+
"The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense." -- E. W. Dijkstra (1982) Received on Fri Feb 11 2000 - 11:38:48 CST

Original text of this message

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