Skip Headers

Oracle9i Application Server Globalization Support Guide
Release 2 (9.0.2)

Part Number A92110-02
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

3
Configuring Oracle9iAS for Global Application Deployment

This chapter contains the following topics:

About Manually Editing HTTP Server and OC4J Configuration Files

If you edit Oracle HTTP Server or OC4J configuration files manually, instead of using the Enterprise Manager Web site, you must use the DCM command-line utility dcmctl to notify the DCM repository of the changes. Otherwise, your changes will not go into effect and will not be reflected in the Enterprise Manager Web site. The commands are as follows:

Before you change configuration parameters, manually or using the Enterprise Manager Web site, you can save the current state of Oracle HTTP Server and OC4J configuration files and installed J2EE applications with the following command:

ORACLE_HOME/dcm/bin/dcmctl saveInstance -dir directory_name

You can then restore the state and back out of any subsequent changes that were made using the following command:

ORACLE_HOME/dcm/bin/dcmctl restoreInstance [ -dir directory_name ]

See Also:

Oracle9i Application Server Administrator's Guide

Configuring Oracle HTTP Server for Multilingual Support

This section contains the following topics related to configuring Oracle HTTP Server for multilingual support:

Configuring the NLS_LANG Environment Variable

The NLS_LANG environment variable controls the language, territory, and character set used for database connections in an Internet application. Specify the value of NLS_LANG in the following format, including the punctuation as shown:

language_territory.characterset

language, territory, and characterset must be valid Oracle language, territory, and character set names. The specified language and territory are used to initialize the locale that determines the default date and time formats, number formats, and sorting sequence in a database session. The Oracle9i database converts data to and from the specified character set when it is retrieved from or inserted into the database.

See Also:

Oracle9i Globalization Support Guide in the Oracle Database Documentation Library for a list of valid Oracle language, territory, and character set names

Specify the NLS_LANG environment variable in the Oracle HTTP Server files.

In the following Oracle HTTP Server file: Add the following line:
$ORACLE_HOME/Apache/Jserv/etc/jserv.properties
wrapper.env=NLS_LANG=language_territory.characterset
$ORACLE_HOME/Apache/Apache/conf/httpd.conf
PassEnv NLS_LANG

For UNIX platforms:

$ORACLE_HOME/Apache/Apache/bin/apachectl
NLS_LANG=${NLS_LANG=language_
territory.characterset}; export NLS_LANG
$ORACLE_HOME/opmn/conf/opmn.xml
<environment>
...
<prop name="NLS_LANG" value="language_territory_
characterset" />
...
</environment>

In the ORACLE_HOME/Apache/modplsql/cfg/dads.conf file, specify the NLS_LANG value for the database access descriptors (DADs). For example, you can specify the NLS_LANG value for the /pls/scott DAD as follows:

<Location /pls/scott>
        SetHandler pls_handler
        Order deny,allow
        Allow from all
        PlsqlDatabasePassword          tiger
        PlsqlDatabaseUsername          scott
        PlsqlDocumentPath              docs
        PlsqlEnableConnectionPooling   On
        PlsqlNlsLanguage               <NLS_LANG value>
</Location>

For Windows platforms, the Oracle9iAS installation initializes a default NLS_LANG environment variable as the NLS_LANG registry key in the following location:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEn

The default NLS_LANG value defined in the registry applies to the corresponding Oracle Home. The Oracle HTTP Server uses this default NLS_LANG value when NLS_LANG values are not explicitly specified in the configuration files as described above.

You should set the value of NLS_LANG differently depending on whether you are deploying a monolingual or multilingual application. The following sections tell how to set NLS_LANG:

Setting NLS_LANG in a Monolingual Application Architecture

Set the NLS_LANG environment variable to specify the language, territory, and character set that correspond to the locale that its middle-tier server is configured to serve. If most clients are running on Windows platforms, then it is a good practice to use the NLS_LANG character set that corresponds to the Windows code page of the locale. For example, when you configure the middle tier server to serve Japanese clients, then specify the following value for NLS_LANG:

JAPANESE_JAPAN.JA16SJIS

JA16SJIS corresponds to code page 932 of the Japanese Windows operation system.

Table 3-1 lists the NLS_LANG values for the most commonly used locales.

Table 3-1 NLS_LANG Values for Commonly Used Locales  
Locale NLS_LANG Value

Arabic (Egypt)

ARABIC_EGYPT.AR8MSWIN1256

Arabic (U.A.E.)

ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256

Chinese (Taiwan)

TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950

Chinese (P.R.C.)

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Czech

