Note |
---|
icon | false |
---|
title | Failover Behavior |
---|
|
Oracle Transparent Application Failover (TAF) and Fast Connection Failover (FCF) are not supported. Instead, the Bridge BRIDGE uses an database independent replay mechanism for its Perstistent State persistency. This mechanism works only if TAF and FCF are switched off. |
Installing the SQL Client Tools for Oracle
E2E Bridge The BRIDGE supports Oracle since version 7.
Install the Oracle client tools and define the tnsnames.ora to open a successful connection to the database.
Panel |
---|
borderColor | #7ea112#EAA01E |
---|
bgColor | white |
---|
borderWidth | 32 |
---|
borderStyle | solid |
---|
|
Linux: - Log-in as a root user.
Download the Oracle Instant Client Package - Basic, e.g. version 10.2.0.3. Note that you need a 64bit version when running a 64bit E2E xUML RuntimeRUNTIME. For OpenSUSE download the rpm package and start the installer: Code Block |
---|
| rpm -U oracle-instantclient-basic-10.2.0.3-1.i386.rpm |
Create the following link on the host: Code Block |
---|
| cd /usr/lib/oracle/10.2.0.3/client/lib
ln -s libclntsh.so.10.1 libclntsh.so |
Multiexcerpt |
---|
MultiExcerptName | language_settings |
---|
| To avoid encoding problems, such as special characters being messed up (e.g. the German umlauts), configure the language settings (NLS_LANG) in the Oracle database preferences for a Bridge BRIDGE installation on Unix (see further below, 569442554 Defining the Oracle Database Preferences on the BRIDGE). Furthermore, in the UML model, set the tag charset="utf-8" on the database alias in the component diagram. Using that configuration the database client (BridgeBRIDGE) and the database server use the same encoding: strings in the xUML Runtime RUNTIME are Unicode, the database client uses Unicode (step 2) and Unicode is used between Oracle client and server (step 1). If native database storage is not Unicode, the Oracle server can convert the data. |
|
Defining the Oracle Database Preferences on the
...
BRIDGE
Multiexcerpt include |
---|
MultiExcerptName | Database Preferences |
---|
nopanel | true |
---|
PageWithExcerpt | Installing and Configuring Database Access for DB2 |
---|
|
...
Key | Value | Example |
---|
ORACLE_HOME | Path to the Oracle client. | D:\Oracle\ora11g |
NLS_LANG | Oracle language settings (Unix only) | AMERICAN_AMERICA.AL32UTF8 |
TNS_ADMIN | Path to the Oracle configuration sqlnet.ora (optional) | D:\Oracle\ora11g |
Notetip |
---|
|
If the path is already specified in the environment variables of your operating system, you do not have to set this parameter. |
...