$APPL_TOP
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2008.03.28 00:48
分类: EBS , Oracle_DBA
出处: http://moonsoft.itpub.net/post/15182/458433
---------------------------------------------------------------
客户化应用的时候都是在$APPL_TOP 进行，可是它在服务器里面时候哪个目录呢？有什么含义
Why I need shared APPL_TOP ?If you have two/three (Multiple) Middle Tier for Large User base then you have to install APPL_TOP, COMMON_TOP & ORA_TOP equal to number of Nodes in your configuration. So if you have three middle tier then you need these three top three times & if there are n nodes you need n time these three top's .
This result in lots of Space Requirement & bigger problem is patching so If you have 5 nodes you need to apply apps patch 5 times.
So Oracle Came Up with solution to have single APPL_TOP which is shared across all nodes in apps. This will save space as well patch timing. This concept of sharing APPL_TOP file system across all Middle Tier Nodes is called as APPL_TOP .
You will say if I can share APPL_TOP why Can't I share COMMON_TOP & ORA_TOP as well which are also part of Application Tier , Yes you can & this concept is called as Shared Application Tier.
select path from fnd_appl_tops
su - oravis
cd $APPL_TOP/
过程
SQL> conn / as sysdba;
Connected.
SQL> create tablespace APPS_NTK_CUX datafile '/erp/oraprod/proddata/ntkcux01.dbf'
size 50m autoextend on next 1m;
Tablespace created.
SQL> create user cux identified by cux default tablespace APPS_NTK_CUX
temporary tablespace temp;
SQL> grant connect,resource to cux;
Grant succeeded.
SQL> grant select any table to cux;
Grant succeeded.
2.在$APPL_TOP下建立CUX目录，并保证其目录下与其它fnd等目录一样
3.在$APPL_TOP/admin/<sid>_<hostname>.xml中加入cux_top
如
<CUX_TOP oa_var="s_cuxtop" oa_type="PROD_TOP" oa_enabled="FALSE">/erp/applprod/prodappl/cux/11.5.0</CUX_TOP>
4.停止应用,重新autocfg,再启动应用
cd $COMMON_TOP/admin/scripts/<SID>_<hostname>
./adautocfg.sh
./adstrtal.sh apps/apps
3.进入ＥＢＳ,系统管理员的身份登录系统，安全性->ORACLE->注册
数据库用户名 口令 权限 安装组 说明
cux cux 启用 １ Oracle二次开发管理系统帐户
4.切换职责应用开发者的职责进入系统，应用->注册
应用 简称 基本路径 说明
Oracle二次开发管理系统 CUX CUX_TOP Oracle二次开发管理系统
