Work in progress excuse my dust…

Executable locations:

Apps Tier: $AD_TOP/bin

DB Tier: $ORACLE_HOME/appsutil/bin

AD Administration / adadmin and AutoPatch / adpatch place their log files in the following locations:

UNIX:

$APPL_TOP/admin/<SID>/log

Windows:

%APPL_TOP%\admin\<SID>\log

How to use – basics:

adpatch:

adpatch driver types

U, C, G, D

U – Universal drivers are the newer versions and easiest to work with usually, you just run them from the apps tier.

C – Copy patch driver – readme specifies where to run

G – Generate patch driver – readme specifies where to run

D – Database – run on the database tier

running adpatch

unzip your patch into a stageed dir e.g p11199943.zip will unzip into ./11199943 so cd into it and then run adpatch from it as follows.

$AP_TOP/bin/adpatch

You’ll be prompted for the apps username/pw and the oracle system password.

Along with several other prompts – most of which you can accept the proposed default values or over ride if you choose.

running non-interactively with defaultsfile

creating defaultsfile

using defaultfile

Query Patch History:

$ sqlplus apps/apps

SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 15 13:04:23 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Wed Apr 12 2017 07:15:35 -04:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> desc ad_applied_patches
Name Null? Type
—————————————– ——– —————————-
APPLIED_PATCH_ID NOT NULL NUMBER
RAPID_INSTALLED_FLAG VARCHAR2(1)
PATCH_NAME NOT NULL VARCHAR2(120)
PATCH_TYPE NOT NULL VARCHAR2(30)
MAINT_PACK_LEVEL VARCHAR2(30)
SOURCE_CODE NOT NULL VARCHAR2(3)
CREATION_DATE NOT NULL DATE
CREATED_BY NOT NULL NUMBER
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER
IMPORTED_FLAG VARCHAR2(1)
IMPORTED_FROM_DB VARCHAR2(30)
IMPORTED_ID NUMBER
MERGE_DATE DATE
DATA_MODEL_DONE_FLAG VARCHAR2(1)

set linesize 200;
column APPLIED_PATCH_ID format a24;
column PATCH_NAME format a24;
column PATCH_TYPE format a8;
column MAINT_PACK_LEVEL format a24;

select
APPLIED_PATCH_ID,
PATCH_NAME,
PATCH_TYPE,
MAINT_PACK_LEVEL,
LAST_UPDATE_DATE,
LAST_UPDATED_BY
from ad_applied_patches
order by last_update_date asc;

adadmin:

Leave a Reply

Your email address will not be published. Required fields are marked *