copy the file to OA_HTML

$AD_TOP/patch/115/sql

Sql>@adphrept.sql 3 ALL ALL 12/01/00 12/31/00 ALL ALL ALL ALL ALL N N N N N

adphrept 1 ALL ALL ALL ALL ALL ALL ALL ALL ALL N N N N N

 If it errors follow notes

ORA-29532 after database upgrade in APPS environment [ID 833237.1]

Create public synonym DBMS_XMLQUERY for sys.DBMS_XMLQUERY;
Create public synonym DBMS_XMLSAVE for sys.DBMS_XMLSAVE;
Create public synonym DBMS_XMLGEN for sys.DBMS_XMLGEN;
Create public synonym XMLGEN for sys.DBMS_XMLGEN;

/dbutil/applmgr/scripts/Patch_parse.sh

#!/usr/bin/sh

for f in *README.txt

do

  PATCH=`grep 'Update' $f|cut -d'-' -f2`

  PRODUCT=`grep 'Product' $f|cut -d'-' -f2`

  DESC=`head -3 $f | tail -1 `

read PATCH <<< "$PATCH";

read PRODUCT <<< "$PRODUCT";

OUTPUT="${PATCH}|${PRODUCT}|${DESC}"

echo $OUTPUT>>report.txt

done

 SQL> SELECT DISTINCT RPAD(a.bug_number,
11)|| RPAD(e.patch_name,
11)|| RPAD(TRUNC(c.end_date),
12)|| RPAD(b.applied_flag, 4)  BUG_APPLIED
FROM
ad_bugs a,
ad_patch_run_bugs b,
ad_patch_runs c,
ad_patch_drivers d ,
ad_applied_patches e
WHERE
a.bug_id = b.bug_id AND
b.patch_run_id = c.patch_run_id AND
c.patch_driver_id = d.patch_driver_id AND
d.applied_patch_id = e.applied_patch_id AND
a.bug_number in  ('<XXXXXX>','<YYYYYY>')
ORDER BY 1 DESC;

admrgpch -s source -d dest -manifest manifest.list

Applying a Patch Non-Interactively:


Create a default file. 





Run AutoPatch to the point where it prompts for the directory where the Oracle
Applications patch has been unloaded. Enter abort at this prompt.




adpatch defaultsfile=$APPL_TOP/admin/testdb1/adpatchdef.txt



Run autopatch using your defaults file:

$ adpatch defaultsfile=$APPL_TOP/admin/testdb1/def.txt \
logfile=1234567.log
patchtop=$APPL_TOP/patches/1234567 driver=u1234567.drv \
workers=3 interactive=no

In the patch top area, create a source directory and a destination directory. Choose
any name for these directories.

Download patches.
Download all the patches you want to merge to the source directory.

3. Download patches.
Download all the patches you want to merge to the source directory.

5. Run AD Merge Patch.

$ admrgpch -s <source directory> -d <destination directory>
You can specify the merged patch name with -merge_name <name>, or accept the
default.

You can merge patches before you unzip them by running AD Merge Patch with
the -manifest command line argument

$ admrgpch -s <source directory> -d <destination directory> \
-merge_name <name> [-manifest <manifest filename>]

$ cd /d01/patch_merge
$ admrgpch -s /d01/patch_merge/source \
-d /d01/patch_merge/destination \
-merge_name merge99

Check AD Merge Patch log files.
After AD Merge Patch runs, check the admrgpch.log file for errors. The file is
located in the current working directory (where AD Merge Patch was run)

To defer the upload of patch information

1. Perform preparatory patch steps. See: Applying a Patch Interactively, page 5-7.
2. Apply the patch by running AutoPatch with the defer patch history information upload option.
$ adpatch options=phtofile
3. After the patch session is complete, disable Maintenance mode, restart all services
and allow users to access the system.
4. Run AutoPatch with the upload patch history information argument.
$ adpatch uploadph=y
AutoPatch uploads the patch history information to the database and exits.

