CUSTOM_TOP Creation :-
1) Create Read only user (appldev) on os level
2) appldev user id should be member of appldev group
applmgr need to be secondary member of appldev group
ex:
id applmgr
uid=504(applmgr) gid=501(dba) groups=501(dba),503(appldev)
3) Create following structure with Developer userid (appldev) at home location(/home/appldev) at OS level:
Step 1> Create the directory structure.
mkdir -p XXCUS
mkdir -p XXCUS/12.0.0/admin/sql
mkdir -p XXCUS/12.0.0/admin/odf
mkdir -p XXCUS/12.0.0/sql
mkdir -p XXCUS/12.0.0/bin
mkdir -p XXCUS/12.0.0/reports/US
mkdir -p XXCUS/12.0.0/forms/US
mkdir -p XXCUS/12.0.0/lib
mkdir -p XXCUS/12.0.0/out
mkdir -p XXCUS/12.0.0/log
mkdir -p XXCUS/12.0.0/java/classes
4) Create a soft link using the following command(Login as applmgr user and go to $APPL_TOP)
ln -s /home/appldev/XXCUS XXCUS
5) Login to oracle user and connect to database,Now create a tablespace and schema for custom top (XXCUS).
create tablespace XXCUS datafile '/u01/oracle/VIS/db/apps_st/data/XXCUS01.dbf' size 1000m;
create user XXCUS identified by XXCUS default tablespace XXCUS;
grant connect, resource to XXCUS;
6) Register and add datagroup of custom user and custom Application with Oracle application using system admin responsibility.
Security-->Oracle-->Register (register XXCUS user)
Naviate to Security-->Oracle-->Register
Database User Name = XXCUS
Password = XXCUS
Privilege = Enabled
Install Group = 0
Description = XXCUS Custom Application User
Application-->Register (register custom application)
Navigate to Application-->Register
Application = XXCUS Custom Application
Short Name = XXCUS
Basepath = XXCUS_TOP
Description = XXCUS Custom Application
Security-->Oracle-->DataGroup (add custom application under datagroup)
Navigate to Security-->Oracle-->DataGroup
search for "standard" data group.
add new entry and search for the application name ->XXCUS Custom Application
Oracle ID->APPS
7) ADD the custom top entry in enviromnet file of applmgr
XXCUS_TOP="/u01/oracle/VIS/apps/apps_st/appl/XXCUS/12.0.0"
export XXCUS_TOP
8) Login as APPLMGR os user and run following
chmod 755 $ORACLE_HOME/bin/sqlplus
chmod 755 $ORACLE_HOME/sqlplus
chmod 755 $ORACLE_HOME/sqlplus/mesg
chmod 755 $ORACLE_HOME/sqlplus/mesg/sp1us.msb
chmod 755 $ORACLE_HOME/nls
chmod 755 $ORACLE_HOME/nls/data
chmod 755 $ORACLE_HOME/nls/data/lx1boot.nlb
chmod 755 $ORACLE_HOME/oracore
chmod 755 $ORACLE_HOME/oracore/zoneinfo
chmod 755 $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat
chmod -R 777 $ORACLE_HOME/forms/admin/terminal
9) Login as appldev user and edit bash_profile with the environment details of applmgr
