如果您的消息流与 Oracle 数据库进行交互,且您想要根据消息流内其他操作协调用于数据库的更新,请配置代理以管理这些更新。
开始之前:
要执行此任务,必须先完成下列任务:
如果要在协同的事务中使用 Oracle:
请参阅为安装的 WebSphere MQ 版本提供的信息:
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.sl XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
SwitchFile:C:\WMQI\BIN\UKor8dtc20.dll
XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID
+ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+
ThreadOfControl:THREAD
如果要在协同的事务中使用 Oracle:
下列示例说明在 UNIX 系统上的 qm.ini 文件中的 XAResourceManager 节中必须包含的内容,以及同等 Windows 平台信息:
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.sl XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
SwitchFile: UKor8dtc20.dll XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ ThreadOfControl:THREAD