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
- 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.
- Configure the [db] section for Oracle.
- Set the JDBC driver type. Set the driver type to either
thin
or OCI
.
- 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