WMB 8.0.0.2 在linux下面怎么配置连接ORACLE数据库
各位,碰到个问题,搞了一下午到现在还没弄好,问题如题,我按照infocenter的说明一步一步配置,结果还没做好,主要步骤是:
1.首先安装IE02
2.拷贝安装包中的ODBC.ini和ODBCINST.INI文件到/var/mqsi下,并将这两个文件的属组修改为mqm:mqbrkrs,权限为:-rwxr-xr-x,ll命令后的结果:
-rwxr-xr-x 1 mqm mqbrkrs 4949 Jun 25 05:07 odbc.ini
-rwxr-xr-x 1 mqm mqbrkrs 997 Dec 10 2013 odbcinst.ini
3.修改ODBC.ini文件中的属性,主要是:
;# Oracle stanza
[soadb]
Driver=/opt/ibm/mqsi/8.0.0.2/ODBC64/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle Wire Protocol
HostName=soadb.server
PortNumber=1521
ServiceName=orcl
4.配置环境变量:
IE02_PATH=/opt/ibm/IE02/2.0.0
ODBCINI=/var/mqsi/odbc.ini
ODBCSYSINI=/var/mqsi/odbcinst.ini
5.执行命令:
mqsisetdbparms BRK_TEST -n soadb -u test -p test123
结果测试却连不上,报错如下:
( ['MQROOT' : 0x7fd154132860]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = '/build/slot1/S800_P/src/DataFlowEngine/ImbDatabaseNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 320 (INTEGER)
(0x03000000:NameValue):Function = 'ImbDatabaseNode::evaluate' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmDatabaseNode' (CHARACTER)
(0x03000000:NameValue):Name = 'gen/LQ_WS_TEST#FCMComposite_1_3' (CHARACTER)
(0x03000000:NameValue):Label = 'gen.LQ_WS_TEST.saveInputLog' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Caught exception and rethrowing' (CHARACTER)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 1645 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcConnection::connectNonCoordinated' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2393 (INTEGER)
(0x03000000:NameValue):Text = 'Root SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '-1' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'SOADB' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 14 (INTEGER)
(0x03000000:NameValue):Text = '' (CHARACTER)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 1658 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcConnection::connectNonCoordinated' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2347 (INTEGER)
(0x03000000:NameValue):Text = 'Child SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'IM002' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '0' (CHARACTER)
)
)
请大神们帮忙啊