CZECH_CZECH REPUBLIC.EE8MSWIN1250

Danish

DANISH_DENMARK.WE8MSWIN1252

Dutch

DUTCH_THE NETHERLANDS.WE8MSWIN1252

English (United Kingdom)

ENGLISH_UNITED KINGDOM.WE8MSWIN1252

English (U.S.A.)

AMERICAN_AMERICA.WE8MSWIN1252

Finnish

FINNISH_FINLAND.WE8MSWIN1252

French (Canada)

CANADIAN FRENCH_CANADA.WE8MSWIN1252

French (France)

FRENCH_FRANCE.WE8MSWIN1252

Germany (German)

GERMANY_GERMAN.WE8MSWIN1252

Greek

GREEK_GREECE.EL8MSWIN1253

Hebrew

HEBREW_ISRAEL.IW8MSWIN1255

Hungarian

HUNGARIAN_HUNGARY.EE8MSWIN1250

Italian (Italy)

ITALIAN_ITALY.WE8MSWIN1252

Japanese

JAPANESE_JAPAN.JA16SJIS

Korean

KOREAN_KOREA.KO16MSWIN949

Norwegian

NORWEGIAN_NORWAY.WE8MSWIN1252

Polish

POLISH_POLAND.EE8MSWIN1250

Portuguese (Brazil)

BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252

Portuguese (Portugal)

PORTUGUESE_PORTUGAL.WE8MSWIN1252

Romanian

ROMANIAN_ROMANIA.EE8MSWIN1250

Russian

RUSSIAN_CIS.CL8MSWIN1251

Slovak

SLOVAK_SLOVAKIA.EE8MSWIN1250

Spanish (Spain)

SPANISH_SPAIN.WE8MSWIN1252

Spanish (Latin American)

LATIN AMERICAN SPANISH_AMERICA.WE8MSWIN1252

Swedish

SWEDISH_SWEDEN.WE8MSWIN1252

Thai

THAI.THAILAND.TH8TISASCII

Turkish

TURKISH_TURKEY.TR8MSWIN1254

Setting NLS_LANG in a Multilingual Application Architecture

The language and territory components of the NLS_LANG parameter are not as important in multilingual application architecture as they are in monolingual application architecture. A multilingual application needs to handle different locales dynamically and cannot rely on fixed settings. The application should always use the UTF-8 character set so that Unicode data can be retrieved from and inserted into the database. An example of a valid value for NLS_LANG in a multilingual deployment is:

NLS_LANG=AMERICAN_AMERICA.UTF8

Configuring the Runtime Default Locale in a Monolingual Application Architecture

Only monolingual application designs require you to configure the runtime default locale. This section describes how to initialize the runtime default locale for runtime environments that Oracle9iAS supports:

mod_jserv Runtime for Java

For UNIX platforms, the LANG or LC_ALL variable defines:

To configure the Java VM for JServ, define the LANG or LC_ALL environment variable with a POSIX locale name in the jserv.properties file. For example, the following line in jserv.properties defines Japanese (Japan) to be the default locale of Java VM for Jserv on UNIX:

wrapper.env=LANG=ja_JP

The values for the LANG and LC_ALL environment variables should refer to the same POSIX locale available in your operating system. The LC_ALL environment variable always overrides the LANG environment variable if they are different.

The regional settings of the Control Panel control the default locale of the Java VM for JServ on Windows platforms. Change the regional settings to the desired locale from the Control Panel before starting Oracle HTTP Server.

mod_oc4j Runtime for Java

Define the LANG or LC_ALL environment variable with a POSIX locale name in $ORACLE_HOME/opmn/conf/opmn.xml. For example, the following line within the <environment> tags in opmn.xml defines Japanese (Japan) to be the default locale of Java VM for OC4J on UNIX:

<environment>
...
<prop name="LANG" value="ja_JP" />
...
</environment>

The regional settings of the Control Panel control the default locale of the Java VM for OC4J on Windows platforms. Change the regional settings to the desired locale from the Control Panel before starting Oracle HTTP Server.

mod_plsql Runtime for PL/SQL and PL/SQL Server Pages

PL/SQL and PL/SQL Server Pages run on an Oracle9i database in the context of a database session. Therefore, the NLS_LANG parameter controls the runtime default locale. The NLS_LANG parameter should be configured as described in "Setting NLS_LANG in a Monolingual Application Architecture".

mod_perl Runtime for Perl Scripts

Perl scripts run on the Perl interpreter that the mod_perl module provides. The locale support in Perl is based on the POSIX locale available in the operating system. It uses the underlying POSIX C libraries as a foundation. To configure the Perl runtime default locale, follow the procedure described for the C/C++ runtime.

