- 创建客户化应用目录
| 登录成 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_var="s_captop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cap/1.0.0</CAP_TOP> <CAR_TOP oa_var="s_cartop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/car/1.0.0</CAR_TOP> <CCE_TOP oa_var="s_ccetop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cce/1.0.0</CCE_TOP> <CCM_TOP oa_var="s_ccmtop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/ccm/1.0.0</CCM_TOP> <CFA_TOP oa_var="s_cfatop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cfa/1.0.0</CFA_TOP> <CFND_TOP oa_var="s_cfndtop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cfnd/1.0.0</CFND_TOP> <CGL_TOP oa_var="s_cgltop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cgl/1.0.0</CGL_TOP> <CINV_TOP oa_var="s_cinvtop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cinv/1.0.0</CINV_TOP> <CNV_TOP oa_var="s_cnvtop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cnv/1.0.0</CNV_TOP> <CPA_TOP oa_var="s_cpatop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cpa/1.0.0</CPA_TOP> <CPER_TOP oa_var="s_cpertop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cper/1.0.0</CPER_TOP> <CPO_TOP oa_var="s_cpotop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cpo/1.0.0</CPO_TOP> <IF_TOP oa_var="s_iftop" oa_type="PROD_TOP" oa_enabled="FALSE">/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 进入: 应用开发员> 应用产品> 注册
|
- 注册Oracle用户
| 登录应用前台sysadmin 进入: 系统管理员> 安全性> ORACLE> 注册
|
- 定义数据组
| 登录应用前台sysadmin 进入: 系统管理员> 安全性> ORACLE> 数据组 数据组：标准 说明：Standard Data Group
|
- 定义预警客户化应用
| 登录应用前台sysadmin 进入: 预警系统管理器> System> Installations
|
