Oracleapps Vmapps11i
Oracleapps Vmapps11i
Oracleapps Vmapps11i
purpose DB installation alert log Apps installation alert log Environment files Db environment file Apps environment file
Startup scripts All Servers Apache web server Apps Listener Concurrent manager server Forms server Reports server DB server DB Listener Shutdown scripts All Servers Apache web server Apps Listener Concurrent manager server Forms server Reports server DB server DB Listener Check Server processes Apache web server Forms server Reports server Concurrent manager server Apps Listener Discoverer server DB server DB Listener EBS home page
adadmin
See missing files info See invalid objects in apps schema See validation info about apps schema adctrl
Page 1
Sheet1
patchsets.sh adpatch test mode preinstall non interactive mode hotpatch nocomiplejsp, nocompiledb dbpatches
adrelink
adodfcmp
adident
adsplicer license manager adutconf Discoverer 4i gatekeeper service os agent oad locator Register discoverer Health check Viewer URL Plus URL
Auto-Config apdev
Page 2
Sheet1
ordev
Reports server
clear cache
AD_DEFERRED_JOBS FND_INSTALL_PROCESSES
AOL/J test
Page 3
Sheet1
location / command RDBMS_HOME/appsutil/log/<context_name>/ APPL_TOP/admin/<CONTEXT_NAME>/log
$RDBMS_HOME $APPL_TOP
$COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $RDBMS_HOME/appsutil/scripts/<CONTEXT_NAME> $RDBMS_HOME/appsutil/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $COMMON_TOP/admin/scripts/<CONTEXT_NAME> $RDBMS_HOME/appsutil/scripts/<CONTEXT_NAME> $RDBMS_HOME/appsutil/scripts/<CONTEXT_NAME>
ps -ef | grep <applmgr> | grep httpd ps -ef | grep <applmgr> | grep f60 ps -ef | grep <applmgr> | grep REP ps -ef | grep <applmgr> | grep FNDLIBR ps -ef | grep <applmgr> | grep tns ps -ef | grep <applmgr> | grep disc ps -ef | grep <ordev> ps -ef | grep <ordev> | grep tns http://<hostname>.domainname:8000 Ex:- http://apps11i.oracle.com:8000 $APPL_TOP/ad/11.5.0/bin
$APPL_TOP/ad/11.5.0/bin
Page 4
Sheet1
Download from metalink $AD_TOP/bin select bug_number from ad_bugs where bug_number='&bugno';
$RDBMS_HOME/OPatch
$RDBMS_HOME/.patch_storage/<patch_no>
$PER_TOP/patch/115/driver $AD_TOP/bin
$AD_TOP/bin
$AD_TOP/bin
$AD_TOP/bin
http://<hostname>.domainname:8000/discoverer4i/viewer http://<hostname>.domainname:8000/discwb4/html/english/welcome.htm
$APPL_TOP/admin/
Page 5
Sheet1
$AD_TOP/bin $APPL_TOP/admin/<CONTEXT_NAME>/out/<directory with latest number> $RDBMS_HOME/appsutil $RDBMS_HOME/appsutil/scripts/<CONTEXT_NAME>/ $RDBMS_HOME/appsutil/bin/ $<PRODUCT_TOP>/admin/template $AD_TOP/bin
$AD_TOP/bin $RDBMS_HOME/appsutil/bin/
$AD_TOP/bin
8.0.6_HOME/reports60/server $ORACLE_HOME/reports60/server/
$COMMON_TOP/admin/log
$FND_TOP/secure http://apps11i.oracle.com:8000/OA_HTML/jsp/fnd/aoljtest.jsp
Page 6
Sheet1
filename dbinstallcfg.log installApps.log
adstrtal.sh start apps/apps adapcctl.sh start adalnctl.sh start adcmctl.sh start apps/apps adfrmctl.sh start adrepctl.sh start addbctl.sh start addlnctl.sh start <SID> adstpall.sh stop apps/apps adapcctl.sh stop adalnctl.sh stop adcmctl.sh stop apps/apps adfrmctl.sh stop adrepctl.sh stop addbctl.sh stop addlnctl.sh stop <ORACLE_SID>
APPS.lst adctrl
Page 7
Sheet1
patchsets.sh adpatch driver=<driver_name> adpatch apply=no driver=<driver_name> adpatch preinstall=y driver=<driver_name> adpatch defaultsfile =<file_location> adpatch defaultsfile =<file_location> interactive=no driver=<driver_name> adpatch driver=<driver_name> options=hotpatch adpatch driver=<driver_name> options=nocompilejsp,nocompiledb opatch lsinventory opatch apply <patch_name> opatch apply -no_inventory rollback_<patch_no>.sh
java oracle.apps.per.DataInstall <username> <password> <protocol> <hostname:portno:SID> ex: java oracle.apps.per.DataInstall apps apps thin apps11i:1521:DEV adpatch driver=hrglobal.drv admrgpch.sh -s <source_dir> -d <dest_dir> -merge_name <merged_patch_name> ex: admrgpch.sh -s /patches/prereq/ -d /mergedpatches -merge_name merged_patch adrelink.sh adrelink.sh force=y fnd FNDLIBR adodfcmp odf <odf_file_name> ex: adodfcmp odf afcpmgr.odf adident header <file_name> strings -a <file_name> | grep header adsplice.sh adlicmgr.sh adutconf.sql startall.sh startgatekeeper.sh startosagent.sh startoad.sh startlocator.sh registerall.sh checkdiscoverer.sh
<context_name.xml>
Page 8
Sheet1
adconfig.sh adautocfg.sh <context_name.xml> adautocfg.sh adconfig.sh
adchkcfg.sh
admkappsutil.pl
REP60_<sid>.ora CGIcmd.dat
appweb_<context_name>.cfg
sid_<month>.mgr
hostname_<sid>.dbc
Page 9
Sheet1
logs
$APPL_TOP/admin/<SID>/log
Page 10
Sheet1
$APPL_TOP/admin/<SID>/log
$RDBMS_HOME/.patch_storage/<log_file.log>
<current_directory>/admrgpch.log
<current_directory>/adsplice.log
<current_directory>/adutconf.lst
Page 11
Sheet1
$APPL_TOP/admin/<context_name>/log/<time_stamp_dir>/adconfig.log
$ORACLE_HOME/appsutil/log/<context_name>/<time_stamp_dir>/adconfig.log
$APPL_TOP/admin/<context_name>/out/<time_stamp_dir>/adxcfgcheck.zip
REP60_<sid>.log
$ORACLE_HOME//reports60/server/rep60_<sid>.log
$COMMON_TOP/admin/log/<contextname>/
Page 12
Sheet1
comments
do not edit or add customs do not edit or add customs identical to <CONTEXT_NAME>.env add customs to this file identical to <CUSTOMCONTEXT_NAME>.env
apps username & password required for only concurrent manager server.
apps username & password required for only concurrent manager server.
temp tables - contains info about adadmin workers contains missing files info only
Page 13
Sheet1
to see complete patches and their latest versions available on metalink writes log after execution to check existing patches to run adpatch in TEST mode to run adpatch in PREINSTALL mode to create defaultsfile for non-interactive mode to run adpatch in NON-INTERACTIVE mode to bypass maintenance mode to bypass compilation shows info about applied patches to apply a patch if inventory is missing or corrupt to rollback a patch
run after applying HRMS patch run after DataInstall utility don't merge techstack and dbpatches destination directory must be empty to relink adadmin executables to recreate fnd executables to recreate object definitions ex: table structure etc will recreate afcpmgr object definitions to find the file version executable file version cannot be known edit newprods.txt to change main_tspace & index_tspace GUI tool shows licensed product info it doesn't start gatekeeper service add the cmd to startall.sh to invoke gatekeeper service along with startall.sh
need to register for first time read only reports (SSI) can edit reports (PJI )
Page 14
Sheet1
edit template copies in template/custom directory unzip and see report. Same as running autoconfig in test mode
creates appsutil.zip at $APPL_TOP/admin/out. $unzip -o appsutil.zip find adbldxml.pl at $APPL_TOP/admin/out/appsutil(unzipped)/bin copy adbldxml.pl to $RDBMS_HOME/appsutil/bin
delete all files from here and restart Apache server delete all files to clear pl/sql cache
config info is stored in FND_<Tables> in DB L<id>.req & L<id>.log end user concurrent programs concurrent manager server info logfile
Page 15