Fw: guidance

 Hi tanel , thanks for the prompt reply. I was not able to understand your  answer. What do you mean by "new software installation" ?  What happens when you specify nls_lang in your test database ? are your  messages in the specified language or do they remain in english ?

> ----- Original Message -----
> From: "Tanel Poder" <tanel_at_integrid.info>
> To: <bulbultyagi_at_now-india.net.in>
> Sent: Wednesday, December 24, 2003 19:27
> Subject: Re: guidance
>
>
> > Hi!
> >
> > Did you do a new software installation? When you install software, you
cah
> > choose which languages to install - if you installed only English, then
> all
> > error messages will be in english, but day names, month names, currency
> > symbols etc.. will be still there, regardless of which languages you
> > installed.
> >
> > Happy holidays to you, too!
> > Tanel.
> >
> > ----- Original Message -----
> > From: <bulbultyagi_at_now-india.net.in>
> > To: <tanel.poder.003_at_mail.ee>
> > Sent: Tuesday, December 23, 2003 4:47 PM
> > Subject: Re: guidance
> >
> >
> > > Hello Tanel , sorry to trouble you but I have tried asking a question
in
> > > oracle-l_at_fatcity.com several times and no-one seems to answer. Can
you
> > > please help me out. I am not even sure whether I am doing something
> wrong
> > > or thats how things are supposed to be when specifying nls_lang, but I
> was
> > > curious so here goes :
> > > (by the way have a merry Xmas and a happy new year )
> > >
> > > I am using 9.2.0.1.0 enterprise edition on windows.
> > > Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i
> > release
> > > 1
> > > I would get the following messages in French
> > >
> > > c:> sqlplus
> > > Entrez le nom utilisateur :
> > >
> > >
> > >
> > > But now when I specify nls_lang=French_France.US7ASCII , sqlplus
sticks
> to
> > > english
> > > c:> sqlplus
> > > Enter user-name:
> > >
> > > Any ideas ?
> > >
> > > I tried out the following but to no avail :
> > > 1. I specified ora_nls33 to point to
> > > D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is
my
> > > %oracle_home%
> > >
> > > 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked
> > > NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is
> > > FRENCH and NLS_TERRITORY is FRANCE. When I select from a column
> > containing
> > > dates , the months are in French. sysdate also gives the month in
> french
> > >
> > > 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and
> > > nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect
> > > specification since there are no utf8 windows clients )
> > >
> > > 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my
> queries
> > > pick up the correct local currency symbol. and nls_language and
> > > nls_territory values in nls_session_parameters are correct.
> > >
> > > 5. Alert log doesn't show any errors.
> > >
> > > My database character set is AL32UTF8 , did not specify an nchar
> > > characterset while creating the database.
> > >
> > >
> > > ----- Original Message -----
> > > From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Thursday, September 25, 2003 03:24
> > > Subject: Re: guidance
> > >
> > >
> > > > Forget the modern tuning skills and when you're asked what shows the
> > best
> > > > that your database works optimally;
> > > >
> > > > 1) Buffer cache hit ratio is 99%
> > > > 2) Buffer cache hit ratio is 99,999%
> > > > 3) Buffer cache hit ratio is 999999%
> > > > 4) Users aren't complaining
> > > >
> > > > Then answer 3 for sure ;)
> > > >
> > > >
> > > > Tanel.
> > > >
> > > > ----- Original Message -----
> > > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > > Sent: Thursday, September 25, 2003 12:04 AM
> > > >
> > > >
> > > > > List , I am planning to give my 9i performance tuning exam on the
> > first
> > > .
> > > > > Any advice you all want to give me ? Pretty nervous about it.
Sure
> > > would
> > > > > appreciate your guidance.
> > > > > ........
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > --
> > > > > Author: <bulbultyagi_at_now-india.net.in
> > > > > INET: bulbultyagi_at_now-india.net.in
> > > > >
> > > > > Fat City Network Services -- 858-538-5051
http://www.fatcity.com
> > > > > San Diego, California -- Mailing list and web hosting
> services
> > > >
> > ---------------------------------------------------------------------
> > > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
in
> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > (or the name of mailing list you want to be removed from). You
may
> > > > > also send the HELP command for other information (like
subscribing).
> > > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Tanel Poder
> > > > INET: tanel.poder.003_at_mail.ee
> > > >
> > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > > San Diego, California -- Mailing list and web hosting
services
> > >
> ---------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You may
> > > > also send the HELP command for other information (like subscribing).
> > > >
> > >
> > >
> >
> >
> >
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).