See Also:

C/C++ Runtime

The C/C++ runtime uses the POSIX locale system that the operating system provides. You can configure the locale system by defining the LC_ALL or LANG environment variable. Define LC_ALL with a valid locale value that the operating system provides. These values are different on different operating systems.

See Also:

Table 2-1 for a list of commonly used POSIX locales for UNIX

For UNIX platforms, define LC_ALL as follows:

For Windows platforms, the POSIX locale should inherit its value from the regional settings of the Control Panel instead of being specified in the LC_ALL environment variable. Change the regional settings to change the default runtime POSIX locale.

Configuring Transfer Mode for mod_plsql Runtime

The transfer mode of each database access descriptor (DAD) of the mod_plsql runtime enables PL/SQL to construct HTML content and process HTML form input in different character sets. You must set the transfer mode with the appropriate value.

It is important to configure the transfer mode for the mod_plsql module in the $ORACLE_HOME/Apache/modplsql/cfg/dads.conf file where the DADs are specified.

The mod_plsql module supports two transfer modes that you can configure in a DAD:

You should turn on the RAW transfer mode in a DAD for both monolingual and multilingual Internet applications as follows:

<Location /pls/scott>
        SetHandler pls_handler
        Order deny,allow
        Allow from all
            PlsqlDatabasePassword          tiger
            PlsqlDatabaseUsername          scott
            PlsqlDatabaseConnectString     local
            PlsqlDocumentPath              docs
            PlsqlEnableConnectionPooling   On
            PlsqlNlxLanguage               AMERICAN_AMERICA.UTF8
            PlsqlTransferMode              RAW
</Location>

Configuring Oracle9iAS Portal for Multilingual Support

Oracle9iAS Portal is translated into 29 different languages. This allows developers to work in their own language when they build portals. In addition, the self-service content management supports multiple languages so that end users can provide documents and other content in different languages. Those who view the content can see the version that corresponds to the language setting in the browser or to the language they have selected in the set language portlet. See Appendix A for a list of languages and abbreviations that are available for Oracle9iAS Portal.

To install languages when you install Oracle9iAS Portal, run the ptlasst.csh script with -mode LANGUAGE for each language that you want Oracle9iAS Portal to support. The ptlasst.csh script is located in the following directory:

$ORACLE_HOME/ora9ias/assistants/opca dir

Running the ptlasst.csh script with -mode LANGUAGE invokes the Oracle Portal Configuration Assistant (OPCA) in the silent mode to install the language. Usage information on the ptlasst.csh script is generated by running the script without any parameters.

Table 3-2 shows ptlasst.csh script usage examples for different language requirement scenarios.

Table 3-2 Option Usage with the ptlasst.csh Script
Scenario Usage

Full usage

ptlasst.csh -mode LANGUAGE -s portal -sp portal -o orasso -op orasso -c myhost.domain.com:1521:mySID -lang us -available-silent-verbose-sso_c myhost.domain.com:1521:mySID

Portal and SSO are installed on the same database

ptlasst.csh -mode LANGUAGE -s portal -sp portal -o orasso -op orasso -c myhost.domain.com:1521:mySID -lang us -available-silent-verbose

Language requirement is only for the Portal Repository

ptlasst.csh -mode LANGUAGE -s portal -sp portal -c myhost.domain.com:1521:mySID -lang us -available -silent -m portal -verbose

Language requirement is only for the SSO Repository

ptlasst.csh-mode LANGUAGE -o orasso -op orasso -sso_c myhost.domain.com:1521:mySID -lang us -available -silent -m sso -verbose

Table 3-3 lists the supported parameters for the ptlasst.csh script in LANGUAGE mode (-mode LANGUAGE).

Table 3-3 Supported Parameters for ptlasst.csh in LANGUAGE Mode  
Parameter Definition

-s

Portal schema name. The default is portal.

-sp

Portal schema password. The default is portal.

-c

Connect string to the target database. The format should be hostname:port:sid.

-o

SSO schema name. The default is orasso.

-op

SSO password. The default is orasso.

-sso_c

Connect string to the target database where SSO is installed. The format should be hostname:port:sid.

Note: If the Portal and SSO use the same database, argument -c would take care of both the Portal and SSO connections.

-lang

Abbreviation for the language to install. The default is us.

-m

If sso, translations are only for SSO repository. If portal, translations are only for Portal repository. If not specified, translations are installed for both. The default is not specified.

-available

Sets whether the language will be available for user translation.

-silent

