Siebel Installations >  Add a new language to Siebel

Adding languages in Siebel has two parts. The first part is selecting the other languages
during the Siebel server installation. It is a long task and I will not cover it here.
After that we need to add this language to the dbsrvr in Siebel and import repositories.
This is a 3 step task. Here the new language that was added is Czech. The 4 stages and the screen output are written below.


Stage 1 create UCF file


You should be logged in as Siebel. This used Solaris 10 and siebel 8.1.1.4
SIEBEL_ROOT/siebsrvr> . ./dbenv.sh
SIEBEL_ROOT/siebsrvr> cd bin
SIEBEL_ROOT/siebsrvr/bin> ./ssincfgw -is:javaconsole -console -args LANG= ENU MODEL_FILE= SIEBEL_ROOT/siebsrvr/admin/dbsrvr.scm
InstallShield Wizard

Initializing InstallShield Wizard...

Preparing Java(tm) Virtual Machine...
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
....................
Running InstallShield Wizard...

-------------------------------------------------------------------------------
[X] 1 - Configure Product in Live Mode
[ ] 2 - Configure Product for Offline Deployment
[ ] 3 - Exit Configuration Wizard

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Select a Configuration Task:

[X] 1 - Database Configuration Utilities
[ ] 2 - Siebel Server Configuration

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Directory where the Siebel Server is installed

Siebel Server Directory [SIEBEL_ROOT/siebsrvr]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Directory where the Siebel Database Server is installed

Siebel Database Server Directory [SIEBEL_ROOT/dbsrvr]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Choose the appropriate database platform

[ ] 1 - IBM DB2 UDB for Linux UNIX Windows
[X] 2 - Oracle Database Enterprise Edition

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
[X] 1 - Install Database
[ ] 2 - Upgrade Database
[ ] 3 - Apply Additive Schema Changes
[ ] 4 - Import/Export Repository
[ ] 5 - Migrate Repository
[ ] 6 - Run Database Utilities

To select an item enter its number, or 0 when you are finished: [0]
-------------------------------------------------------------------------------
[X] 1 - Install Siebel Database
[ ] 2 - Add a language to an existing Siebel Database

To select an item enter its number, or 0 when you are finished: [0] 2


[ ] 1 - Install Siebel Database
[X] 2 - Add a language to an existing Siebel Database

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Please confirm that you wish to install a new Siebel database. Running this
step against an existing Siebel database may make that database unusable.


To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
The GRANTUSR.SQL script must first be run by the database administrator (DBA)
in order to create the necessary Siebel users and roles before continuing.


To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Select the base language (also called primary language) from the list

[ ] 1 - Czech
[X] 2 - English (American)

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Select the language to add to the database from the list

[ ] 1 - Czech
[X] 2 - English (American)

To select an item enter its number, or 0 when you are finished: [0] 1


[X] 1 - Czech
[ ] 2 - English (American)

To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Enter a valid ODBC (Open Database Connectivity) Data Source Name to access the
Siebel Database connection. Default value is Siebel_DSN.

ODBC Data Source Name [] SIEBEL_DSN


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Siebel Database User Name
Siebel Database Password

Database User Name [] SADMIN


Database Password:


Database Password--(confirm):


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Siebel Database Table Owner
Siebel Database Table Owner password

Database Table Owner [] SIEBEL


Database Table Owner Password:
Database Table Owner Password:

Database Table Owner Password--(confirm):


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Repository Name [Siebel Repository]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Please indicate if the target server will use the Oracle Parallel Indexing
option:

[X] 1 - Does not use the Oracle Parallel Indexing option
[ ] 2 - Uses the Oracle Parallel Indexing option

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Identifies an authorization ID designated for a group of Siebel users defined
in a mainframe security package


Security Group ID / Grantee [SSE_ROLE]


Log Output Directory [install_lang]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Configuration is complete: your output will be saved under
$SiebelRoot/siebsrvr/bin/master_<process>.ucf. To deploy the process you
configured to the database please run the below command line:
$SiebelRoot/siebsrvr/bin/srvrupgwiz /m master_<process>.ucf


To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
title The Siebel Configuration Wizard will execute Database Configuration Utilities using the following settings:

-------------------------------------------------------------------------------
The Siebel Configuration Wizard will execute Database Configuration Utilities
using the following settings:

