Oracle Study Guide

http://download.oracle.com/docs/cd/B25284_01/current/html/docset.html

I tried following the instructions for changing the IP in the document http://download.oracle.com/docs/cd/B32110_01/core.1013/b32196/host.htm#CIHHADCE, but it kept erroring out with ‘file not found’ errors. As a quick and easy work-around, I bound the old IP to the loopback and voila!

create the file /etc/sysconfig/network-scripts/ifcfg-lo:1 like so:
DEVICE=”lo:1″
IPADDR=”PUT_YOUR_OLD_IP_HERE”
NETMASK=”255.255.255.255″

http://practicalappsdba.wordpress.com/

http://oracle.anilpassi.com/basic-concepts-list-of-useful-oracle-apps-articles-2.html

another:http://getappstraining.blogspot.com/2006/10/oracle-apps-training-index.html

1. Download patchset 6728000 from http://updates.oracle.com/ARULink/PatchSearch/process_form?bug=6728000#uage=0&process=Submit
2. unzip the patchset zip files. They will create a directory ‘6728000′.
3. Run admsi.pl (patch application assistant). This must be done from console or via remote desktop connection as it requires a GUI interface.

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>

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

http://www.oracle.com/technology/documentation/discoverer.html

http://ilearning.oracle.com/ilearn/en/learner/jsp/player.jsp?rco_id=107194876&classroom_id=108352291