# cd $INST_TOP/ora/10.1.3
# . ./_.env

/u02/oracle/DEVL/inst/apps/DEVL_earth/ora/10.1.2/DEVL_earth.env

Just source your environment file. I got this error after logging in, typing screen then trying to run adadmin. I had to su back to the user which sourced my env...and ..no more error

I still received this error only not as blatantly, ..it happened trying to generate report files. google: .Xauthority forwarding...I'll update with the notes soon. The above only partly resoved it.

PATH=$PATH:$ORACLE_HOME/OPatch

opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc

opatch napply -invPtrLoc $ORACLE_HOME/oraInst.loc

$ORACLE_HOME/OPatch/opatch version -invPtrLoc $ORACLE_HOME/oraInst.loc

$ORACLE_HOME/OPatch/opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc

$ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc

$ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc

./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc

opatch prereq CheckConflictAgainstOHWithDetail -invPtrLoc $ORACLE_HOME/oraInst.loc -phBaseDir ./9352179

Summary of Conflict Analysis:

There are no patches that can be applied now.

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
9571658, 8338798

Following patches will be rolled back from Oracle Home on application of the patches in the given list :
8338798

Conflicts/Supersets for each patch are:

Patch : 9571658

Bug Conflict with 8338798
Conflicting bugs are:
7327166, 6815733, 8303523

OPatch succeeded.
[oradev@earth

DEVL_WEBOH__u02_oracle_DEVL_apps_tech_st_10_1_3

OPatch Version: 1.0.0.0.58

b. Source the 10.1.3 ORACLE_HOME or the 10.1.2 ORACLE_HOME

# cd $INST_TOP/ora/10.1.3
# . ./_.env

/u02/oracle/DEVL/inst/apps/DEVL_earth/ora/10.1.2/DEVL_earth.env
/u02/oracle/DEVL/inst/apps/DEVL_earth/ora/10.1.2/DEVL_earth.env

/u02/oracle/DEVL/inst/apps/DEVL_earth/ora/10.1.3/DEVL_earth.env
u02/oracle/DEVL/inst/apps/DEVL_earth/ora/10.1.2/DEVL_earth.env

cd $INST_TOP/ora/10.1.2
# . ./_.env

/u02/oracle/DEVL/apps/tech_st/10.1.3/opmn/bin/opmnctl status -l

chmod +x $ORACLE_HOME/bin/genshlib

This 15 min. crontab entry is a light-weight heartbeat mechanism for OCM. It only checks if OCM is up. If the machine is brought down or if for any reason OCM scheduler goes down, this would bring it up. But it will not bring OCM up, if it was explicitly stopped using "emCCR stop" command.

To stop this program:
ORACLE_HOME/ccr/bin/emCCR stop

To start this program:
$ORACLE_HOME/ccr/bin/emCCR start

To check for its status:
$ ps -ef | grep -i nmz

The log file for this session is located at: /u02/oracle/DEVL/inst/apps/DEVL_earth/admin/log/05281232/adconfig.log

ps -ef|grep appldev | awk '{ print $2 }' |xargs kill -9

The log file for this session is located at: /u02/oracle/DEVL/inst/apps/DEVL_earth/admin/log/05281250/adconfig.log

alias patch='cd /data/patches/R12.1.2'

download J2SE

extract JDK

./jdk-6u20-linux-x64-rpm.bin

install the jdk

rpm -ivh jdk-6u20-linux-i586.rpm (you have to do this as root)

cd [IAS_ORACLE_HOME]/appsutil/
mv jdk jdk_old
mkdir jdk
cd /usr/java?
cp -R * [IAS_ORACLE_HOME]/appsutil/jdk
cd [IAS_ORACLE_HOME]/appsutil/jdk
chown -R owner:group ./*

I did the above as the owner of the apps (appldev in this case.)

or you can copy the files to $IAS_ORACLE_HOME/appsutil

then

mv jdk1.6.0_20 jdk

The files should be directly under jdk, not jdk/jdk1.6.0_20/...