WebSphere Message Broker Configures ODBC connection (Oracle)

1. Windows Environment Configuration

Steps:

1. Click Start > Control Panel > Administrative Tools > Data source (ODBC)

2. Click the System DSN tab and click Add

3. Configure new DSN

4. Turn off ODBC Configuration, modify registry Click Start > run input REGEDIT, and click OK.

Open in Registry Editor,

Browse to : Hkey_local_machine\software\odbc\odbc. INI , locate the new DSN, and right-click the DSN entry. Select New > string value.

string: Workarounds values: 536870912 Close Registry Editor.

5. Open the ESB command line execution command:mqsisetdbparms blesb2-n myoracledb-u BLGROUP_OSP- P BLGROUP_OSP. where BLESB2 refers to the borker name,-nmyoracledb refers to the data source name, -ublgroup_osp refers to Oracle user name. - P blgroup_osp refers to the password. Successful execution,ODBC configuration succeeded.

2. Linux Environment Configuration

1. find esb installation directory /opt/ IBM/MQSI/9.0/ODBC/UNIXODBC odbc.ini                      Odbcinst.ini Span style= "" > file Copy to /home/wbiadmin/odbc (CP Odbc.ini                                    /home/wbiadmin/odbc,   CP Odbcinst.ini home/wbiadmin/ ODBC )

2. modified 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 to

Trace=no

Tracefile=/home/wbiadmin/odbctrace.out ( Trace output directory)

threading=2

4. to Odbc.ini, Odbcinst.ini Assign user groups (ESB users)

command:chown-r wbiadmin.wbiadmin/home/wbiadmin/odbc

5. config odbc environment variable, navigate to /var/mqsi/common/profiles modify suffix .sh                odbcini and odbcsysini (note odbcini The variable value of           to odbc.ini file, odbcsysini odbcinst.ini file directory

6. Close the command window and reopen the command window to test whether the environment variable is configured correctly. Navigate to /var/mqsi/common/profiles. Use ./opt/ibm/mqsi/9.0/bin/mqsiprofile detection. (Note: Each command window can be detected only once.) ）。

7. After successful detection, switch to ESB user execution command:mqsisetdbparms blesb2-n myoracledb-u Blgroup_osp-p Blgroup_osp. where BLESB2 refers to the borker name,-nmyoracledb refers to the data source name, -ublgroup_osp refers to the Oracle user name. - P blgroup_osp refers to the password. Successful execution,ODBC configuration succeeded.

Note: The configuration must be restarted after completion Broker, Command (mqsistop BLESB2 mqsistart BLESB2) .

Reference Documentation:

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

WebSphere Message Broker Configures ODBC connection (Oracle)