| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> change Language on server after Oracle install
Sent: Monday, June 17, 2002 10:44 AM
To: Boivin, Patrice J
An update, in an Oracle Forum I found this reply to someone else:
Hi. I am not sure I understand what you mean by 'server error messages.' Are you referring to when an ORA-XXXXX message is displayed in SQL*Plus or via the use of the OERR utility? The oraf.msb file should be created in $ORACLE_HOME/rdbms/mesg directory.
Regards,
Helen
Oracle Support Services
I tried it on one of our servers, it appears to work.
Am still waiting for TAR update, to see what Oracle's response is going to be.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
-----Original Message-----
Sent: Monday, June 17, 2002 10:28 AM
To: 'ORACLE-L_at_fatcity.com'
Extract from Metalink FAQ on NLS (Note:60134.1, last updated 21-MAY-2002):
When you install Oracle select the main language required. Ensure that this
is done for any products installed at a later stage. At installation time
one language or all can be selected (except for on NT and Windows 95/98 where it is not possible to select all languages at install). In Oracle7,
any further languages need to be manually copied from the distribution media whereas in Oracle8 installation of further languages requires reinstallation of the product concerned.
The mesg directory for each product should contain message files in the format:
<product abbreviation><language abbreviation>.msb <product abbreviation><language abbreviation>.msg (for some products only)
For just server messages, set NLS_LANGUAGE in the init<SID>.ora. If non-English messages are required for all client products then set NLS_LANG to include the chosen language. The language set by NLS_LANG will override that set by NLS_LANGUAGE so you need to be sure that they are the same, or that the language part of NLS_LANG is left blank.
20. How can I issue alter session commands to change my NLS parameter
settings in an application?
Use the database procedure, dbms_session.set_nls(), which takes the name of
the parameter plus its value, eg:
dbms_session.set_nls('nls_date_format','''dd/mm/yyyy''');
Note the single quotes - the value must be exactly as it would be typed in
an alter session command, eg:
alter session set nls_date_format = 'dd/mm/yyyy';
Point 13 doesn't say anything about 9i, I don't know whether they require re-installation or if they did something about this. When I took the Oracle 7.3. courses years ago our instructor told us that the database had to be reinstalled to change the language, now it seems it was possible to just copy files from the distribution media. (?) Not sure if they are saying that if you specify more than one language during installation, you will have to copy the necessary files yourself because the installer doesn't do it (???)
One of the developers here discovered that iAS 9i, which comes with an /806/ home for the Forms server components, let him change the language on NT for the Forms dialog box button labels -- the fmff.msb and fmlf.msb files had been installed automatically by the iAS installer. Now he gets Forms server error message in French, including button labels.
I just did a quick test on our 8i server here, to see if I could switch my
session:
SQL> execute DBMS_SESSION.SET_NLS('NLS_LANGUAGE', 'FRENCH');
PL/SQL procedure successfully completed.
SQL> select * from abag;
select * from abag
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table abag does not exist in any language, I wanted to generate a server message.
I also did a alter session set nls_language=french; SQL> alter session set nls_language=french;
Session altered.
SQL> sselecat;
SP2-0042: unknown command "sselecat" - rest of line ignored.
Am I doing this right?
I don't know what happens if you have to support two languages that use different character sets, I haven't done that. We use WE8ISO8859P1 here, which is comprehensive enough to support a number of national fonts.
I don't know what Europeans had to do when the Euro symbol was introduced, did you have to switch character sets? Did you have to re-install Oracle everywhere? Did you do that using export / import?
Strangely, when I enter "change database language" I get nothing from MetaLink, just the catchall Release Notes. Same with "Add Database Language".
"Add Database Language" brings up one related item, Creating Multi-Language Database for OEA/OEO Projects. But this starts at Oracle Express, and assumes that if you change NLS_LANG in Oracle Express, you will be served in that language by the backend database.
I logged a call with Oracle to see what they have to say.
A useful (?) URL: http://www.databaseanswers.com/ora_nls_support.htm Another: http://technet.oracle.com/products/oracle8i/htdocs/faq_combined.htm
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
-----Original Message-----
Sent: Friday, June 14, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L
John,
I think you're confusing "characterset" with "language"; you can pack a lot of languages into the WE8ISO8859P1 or P15 charactersets! I think the P15 is new for including the euro character, by the way...?
Look in the view NLS_INSTANCE_PARAMETERS for a list of the configurable NLS initialization parameter settings that are current. The view NLS_DATABASE_SETTINGS is a little more extensive, including settings such as CHARACTERSET which are set using CREATE/ALTER DATABASE in addition to those configurable by initialization parameters (shown in NLS_INSTANCE_PARAMETERS)... All of the NLS parameters in NLS_INSTANCE_PARAMETERS can be changed with ALTER SESSION for testing, but they can't be changed globally using ALTER SYSTEM; requires the instance to be "bounced". Most Oracle releases have a separate "NLS" reference manual (http://docs.oracle.com) for more info...
Hope this helps...
-Tim
> We have a AIX server with Oracle 8.1.7 installed. The language is set to
> ISO8859-1 English US.
>
>
>
>
>> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: Tim_at_SageLogix.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: Boivin, Patrice J INET: BoivinP_at_mar.dfo-mpo.gc.ca Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).Received on Mon Jun 17 2002 - 09:48:22 CDT
 |
 |