福建省建设执业资格注册管理中心网站,东莞营销网站建设多少钱,万网衡水网站备案,电商网站建设考试题创建客户化应用目录 登录成 applxxx 用户 -- applxxx 改成所需用户名 # 以标准INV模块作为客户化应用目录的模板 cd $APPL_TOP mkdir -p cust cp -r inv cust/template cd cust # 删除template 目录下的文件#xff0c;只保留目录结构 cd $APPL_TOP/cust for rm_list in …创建客户化应用目录 登录成 applxxx 用户 -- applxxx 改成所需用户名 # 以标准INV模块作为客户化应用目录的模板 cd $APPL_TOP mkdir -p cust cp -r inv cust/template cd cust # 删除template 目录下的文件只保留目录结构 cd $APPL_TOP/cust for rm_list in find . -type f do rm $rm_list done # 复制客户化应用目录 cd $APPL_TOP/cust cp -r template cap cp -r template car cp -r template cce cp -r template ccm cp -r template cfa cp -r template cfnd cp -r template cgl cp -r template cinv cp -r template cnv cp -r template cpa cp -r template cper cp -r template cpo cp -r template if # 修改客户化应用目录版本号 cd $APPL_TOP/cust for a in ls do echo $a mv $a/12.0.0 $a/1.0.0 done # 删除template目录 cd $APPL_TOP/cust rm -rf template 创建客户化表空间 登录成 oraxxx 用户 -- oraxxx 改成所需用户名 sqlplus / as sysdba # 创建CUST_GENERAL_D存放客户化数据 create tablespace CUST_GENERAL_D datafile /datavg36/TFDEV/db/apps_st/data/cust_general_d01.dbf size 10m ; alter tablespace CUST_GENERAL_D add datafile /datavg36/TFDEV/db/apps_st/data/cust_general_d02.dbf size 10m ; alter tablespace CUST_GENERAL_D add datafile /datavg36/TFDEV/db/apps_st/data/cust_general_d03.dbf size 10m ; alter tablespace CUST_GENERAL_D add datafile /datavg36/TFDEV/db/apps_st/data/cust_general_d04.dbf size 10m ; alter tablespace CUST_GENERAL_D add datafile /datavg36/TFDEV/db/apps_st/data/cust_general_d05.dbf size 10m ; # 创建CUST_GENERAL_X存放客户化索引 create tablespace CUST_GENERAL_X datafile /datavg36/TFDEV/db/apps_st/data/cust_general_x01.dbf size 10m ; alter tablespace CUST_GENERAL_X add datafile /datavg36/TFDEV/db/apps_st/data/cust_general_x02.dbf size 10m ; alter tablespace CUST_GENERAL_X add datafile /datavg36/TFDEV/db/apps_st/data/cust_general_x03.dbf size 10m ; alter tablespace CUST_GENERAL_X add datafile /datavg36/TFDEV/db/apps_st/data/cust_general_x04.dbf size 10m ; alter tablespace CUST_GENERAL_X add datafile /datavg36/TFDEV/db/apps_st/data/cust_general_x05.dbf size 10m ; # 把CUST_GENERAL_D和CUST_GENERAL_X数据文件改为自动扩展并且设置最大扩展容量为2G。 select alter database datafile ||file_id|| autoextend on maxsize 2000m; from dba_data_files where tablespace_name like CUST_GENERAL%; # 执行以上生成的动态 ‘alter database datafile’ 语句 创建客户化应用的用户帐号 登录成 oraxxx 用户 -- oraxxx 改成所需用户名 sqlplus / as sysdba create user CAP identified by CAP default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CAR identified by CAR default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CCE identified by CCE default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CCM identified by CCM default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CFA identified by CFA default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CFND identified by CFND default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CGL identified by CGL default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CINV identified by CINV default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CNV identified by CNV default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CPA identified by CPA default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CPER identified by CPER default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CPO identified by CPO default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user IF identified by IF default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; 授权客户化应用的用户帐号基本权限 登录成 oraxxx 用户 -- oraxxx 改成所需用户名 sqlplus / as sysdba grant resource to cap; grant connect to cap; grant create table to cap; grant create view to cap; grant create procedure to cap; grant create synonym to cap; grant create sequence to cap; grant resource to car; grant connect to car; grant create table to car; grant create view to car; grant create procedure to car; grant create synonym to car; grant create sequence to car; grant resource to cce; grant connect to cce; grant create table to cce; grant create view to cce; grant create procedure to cce; grant create synonym to cce; grant create sequence to cce; grant resource to ccm; grant connect to ccm; grant create table to ccm; grant create view to ccm; grant create procedure to ccm; grant create synonym to ccm; grant create sequence to ccm; grant resource to cfa; grant connect to cfa; grant create table to cfa; grant create view to cfa; grant create procedure to cfa; grant create synonym to cfa; grant create sequence to cfa; grant resource to cfnd; grant connect to cfnd; grant create table to cfnd; grant create view to cfnd; grant create procedure to cfnd; grant create synonym to cfnd; grant create sequence to cfnd; grant resource to cgl; grant connect to cgl; grant create table to cgl; grant create view to cgl; grant create procedure to cgl; grant create synonym to cgl; grant create sequence to cgl; grant resource to cinv; grant connect to cinv; grant create table to cinv; grant create view to cinv; grant create procedure to cinv; grant create synonym to cinv; grant create sequence to cinv; grant resource to cnv; grant connect to cnv; grant create table to cnv; grant create view to cnv; grant create procedure to cnv; grant create synonym to cnv; grant create sequence to cnv; grant resource to cpa; grant connect to cpa; grant create table to cpa; grant create view to cpa; grant create procedure to cpa; grant create synonym to cpa; grant create sequence to cpa; grant resource to cper; grant connect to cper; grant create table to cper; grant create view to cper; grant create procedure to cper; grant create synonym to cper; grant create sequence to cper; grant resource to cpo; grant connect to cpo; grant create table to cpo; grant create view to cpo; grant create procedure to cpo; grant create synonym to cpo; grant create sequence to cpo; grant resource to if; grant connect to if; grant create table to if; grant create view to if; grant create procedure to if; grant create synonym to if; grant create sequence to if; 为客户化应用的用户帐号创建APPS_DDL和APPS_ARRAY_DDL存储过程 登录成 applxxx 用户 -- applxxx 改成所需用户名 # 执行命令如下 # 格式sqlplus apps/apps pwd $AD_TOP/patch/115/sql/AD script system pwd custom schema name custom schema pwd sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cap cap sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cap cap sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cap cap sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cap cap sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager car car sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager car car sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager car car sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager car car sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cce cce sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cce cce sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cce cce sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cce cce sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager ccm ccm sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager ccm ccm sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager ccm ccm sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager ccm ccm sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cfa cfa sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cfa cfa sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cfa cfa sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cfa cfa sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cfnd cfnd sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cfnd cfnd sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cfnd cfnd sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cfnd cfnd sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cgl cgl sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cgl cgl sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cgl cgl sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cgl cgl sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cinv cinv sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cinv cinv sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cinv cinv sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cinv cinv sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cnv cnv sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cnv cnv sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cnv cnv sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cnv cnv sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cpa cpa sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cpa cpa sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cpa cpa sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cpa cpa sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cper cper sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cper cper sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cper cper sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cper cper sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager cpo cpo sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager cpo cpo sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager cpo cpo sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager cpo cpo sqlplus apps/apps $AD_TOP/patch/115/sql/adaddls.pls manager if if sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddls.pls manager if if sqlplus apps/apps $AD_TOP/patch/115/sql/adaddlb.pls manager if if sqlplus apps/apps $AD_TOP/patch/115/sql/adaaddlb.pls manager if if 添加客户化应用的环境变量 登录成 applxxx 用户 -- applxxx 改成所需用户名 cp -p $CONTEXT_FILE $CONTEXT_FILE.bak.yymmdd vi $CONTEXT_FILE # 搜索AU_TOP字眼在AU_TOP下面增加如下客户化应用的路径然后保存文件 CAP_TOP oa_vars_captop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cap/1.0.0/CAP_TOP CAR_TOP oa_vars_cartop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/car/1.0.0/CAR_TOP CCE_TOP oa_vars_ccetop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cce/1.0.0/CCE_TOP CCM_TOP oa_vars_ccmtop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/ccm/1.0.0/CCM_TOP CFA_TOP oa_vars_cfatop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cfa/1.0.0/CFA_TOP CFND_TOP oa_vars_cfndtop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cfnd/1.0.0/CFND_TOP CGL_TOP oa_vars_cgltop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cgl/1.0.0/CGL_TOP CINV_TOP oa_vars_cinvtop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cinv/1.0.0/CINV_TOP CNV_TOP oa_vars_cnvtop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cnv/1.0.0/CNV_TOP CPA_TOP oa_vars_cpatop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cpa/1.0.0/CPA_TOP CPER_TOP oa_vars_cpertop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cper/1.0.0/CPER_TOP CPO_TOP oa_vars_cpotop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/cpo/1.0.0/CPO_TOP IF_TOP oa_vars_iftop oa_typePROD_TOP oa_enabledFALSE/datavg36/TFDEV/apps/apps_st/appl/cust/if/1.0.0/IF_TOP # 修改default.env内容增加客户化应用的路径然后保存文件 cp -p $INST_TOP/ora/10.1.2/forms/server/default.env $INST_TOP/ora/10.1.2/forms/server/default.env.bak.yymmdd vi $INST_TOP/ora/10.1.2/forms/server/default.env # 搜索AU_TOP字眼在AU_TOP下面增加如下客户化应用的路径然后保存文件 CAP_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cap/1.0.0 CAR_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/car/1.0.0 CCE_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cce/1.0.0 CCM_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/ccm/1.0.0 CFA_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cfa/1.0.0 CFND_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cfnd/1.0.0 CGL_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cgl/1.0.0 CINV_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cinv/1.0.0 CNV_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cnv/1.0.0 CPA_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cpa/1.0.0 CPER_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cper/1.0.0 CPO_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/cpo/1.0.0 IF_TOP/datavg36/TFDEV/apps/apps_st/appl/cust/if/1.0.0 # 必须退出applxxx 用户重新登录使新的客户化变量定义生效 # 重启应用服务 cd $INST_TOP/admin/scripts adstpall.sh apps/apps pwd -- 确认所有应用进程完全停下 adstrtal.sh apps/apps pwd 注册客户化应用 登录应用前台sysadmin 进入: 应用开发员 应用产品 注册 应用 简称 基本路径 说明 CMCC Alert Customization CCM CCM_TOP CMCC Alert Customization CMCC Application Object Library Customization CFND CFND_TOP CMCC Application Object Library Customization CMCC Assets Customization CFA CFA_TOP CMCC Assets Customization CMCC Cash Management Customization CCE CCE_TOP CMCC Cash Management Customization CMCC Conversion Program CNV CNV_TOP CMCC Conversion Program CMCC General Ledger Customization CGL CGL_TOP CMCC General Ledger Customization CMCC Human Resource CPER CPER_TOP CMCC Human Resource CMCC Interface Customization IF IF_TOP CMCC Interface Customization CMCC Inventory Customization CINV CINV_TOP CMCC Inventory Customization CMCC Payables Customization CAP CAP_TOP CMCC Payables Customization CMCC Project Accounting Customization CPA CPA_TOP CMCC Project Accounting Customization CMCC Purchasing Customization CPO CPO_TOP CMCC Purchasing Customization CMCC Receivables Customization CAR CAR_TOP CMCC Receivables Customization 注册Oracle用户 登录应用前台sysadmin 进入: 系统管理员 安全性 ORACLE 注册 数据库用户名 口令 权限 安装组 说明 CCM ccm 启用 0 CMCC Alert Customization CFND cfnd 启用 0 CMCC Application Object Library Customization CFA cfa 启用 0 CMCC Assets Customization CCE cce 启用 0 CMCC Cash Management Customization CNV cnv 启用 0 CMCC Conversion Program CGL cgl 启用 0 CMCC General Ledger Customization CPER cper 启用 0 CMCC Human Resource IF if 启用 0 CMCC Interface Customization CINV cinv 启用 0 CMCC Inventory Customization CAP cap 启用 0 CMCC Payables Customization CPA cpa 启用 0 CMCC Project Accounting Customization CPO cpo 启用 0 CMCC Purchasing Customization CAR car 启用 0 CMCC Receivables Customization 定义数据组 登录应用前台sysadmin 进入: 系统管理员 安全性 ORACLE 数据组 数据组标准 说明Standard Data Group 应用 Oracle标识 说明 CMCC Alert Customization APPS CMCC Application Object Library Customization APPS CMCC Assets Customization APPS CMCC Cash Management Customization APPS CMCC Conversion Program APPS CMCC General Ledger Customization APPS CMCC Human Resource APPS CMCC Interface Customization APPS CMCC Inventory Customization APPS CMCC Payables Customization APPS CMCC Project Accounting Customization APPS CMCC Purchasing Customization APPS CMCC Receivables Customization APPS 定义预警客户化应用 登录应用前台sysadmin 进入: 预警系统管理器 System Installations 应用 Oracle用户名 状态 CMCC Alert Customization CCM 自定义 CMCC Application Object Library Customization CFND 自定义 CMCC Assets Customization CFA 自定义 CMCC Cash Management Customization CCE 自定义 CMCC Conversion Program CNV 自定义 CMCC General Ledger Customization CGL 自定义 CMCC Human Resource CPER 自定义 CMCC Interface Customization IF 自定义 CMCC Inventory Customization CINV 自定义 CMCC Payables Customization CAP 自定义 CMCC Project Accounting Customization CPA 自定义 CMCC Purchasing Customization CPO 自定义 CMCC Receivables Customization CAR 自定义