Runs the OPCA in the silent mode. The default is TRUE.

-verbose

Enables the logging in detail mode. Even if there are errors in the log file, the OPCA install would continue.

If this parameter is not set, logging information is in brief and OPCA aborts the instal if it encounters any error of kind ORA-, PLS-, or SP2. The default is TRUE.


Note:

When you configure bidirectional languages (Arabic and Hebrew), you must also execute the $ORACLE_HOME/ora9ias/portal30/admin/plsql/nlsres/imginst.sql script as the Portal schema owner.


The character set for the mod_plsql gateway must be the same as the customer database character set.

See Also:

Oracle9iAS Portal Configuration Guide

Configuring Oracle9iAS Single Sign-On for Multilingual Support

Oracle9iAS Single Sign-On supports 29 languages. English is the only language installed by default. The Single Sign-On login page does not display language selection buttons if other languages were not installed. As a result, no product accessed through Single Sign-On can run in non-English mode.

You need to install other languages in order to support these languages during Single Sign-On login. To install additional languages, execute the following command:

ORACLE_HOME/jdk/bin/java -jar ORACLE_HOME/sso/lib/ossoca.jar langinst lang make_
lang_avail ORACLE_HOME

In this command, lang specifies the abbreviation code for the language to be installed. See Appendix A for a list of languages and their corresponding abbreviations. The value of make_lang_avail specifies whether or not to make the language available. Enter 1 to make the language available, 0 otherwise.

See Also:

Oracle9iAS Single Sign-On Administrator's Guide

Configuring Oracle9iAS Forms Services for Multilingual Support

The NLS_LANG environment variable controls the language, territory, and character set that an Internet application uses for database connections. Specify the value of NLS_LANG in the following format, including the punctuation as shown:

language_territory.characterset

language, territory, and characterset must be valid Oracle language, territory, and character set names. The specified language and territory are used to initialize the locale that determines the default date and time formats, number formats, and sorting sequence in a database session. The Oracle9i Net converts data to and from the specified character set when it retrieves data from or inserts data into the database.

You can set the NLS_LANG environment variable in the $ORACLE_HOME/forms90/server/default.env file. If you do not set the NLS_LANG environment variable in the default.env file, then Forms Services uses the value set as follows:

You can have different NLS_LANG settings on the same Forms Services by specifying an alternate environment file. Use the EnvFile parameter in the zone.properties file. To do this:

  1. Create two environment configuration files under $ORACLE_HOME/forms90/server. For example, an American environment configuration file (en.env) should contain the following lines:

        NLS_LANG=AMERICAN_AMERICA.US7ASCII
        FORMS90_PATH=d:\us
        PATH=d:\ora90\bin
    
    

    A Japanese environment configuration file (ja.env) should contain the following lines:

        NLS_LANG=JAPANESE_JAPAN.JA16SJIS
        FORMS90_PATH=d:\jp
        PATH=d:\ora90\bin
    
    
  2. In the zone.properties file ($ORACLE_HOME/Apache/Jserv/servlets), create a ListenerServlet alias that uses the file with the alternate environment variable settings. For example, create a Listener Servlet for the Japanese settings:

        servlet.lservletJP.code=oracle.forms.servlet.ListenerServlet
    
    
  3. In the zone.properties file ($ORACLE_HOME/Apache/Jserv/servlets), set the configFile parameter for the ListenerServlet alias. The ConfigFileName parameter specifies the physical path to the configuration file that contains the alternate environment variables. For example:

        servlet.lservletJP.initArgs=configFileName=d:\ora90/forms90/server/formsweb.
        cfg
    
    

    A sample zone.properties file for Windows might contain the following:

        #for default setting (American)
        servlet.lservlet.initArgs=envfile=d:\ora90\forms90\server\default.env
        servlet.lservlet.code=servlet.oracle.forms.servlet.ListenerServlet
    
        #ListenerServlet alias for Japanese environment variables
        servlet.lservletJP.code=oracle.forms.servlet.ListenerServlet
        servlet.lservletJP.initArgs=envfile=d:\ora90\forms90\server\JpRes.env
    
    
  4. In the formsweb.cfg file ($ORACLE_HOME/forms90/server), set the envFile parameter for the alternative setting. For example:

        [ja]
        envFile=ja.env
    
        [en]
        envFile=en.env
    
    

    Then specify the configuration name in your URL for forms servlet as follows:

        http://formsservermachine/forms90/f90servlet?config=ja
        http://formsservermaching/forms90/f90servlet?config=en
    

    See Also:

    Oracle9iAS Forms Services Deployment Guide

