5 Configuring Oracle Application Server for Global Deployment

Installing Oracle Application Server for Global Deployment

In addition to the schemas of the infrastructure components, such as Oracle Internet Directory (OID) and Distributed Configuration Management (DCM), the Oracle Application Server Infrastructure database stores data pertaining to many Oracle Application Server middle-tier components that are installed on top of it. These components include Portal, Wireless, Forms, Reports, and Discoverer. Therefore, it is important to choose the correct database character set for the infrastructure database at install time so that all of the dependent components are able to provide the same level of global support.

During the installation of the Oracle Application Server infrastructure database, you are prompted to choose the database character set you would like to use for the database. There are two basic scenarios that will determine which choice is best for your environment:

• If your environment is intended to support multiple languages in a single global instance of the Oracle Application Server infrastructure, choosing UTF-8 as the character set for the infrastructure database is highly recommended. Even if you only support a single language, such as English, you may choose UTF-8 as the database character set. The implications of choosing UTF-8 include, but are not limited to, the following:

  1. Databases with UTF-8 as the database character set are slightly slower than those with single-byte character sets. The performance impact is due to UTF-8 being a multibyte character set and the increase in the number of character set conversions between the middle tier and the database.

  2. Web pages served through mod_plsql must be encoded in UTF-8. However, there are some browsers, such as Netscape 4.7x and those for mobile devices, that may have some problems supporting UTF-8. Products that deliver Web pages through mod_plsql include Single Sign-On and Portal.

• If your environment is intended to support a single language or a group of languages that share the same native character set, you can choose the character set that is most commonly used for these languages as an alternative to UTF-8. For example, you can choose WE8MSWIN1252 if you are only interested in supporting Western European languages. You can choose JA16SJIS if you are interested in supporting Japanese and English.

During installation of any Oracle Application Server 10g installation type, support for user-selected languages is automatically installed and configured. It includes the translation files and fonts being used in the product. Additionally, command-line language installation is still supported.

If the required fonts are not available after installation, you can copy them from the Utilities CD included in the Oracle Application Server CD pack, or from http://metalink.oracle.com into the $ORACLE_HOME/jdk/jre/lib/fonts directory.

Configuring Oracle HTTP Server and OC4J for Global Deployment

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

• About Manually Editing HTTP Server and OC4J Configuration Files

• Configuring the NLS_LANG Parameter

• Configuring Transfer Mode for mod_plsql Runtime

• Configuring the Runtime Default Locale

ORACLE_HOME/dcm/bin/dcmctl saveInstance -dir directory_name

ORACLE_HOME/dcm/bin/dcmctl restoreInstance -dir directory_name

language_territory.characterset

NLS_LANG=${NLS_LANG=language_territory.characterset}; export NLS_LANG

NLS_LANG=language_territory.characterset; export NLS_LANG

JAPANESE_JAPAN.JA16SJIS

NLS_LANG=AMERICAN_AMERICA.UTF8

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

PlsqlNlsLanguage "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

wrapper.env=LANG=ja_JP

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

    PassEnv LC_ALL

    LC_ALL=${LC_ALL=OS_locale}; export LC_ALL

Configuring Oracle Application Server Portal for Global Deployment

Oracle Application Server Portal is designed to allow application development and deployment in different languages. OracleAS Portal is configured with the languages that are selected in the Oracle Universal Installer (OUI) during the Oracle Application Server middle-tier installation. Languages that are configured show up in the Set Language portlet.

To configure additional languages after installation, the OracleAS Portal Configuration Assistant (OPCA) must be used in LANGUAGE mode. Once you have installed a language, OracleAS Portal allows you to specify the preferred locale and territory to be used for that language; for example, Australian English or Canadian French. See Appendix A for a list of languages and abbreviations that are available for OracleAS Portal.

Configuring Oracle Application Server Wireless for Global Deployment

When users access wireless services from their mobile devices, Oracle Application Server Wireless uses the user profile information from Oracle Internet Directory (OID) to determine the user’s preferred language. Administrators can select the language when creating a new user through the Oracle Application Server Wireless Tools. Users can change their preferred language through the Wireless Customization Tool.

Configuring Oracle Application Server Single Sign-On for Global Deployment

Oracle Application Server Single Sign-On is automatically configured with the languages that are selected in the Oracle Universal Installer (OUI) during the Oracle Application Server Infrastructure installation. To configure additional languages after installation, you need to 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.

Configuring Oracle Application Server Forms Services for Global Deployment

The NLS_LANG parameter 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. Oracle 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 parameter in the $ORACLE_HOME/forms90/server/default.env file. If you do not set the NLS_LANG parameter in the default.env file, then Forms Services uses the value set as follows:

• On UNIX: The NLS_LANG shell environment variable when Forms Server is invoked

• On Windows: The NLS_LANG setting at the \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\FormsServerOracle_HOME in the Win32 registry

You can have different NLS_LANG settings on the same Forms Server by specifying an alternate environment file. Use the envFile parameter in the formsweb.cfg 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
   

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

       NLS_LANG=JAPANESE_JAPAN.JA16SJIS
       FORMS90_PATH=d:\ja
   
   

2. 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 the URL for your forms servlet as follows:

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

Configuring Oracle Application Server Reports Services for Global Deployment

The NLS_LANG parameter controls the language, territory, and character set used for database connections in an Oracle Application Server Reports Services 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. Oracle Net converts data to and from the specified character set when it retrieves data from or inserts data into the database.

Oracle Application Server Reports Services uses the value of the NLS_LANG parameter set as follows:

• On UNIX: The NLS_LANG shell environment variable when Oracle Application Server Reports Services is invoked. The default NLS_LANG value is set in $ORACLE_HOME/bin/reports.sh.

• On Windows: The value of NLS_LANG set at \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\%ReportsORACLE_HOME% in the Win32 registry

• For dynamic environment switching: In the Reports Server configuration file through the environment element. On UNIX, the default NLS_LANG value in the reports.sh file needs to be commented out to enable this feature.

Configuring Oracle Application Server Discoverer for Global Deployment

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

1. Language and locale settings specified in the URL for Oracle Application Server Discoverer

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

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

4. Language and locale of Oracle Application Server

Configuring Oracle Business Components for Java for Global Deployment

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

• jbo.default.language

• jbo.default.country

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 Unicode-enabled Database to Support Global Deployment

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

• As UTF-8 in the SQL CHAR data types (CHAR, VARCHAR2, and CLOB)

• As UTF-16 in the SQL NCHAR data types (NCHAR, NVARCHAR2, and NCLOB)

  
  

  See Also: Oracle9i Globalization Support Guide in the Oracle Database Documentation Library Oracle9i SQL Reference in the Oracle Database Documentation Library

  
  

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

• UTF-8 in the SQL CHAR data types

  Specify AL32UTF8 for the database character set when you create the centralized database.

• UTF-16 in the SQL NCHAR data types

  Specify AL16UTF16 for the national character set when you create the centralized database.

Example 5-1 shows part of a CREATE DATABASE statement that sets the recommended database character set and 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
    ... ;