19c rac环境ebs并发请求会话控制

#### 请求会话控制,绑定MSC请求
*** --RAC Configuration Setup For Running MRP Planning, APS Planning,Data Collection Processes and Distributed Multi Node Transactions (Doc ID 279156.1)
1.在应用层tns ifile中添加如下信息：(跳过)
cd $TNS_ADMIN
cat >> $TNS_ADMIN/`echo $CONTEXT_NAME`_ifile.ora <<EOF
###add by xuwanxin at 20240328 for Doc ID 279156.1
BZCDB1=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsdb1-vip.dehetu.com)(PORT=1529))(CONNECT_DATA=(SERVICE_NAME=ebs_BZPROD)(INSTANCE_NAME=BZCDB1)))
BZCDB2=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsdb2-vip.dehetu.com)(PORT=1529))(CONNECT_DATA=(SERVICE_NAME=ebs_BZPROD)(INSTANCE_NAME=BZCDB2)))
EOF
cat $TNS_ADMIN/`echo $CONTEXT_NAME`_ifile.ora

2.绑定MRP&APS请求到固定节点
sqlplus apps/apps@BZPROD
create table APPLSYS.FND_CONC_PROG_ONSITE_INFO_240328 as select * from APPLSYS.FND_CONC_PROG_ONSITE_INFO;
select distinct connstr1,connstr2 from APPLSYS.FND_CONC_PROG_ONSITE_INFO;
update APPLSYS.FND_CONC_PROG_ONSITE_INFO set connstr1 = 'BZCDB1' where connstr1 ='BZPROD1';
update APPLSYS.FND_CONC_PROG_ONSITE_INFO set connstr1 = 'BZCDB2' where connstr1 ='BZPROD2';
select distinct connstr1,connstr2 from APPLSYS.FND_CONC_PROG_ONSITE_INFO;
commit;

update FND_CONC_PROG_ONSITE_INFO set connstr1 = 'BZCDB1',connstr2 = 'BZCDB2' where concurrent_program_id in
(select distinct concurrent_program_id
from fnd_concurrent_programs
where concurrent_program_name in
('MRCODW','MRCPLN','MRCPDW','MRCCPP','MRCCPP2','MRCCPP4','MRCCPP3','MRCCPP1','MRCNEW','MRCNSP','MRCMON','MRCSLD','MRCNSW','MRCSDW','MRCNCP','MRCOLP','MSDCPD','MSDPPM','MSDPBD','MSDPCC','MSDPSF','MSDPSO','MSDPSD','MSDPTD','MSDPUC','MSDCBD','MSDCCC','MSDCFD','MSDCLV','MSDCMF','MSDORG','MSDCSF','MSDCSO','MSDCSD','MSDCTD','MSDCUC','MSDCSCL','MSDPEV','MSDPFD','MSDPLV','MSDPMF','MSDPPD','MSDBDS','MSDBDC','MSDPDC','MSDPDP','MSDBDP','MSDBCP','MSCPDX','MSCATPDC','MSCATPDP','MSCNEW','MSCNSP','MSCNSW','MSCNCP','MSCPPW','MSCPDP','MSCPDPW','MSCAUTP','MSCAUTPW','MSCPDC','MSCPDCW','MSCPPM','MSCEPPM','MSCSDW','MSCMON','MSCSLD','MSCPLD','MSCPDW','MSCNSPWA64','MSCNSPWH64','MSCNSPWHPIA64','MSCNSPWL64','MSCNSPWS64','MSCNSWWA64','MSCNSWWH64','MSCNSWWHPIA64','MSCNSWWL64','MSCNSWWS64','MSCNWA64','MSCNWH64','MSCNWS64','MSCNWHPIA64','MSCNWL64','MSCNCPA64','MSCNCPH64','MSCNCPS64','MSCNSPA64','MSCNSPH64','MSCNSPS64','MSCNCPHPIA64','MSCNCPL64','MSRNEW','MSRNWA64','MSRNWH64','MSRNWS64','MSRNWHPIA64','MSRNWL64','MSCOLP','MSCODW','MSCOLPA64','MSCOLPH64','MSCOLPS64','MSCOLPHPIA64','MSCOLPL64','MSONEW','MSONWA64','MSONWH64','MSONWS64','MSONWHPIA64','MSONWL64','MSONCP','MSONCPA64','MSONCPH64','MSONCPS64','MSONSPA64','MSONSPH64','MSONSPS64','MSONCPHPIA64','MSONCPL64','MSOOLP','MSOOLPA64','MSOOLPH64','MSOOLPS64','MSOOLPHPIA64','MSOOLPL64','MSOOLS','MSOOLSPA64','MSOOLSH64','MSOOLSHPIA64','MSOOLSL64','MSOOLSS64','MSCHUBA','MSCHUBFI','MSCHUBO','MSDAPN','MSCFEX','MSCFEXF','MSCFEXW'));
commit;