The environment variable CONTEXT_FILE will contain the correct path to the context file respectively for the apps and db tiers (when logged in as the db ower and apps owner respectively).
APPS
The command adconfig.sh should also exist on the respective user’s path. Run the adconfig.sh command. It will ask for the context file path and the password for the db APPS user.
DB
adconfig.sh is located at $ORACLE_HOME/appsutil/bin/adconfig.sh
It will also need the context file path and the APPS password
BACKOUT APPS CHANGES
restore script is located at $INST_TOP/admin/out/restore.sh
unzip the patch then run:
adpatch defaultsfile=$APPL_TOP/admin/<INST_NAME>/adalldefaults.txt patchtop=<path_to_top_patch_dir>
SELECT a, b, c
FROM
( SELECT a, b, c, ROWNUM rn
FROM
( SELECT a, b, c FROM RECORD
WHERE AVAIL='Y"
ORDER BY DATE DESC
)
WHERE ROWNUM <= 25
)
WHERE rn >= 21;
This clunky code is the equivalent of mysql's elegant:
select a,b,c from record limit 5 offset 4;
install rlwrap (available from http://utopia.knoware.nl/~hlub/rlwrap/)
then add this to the bash_profile:
alias sqlplus=’rlwrap sqlplus’
run export KSH_VERSION=’@(#)PD KSH v5.2.14 99/07/13.2′
before running adcfgclone.pl on both dbTier and appsTier
metalink docid 406982.1
iptables -A OUTPUT -p tcp -s 0/0 -d 141.146.57.56 –dport 25 -j REJECT –reject-with tcp-reset