Siebel Server Directory : SIEBEL_ROOT/siebsrvr
Siebel Database Server Directory : SIEBEL_ROOT/dbsrvr
RDBMS Platform : Oracle Database Enterprise Edition
Siebel Database Operation : Install Database
Select Installation Operation : Add a language to an existing Siebel Database
Please confirm that you wish to install a new Siebel database. Running this
step against an existing Siebel database may make that database unusable. :
The GRANTUSR.SQL script must first be run by the database administrator (DBA)
in order to create the necessary Siebel users and roles before continuing. :
Base Language : English (American)
Language Temp : Czech
Language Selection : CSY
Language Selection : ENU
ODBC Data Source Name : SIEBEL_DSN
Database User Name : SADMIN
Database Password : ********
Database Table Owner : SIEBEL
Database Table Owner Password : ********
Repository Name : Siebel Repository
Oracle Parallel Index : Does not use the Oracle Parallel Indexing option

Press ENTER to read the text [Type q to quit]

Security Group ID / Grantee : SSE_ROLE
Log Output Directory : install_lang
Configuration is complete: your output will be saved under
$SiebelRoot/siebsrvr/bin/master_<process>.ucf. To deploy the process you
configured to the database please run the below command line:
$SiebelRoot/siebsrvr/bin/srvrupgwiz /m master_<process>.ucf :

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

1. Yes
2. No

Do you want to execute configuration? [2] 1

Execution Successful.

-------------------------------------------------------------------------------
[X] 1 - Configure Product in Live Mode
[ ] 2 - Configure Product for Offline Deployment
[ ] 3 - Exit Configuration Wizard

To select an item enter its number, or 0 when you are finished: [0] 3


[ ] 1 - Configure Product in Live Mode
[ ] 2 - Configure Product for Offline Deployment
[X] 3 - Exit Configuration Wizard

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
SIEBEL_ROOT/siebsrvr/bin>

 

Stage two - deploy the Czech repository

SIEBEL_ROOT/siebsrvr> . ./dbenv.sh
SIEBEL_ROOT/siebsrvr> cd bin
nohup srvrupgwiz /m master_install_lang.ucf &
the nohup file is in the local folder CSY fix

Stage 3 - adding czech MLOVs

SIEBEL_ROOT/siebsrvr> . ./dbenv.sh
SIEBEL_ROOT/siebsrvr> cd bin
SIEBEL_ROOT/siebsrvr/bin> ./ssincfgw -is:javaconsole -console -args LANG= ENU MODEL_FILE= SIEBEL_ROOT/siebsrvr/admin/dbsrvr.scm

InstallShield Wizard

Initializing InstallShield Wizard...

Preparing Java(tm) Virtual Machine...
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
......................
Running InstallShield Wizard...

-------------------------------------------------------------------------------
[X] 1 - Configure Product in Live Mode
[ ] 2 - Configure Product for Offline Deployment
[ ] 3 - Exit Configuration Wizard

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Select a Configuration Task:

[X] 1 - Database Configuration Utilities
[ ] 2 - Siebel Server Configuration

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Directory where the Siebel Server is installed

Siebel Server Directory [SIEBEL_ROOT/siebsrvr]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Directory where the Siebel Database Server is installed

Siebel Database Server Directory [SIEBEL_ROOT/dbsrvr]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Choose the appropriate database platform

[ ] 1 - IBM DB2 UDB for Linux UNIX Windows
[X] 2 - Oracle Database Enterprise Edition

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
[X] 1 - Install Database
[ ] 2 - Upgrade Database
[ ] 3 - Apply Additive Schema Changes
[ ] 4 - Import/Export Repository
[ ] 5 - Migrate Repository
[ ] 6 - Run Database Utilities

To select an item enter its number, or 0 when you are finished: [0] 6


[ ] 1 - Install Database
[ ] 2 - Upgrade Database
[ ] 3 - Apply Additive Schema Changes
[ ] 4 - Import/Export Repository
[ ] 5 - Migrate Repository
[X] 6 - Run Database Utilities

To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Select one of the following Database utilities options

[X] 1 - Synchronize Schema Definition
[ ] 2 - Universal Time Code Conversion
[ ] 3 - Multilingual List of Value Conversion

To select an item enter its number, or 0 when you are finished: [0] 3


[ ] 1 - Synchronize Schema Definition
[ ] 2 - Universal Time Code Conversion
[X] 3 - Multilingual List of Value Conversion

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Select Validate to review the repository for LOV data problems and write them
to a log file. Select Translate to replace LOV display strings with language
independent code.

