2.6 把客户化的环境变量加入到context file中(具体路径根据实际路径修改)
vi $CONTEXT_FILE
加到ZX_TOP(在$CONTEXT_FILE中搜索)下面,例如:
Global erp:
2.7 停应用,执行autoconfig
cd $ADMIN_SCRIPTS_HOME
adstpall.sh apps/passwd
cd $ADMIN_SCRIPTS_HOME
adautocfg.sh
2.8 清理并发管理器节点定义,并修改并发管理器数量为1 (数据库层)
UPDATE fnd_concurrent_requests SET phase_code = 'C',status_code = 'D' WHERE phase_code <> 'C';
commit;
update fnd_concurrent_queue_size set min_processes=1,max_processes=1 where min_processes>1;
commit;
update fnd_concurrent_queues set min_processes=1,max_processes=1,target_processes=1 where min_processes>1;
commit;
update apps.fnd_concurrent_queues set target_node=null,node_name=null,node_name2=null;
commit;
在数据库层运行cmclean.sql脚本 (Clean out the concurrent manager tables) ,用apps用户执行
$ sqlplus /nolog
SQL> connect apps/passwd
SQL> @cmclean.sql (按照提示输入dual)