Se il flusso di messaggi interagisce con un database Oracle e si desidera coordinare gli aggiornamenti fatti al database con altre azioni all'interno del flusso di messaggi, configurare il broker per gestire questi aggiornamenti.
Prima di iniziare:
Per completare questa attività, è necessario completare prima quella che segue:
Le seguenti istruzioni descrivono la modalità di configurazione delle origini dati di Oracle per il coordinamento XA. Per ulteriori informazioni sulla configurazione di Oracle per il coordinamento XA con WebSphere MQ, consultare la sezione intitolata "configurazione di Oracle" su WebSphere MQ System Administration.
Per configurare le origini dati Oracle per la coordinazione XA utilizzando WebSphere MQ Versione 5.0 come coordinatore di transazione:
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID+ACC=P/MyUserId/MyPassword+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=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+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=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+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=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKoradtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
Campo | Valore |
---|---|
SwitchFile | C:\Program Files\IBM\MQSI\6.0\bin\UKor8dtc20.dll |
XAOpenString | ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ |
ThreadOfControl | THREAD |
Per configurare le origini dati Oracle per la coordinazione XA utilizzando WebSphere MQ Versione 6.0 come coordinatore di transazione:
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.sl XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKoradtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
Campo | Valore |
---|---|
SwitchFile | UKor8dtc20.dll |
XAOpenString | ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ |
ThreadOfControl | THREAD |