Configure ODBC connection (oracle) and webspherebroker for websphere message broker

Configure ODBC connection (oracle) and webspherebroker for websphere message broker

1. Windows environment Configuration

Steps:

1. Click Start> Control Panel> Management Tools> data source (ODBC)

2. Click the system DSN tab and click Add

3. Configure to create a DSN

4. Disable ODBC configuration, modify the registry, click Start> Run, enter REGEDIT, and click OK.

Open in Registry Editor,

 

Browse to: HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC. INI, find the new DSN, and right-click the DSN entry. Choose new> string value.

String: WorkArounds value: 536870912 Close Registry Editor.

5. Open the ESB command line and execute the command: mqsisetdbparms BLESB2-n MYORACLEDB-u blgroup_osp-p blgroup_osp. BLESB2 refers to the borker name,-nMYORACLEDB refers to the data source name, and-ublgroup_osp refers to the oracle user name. -P blgroup_osp indicates the password. The ODBC configuration is successful.

 

2. Linux environment Configuration

1. Find the/opt/ibm/mqsi/9.0/ODBC/unixodbc sample file odbc. ini odbcinst. ini in the ESB installation directory and copy it to/home/wbiadmin/odbc. Command (cp odbc. ini/home/wbiadmin/odbc, cp odbcinst. ini home/wbiadmin/odbc)

2. Modify odbc. ini to: # Oracle stanza

[MYORACLEDB] (data source name)

Driver =/opt/ibm/mqsi/9.0/ODBC/V7.0/lib/UKora26.so

Description = DataDirect ODBC 7.0 Oracle Wire Protocol

HostName = 192.168.100.104 (oracle HOST)

PortNumber = 1521 (oracle port)

ServiceName = orcl (Service name)

CatalogOptions = 0

EnableStaticCursorsForLongData = 0

ApplicationUsingThreads = 1

EnableDescribeParam = 1

OptimizePrepare = 1

WorkArounds = 536870912

ProcedureRetResults = 1

ColumnSizeAsCharacter = 1

LoginTimeout = 0

 

[ODBC]

InstallDir =/opt/ibm/mqsi/9.0/ODBC/V7.0 (ESB installation directory)

UseCursorLib = 0

IANAAppCodePage = 4

UNICODE = UTF-8

3. Modify odncinst. ini

Trace = no

TraceFile =/home/wbiadmin/odbctrace. out (trace output directory)

Threading = 2

4. Assign the user group (ESB user) to odbc. ini and odbcinst. ini)

Command: chown-R wbiadmin. wbiadmin/home/wbiadmin/odbc

5. Configure odbc environment variables and locate the file with the/var/mqsi/common/profiles suffix. sh. Add two environment variables ODBCINI and ODBCSYSINI (note that the variable value of ODBCINI is located in the odbc. ini file, and the ODBCSYSINI is located in the odbcinst. ini file directory)

6. Close the command window and re-open the command window to test whether environment variables are correctly configured. Go to/var/mqsi/common/profiles. Use./opt/ibm/mqsi/9.0/bin/mqsiprofile for detection. (Note: Each Command window can only be detected once .).

7. Switch to the ESB user and run the command: mqsisetdbparms BLESB2-n MYORACLEDB-u blgroup_osp-p blgroup_osp. BLESB2 refers to the borker name,-nMYORACLEDB refers to the data source name, and-ublgroup_osp refers to the oracle user name. -P blgroup_osp indicates the password. The ODBC configuration is successful.

Note: After the configuration is complete, restart the broker and run the command (mqsistop BLESB2 mqsistart BLESB2 ).

Reference:

Http://www-01.ibm.com/support/knowledgecenter/SSMKHH_9.0.0/com.ibm.etools.mft.doc/bk58060_.htm? Lang = zh