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

Source: Internet
Author: User
Tags odbc connection

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


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.