Setting Oracle parameters

Ensure that you set the following Oracle parameters.

About this task

Oracle supports the following JDBC driver types:
thin
This type is the default type.
OCI
The OCI driver allows the use of TAF (Transparent Application Failover) for RAC (Real Application Cluster) installations.
You can use either driver type with IBM® InfoSphere® Master Data Management Collaboration Server - Collaborative Edition.

Procedure

  1. Configure the [db.<type>] section, which corresponds to the value of type in the database section.
    For example, if you are using Oracle, set type=oracle in the database section and configure the [db.oracle] section.
  2. Configure the [db] section for Oracle.
    1. Set the JDBC driver type. Set the driver type to either thin or OCI.
  3. Configure the [db.oracle] sections for Oracle.
    instance
    The name of the Oracle instance. The instance that is used in the JDBC connect string and the SQLPlus connect string if the tns_name parameter is not set.
    tns_name
    This parameter is in the [db.oracle] section in the env_settings.ini file. The TNS name is used by SQLPLus to connect to the database. Set this section only if the SQLPlus uses a different name to connect to the database other than JDBC. This parameter defaults to the value of the instance parameter, therefore, tns_name must be set when the client connection differs from the SID of the database.
    SID
    Oracle System Identification (SID) is unique for each Oracle database system. Oracle SID identifies the system and SERVICE_NAME identifies the remove service. This parameter is in the [db.oracle] section in the env_settings.ini file.
    success_token
    If the Oracle database client used is in a language other than English, in order for the test_db.sh script and other shell scripts to work, specify in this parameter the text that is returned when a successful connection is made to the Oracle database server.

Example

Here is a simple example:
(Database SID = 'mydb', client uses  'mydb' to connect using sqlplus

[db]
type-=oracle
username=dbuesr
password=somepwd
home=/opt/oracle/app/product/11.1.0/db_1
hostname=my-dbserver.company.com
port=1525


[db.oracle]
instance=mydb

Here is an example where the SQLPlus is different from SID:

(Database SID = 'mdmpim', client uses  'mydb' to connect using sqlplus

[db]
type-=oracle
username=dbuesr
password=somepwd
home=/opt/oracle/app/product/11.1.0/db_1
hostname=my-dbserver.company.com
port=1525


[db.oracle]
instance=mydb
tns_name=mdmpim