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: