How To
Summary
By default ITIC users must enter Oracle SID to connect to Oracle database. In some cases Customers want to use the Service Name instead.
Steps
To use Service Name in the data source do the following:
1. Open <ITIC>\data\properties\jdbcinfo.properties
2. Modify the oracle1.urlFormat line as follows:
oracle1.urlFormat=jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=<HOST_SID>))(ADDRESS_LIST=(ADDRESS=(HOST=<HOST_NAME>)(PORT=<HOST_PORT>)(PROTOCOL=TCP))))
3. Save the file.
4. When provide connection information on Data Source screen, enter service name in SID field.
2. Modify the oracle1.urlFormat line as follows:
oracle1.urlFormat=jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=<HOST_SID>))(ADDRESS_LIST=(ADDRESS=(HOST=<HOST_NAME>)(PORT=<HOST_PORT>)(PROTOCOL=TCP))))
3. Save the file.
4. When provide connection information on Data Source screen, enter service name in SID field.
To use Service Name in ITIC repository connection string in fusion.properties do the following:
1. Open <ITIC>\data\properties\fusion.properties
2. Modify the mxe.db.url line as follows:
mxe.db.url=jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=<HOST_SERVICENAME>))(ADDRESS_LIST=(ADDRESS=(HOST=<HOST_NAME>)(PORT=<HOST_PORT>)(PROTOCOL=TCP))))
Replace <HOST_SERVICENAME>, <HOST_NAME> and <HOST_PORT> with actual values
3. Save the file.
4. Restart the ITIC
2. Modify the mxe.db.url line as follows:
mxe.db.url=jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=<HOST_SERVICENAME>))(ADDRESS_LIST=(ADDRESS=(HOST=<HOST_NAME>)(PORT=<HOST_PORT>)(PROTOCOL=TCP))))
Replace <HOST_SERVICENAME>, <HOST_NAME> and <HOST_PORT> with actual values
3. Save the file.
4. Restart the ITIC
Additional Information
ITIC 7.6.0.3 HF7 with APAR IJ20076 fix or later is required.
Document Location
Worldwide
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSQHAB","label":"Tivoli Integration Composer"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
More support for:
Tivoli Integration Composer
Software version:
All Versions
Operating system(s):
Linux, Windows
Document number:
1087762
Modified date:
15 October 2019
UID
ibm11087762
Manage My Notification Subscriptions