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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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: <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > 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 > > > [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > 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" <[EMAIL PROTECTED]> > > > > 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: <[EMAIL PROTECTED] > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).