[X] 1 - Validate
[ ] 2 - Translate

To select an item enter its number, or 0 when you are finished: [0] 2


[ ] 1 - Validate
[X] 2 - Translate

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Select the base language (also called primary language) from the list

[ ] 1 - Czech
[X] 2 - English (American)

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Enter a valid ODBC (Open Database Connectivity) Data Source Name to access the
Siebel Database connection. Default value is Siebel_DSN.

ODBC Data Source Name [] SIEBEL_DSN


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Siebel Database User Name
Siebel Database Password

Database User Name [] SADMIN


Database Password:


Database Password--(confirm):


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Siebel Database Table Owner
Siebel Database Table Owner password

Siebel Database Table Owner
Siebel Database Table Owner password

Database Table Owner [] SIEBEL


Database Table Owner Password:


Database Table Owner Password--(confirm):


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Name of the repository you want to upgrade to MLOV.

Repository Name [Siebel Repository]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Please indicate if the target server will use the Oracle Parallel Indexing
option:

[X] 1 - Does not use the Oracle Parallel Indexing option
[ ] 2 - Uses the Oracle Parallel Indexing option

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Identifies an authorization ID designated for a group of Siebel users defined
in a mainframe security package


Security Group ID / Grantee [SSE_ROLE]


Log Output Directory [mlov_translate]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Configuration is complete: your output will be saved under
$SiebelRoot/siebsrvr/bin/master_<process>.ucf. To deploy the process you
configured to the database please run the below command line:
$SiebelRoot/siebsrvr/bin/srvrupgwiz /m master_<process>.ucf


To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
title The Siebel Configuration Wizard will execute Database Configuration Utilities using the following settings:

-------------------------------------------------------------------------------
The Siebel Configuration Wizard will execute Database Configuration Utilities
using the following settings:

Siebel Server Directory : SIEBEL_ROOT/siebsrvr
Siebel Database Server Directory : SIEBEL_ROOT/dbsrvr
RDBMS Platform : Oracle Database Enterprise Edition
Siebel Database Operation : Run Database Utilities
Database Utility Selection : Multilingual List of Value Conversion
MLOV Operation : Translate
Base Language : English (American)
Language Selection : ENU
ODBC Data Source Name : SIEBEL_DSN
Database User Name : SADMIN
Database Password : ********
Database Table Owner : SIEBEL
Database Table Owner Password : ********
Repository Name : Siebel Repository
Oracle Parallel Index : Does not use the Oracle Parallel Indexing option
Security Group ID / Grantee : SSE_ROLE
Log Output Directory : mlov_translate
Configuration is complete: your output will be saved under
$SiebelRoot/siebsrvr/bin/master_<process>.ucf. To deploy the process you
configured to the database please run the below command line:

Press ENTER to read the text [Type q to quit]

$SiebelRoot/siebsrvr/bin/srvrupgwiz /m master_<process>.ucf :

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

1. Yes
2. No

Do you want to execute configuration? [2] 1

Execution Successful.

-------------------------------------------------------------------------------
[X] 1 - Configure Product in Live Mode
[ ] 2 - Configure Product for Offline Deployment
[ ] 3 - Exit Configuration Wizard

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Select a Configuration Task:

[X] 1 - Database Configuration Utilities
[ ] 2 - Siebel Server Configuration

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 3

1. Yes
2. No

Do you want to exit? [2] 1
1 - Yes
2 - No
Do you want to save the response file? 1
Specify the response filename: mlov_response_file
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0xf072dc88, pid=1656, tid=24
#
# Java VM: Java HotSpot(TM) Server VM (1.5.0_01-b08 mixed mode)
# Problematic frame:
# C [libssicfeng.so+0x4dc88] __1cMicfUserValuePgenResponseFile6MpnMicfProcModel_pkH_i_+0x108
#
# An error report file with more information is saved as hs_err_pid1656.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#
Abort - core dumped


Stage -4 - we have to execute the mlov using UCF

SIEBEL_ROOT/siebsrvr> . ./dbenv.sh
SIEBEL_ROOT/siebsrvr> cd bin
SIEBEL_ROOT/siebsrvr> nohup srvrupgwiz /m master_mlov_translate.ucf &

After the results, we could log into the CSY object manager.