Configuring Oracle9iAS Reports Services for Multilingual Support

The NLS_LANG environment variable controls the language, territory, and character set used for database connections in an Internet application. Specify the value of NLS_LANG in the following format, including the punctuation as shown:

language_territory.characterset

language, territory, and characterset must be valid Oracle language, territory, and character set names. The specified language and territory are used to initialize the locale that determines the default date and time formats, number formats, and sorting sequence in a database session. The Oracle9i Net converts data to and from the specified character set when it retrieves data from or inserts data into the database.

You can set the value of the NLS_LANG parameter as follows:

Configuring Oracle9iAS Discoverer for Multilingual Support

Oracle9iAS Discoverer can simultaneously support users with different locales. Users may explicitly control the locale used for the user interface, or they may allow Oracle9iAS Discoverer to automatically determine a default. The order of precedence for determining the language and locale is:

  1. Language and locale settings included in the URL for Oracle9iAS Discoverer

  2. Language and locale settings specified in the Discoverer Connection (this is part of the Oracle9iAS Discoverer integration with Oracle9iAS Single Sign-On).

  3. Language and locale setting specified in the user's browser

  4. Language and locale of Oracle9i Application Server

To configure the user interface of Oracle9iAS Discoverer to use a specific language and locale, you must specify NLS parameters as part of the URL used to access Discoverer. You can specify the following NLS parameters as part of the URL:

There is one additional aspect of multilingual support configuration of which you should be aware. Discoverer displays data and metadata from the database in the language in which it was created. The user interface has been translated to multiple languages and all necessary resources are already installed. However, the language for the user interface may be different than the language of the information in the database, as well as any Discoverer metadata the administrator defined on that data.

For example, an administrator creates a folder in a Business Area and gives it a Korean name using Korean characters. A Discoverer user with an American-English locale sees all of the buttons, menus, and documentation in English. But if the user views the Business Area with the Korean name, the folder is still displayed in Korean. Discoverer does not dynamically translate the user's data.

To have both the user interface and the data in a specified language and locale, your Discoverer metadata, the End User Layer (EUL), must also use that language and locale. To truly support multiple languages, you must have multiple translations of your EUL. Users can specify the appropriate EUL as part of their Discoverer Connection. You may also specify the EUL in any URL used to access Discoverer. See the Oracle9iAS Discoverer Configuration Guide for more information.

The rest of this section describes how to create a translated EUL, which requires the Oracle9iAS Discoverer Administrator from the Internet Developer Suite (iDS).

To translate the EUL:

  1. Use the Discoverer Administrator to export the EUL to an EEX file with translation information. For example:

        @dis5adm /connect eul_owner_name/password@dbname /export eex_file_name 
        /external_element dctrans.xml
    
    

    In the exported EEX file, you can find the <OraTranslatability> element, which tells you the attributes to translate and limitations for the attribute.

  2. Extract the strings to translate. Based on the <OraTranslatability> element, you can extract strings to a translatable file format like XLIFF and translate them. You must use your own XML utility.

  3. Merge the translated file with the original EEX file. You must use your own XML utility.

  4. Create a new EUL and import the translated EEX file.

Configuring Oracle9iAS Clickstream Intelligence for Multilingual Support

Specify the character set in the Oracle9iAS Clickstream Intelligence configurator screen.

Specify the language when you install ClickStream. ClickStream does not support multiple languages on a single instance.

Configuring Oracle9i Business Components for Java for Multilingual Support

You can set the following Oracle9i Business Components for Java (BC4J) properties:

Their default values are en and US, respectively.

You can set them at the command line, by modifying the jboserver.properties file, or with an applet parameter tag. All sessions share this locale to display messages.

Configuring a Centralized Database for Multilingual Support

You can set up the centralized Oracle9i database to store Unicode data in the following ways:

It is good practice to configure the centralized Oracle9i database to support:

Example 3-1 shows part of a CREATE DATABASE statement that sets the recommended database character set and national character set.

Example 3-1 Specifying the Database Character Set and the National Character Set

CREATE DATABASE myunicodedatabase
    CONTROL FILE REUSE
    LOGFILE '/u01/oracle/ubfdb/redo01.log' SIZE 1M REUSE
    '/u01/oracle/utfdb/redo02.log' SIZE 1M REUSE
    DATAFILE '/u01/oracle/utfdbsystem01.dbf' SIZE 10M REUSE
    AUTOEXTENT ON
    NEXT 10M MAXSIZE 200M
    CHARACTER SET UTF8
    NATIONAL CHARACTER SET AL16UTF16
    ... ;

Go to previous page Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index