tryed adadmin relink
full shutdown and restart
There's not too many parameters for this function ... Maybe the staging directory is invalid ?
Staging directory is valid
SR recommendation are
1-load latest infobundle
2-Linux#> adadmin -- AD Administration Main Menu
-- Option 4 -- Maintain Applications Database Entities menu
-- Option 2 - Re-create grants and synonyms for APPS schema
-- AD Administration Main Menu
-- Option 2 -- Maintain Applications Files menu
-- Option 4 -- Maintain snapshot information
-- Option 2 -- Update current view snapshot
trying that now
Looks like the patch wizard worked. Were you able to click the New files Introduced or Existing File Changed. It should give you details..
Can you check whether the patch is applied already??
the patch is not applyed , i just run the analyse on it
the analyse is done but cant see the detail like "existing file change" ...
knowing that there is 5 file modified is nice
knowing wich 5 files are modified what i want to see
but end in blank page
You have mentioned
"i have installed latest patch wizard patch 28389569
so now if i run the query to know what patch is missing https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=390454198806118&id=976688.1&_afrWindowMode=0&_adf.ctrl-state=16dah9aeqn_450#L167
they are all flagged APPLIED"
if they all flagged then you can go to Applied patches and check. Were you able to try and see it there?
In our instance when we run patch wizard it gives the same results but we will be able to click the numbers and see what changed.
Also please take a look at this document
(Doc ID 468024.1) latest infobundle is loaded
like you said "In our instance when we run patch wizard it gives the same results but we will be able to click the numbers and see what changed. "
thats exactly my problem, if i click on any number i get a blank page except for the Readme file
1 person found this helpful
nvl(adp.product_abbreviation, ' ') ,
DECODE(adp.IS_HIGH_PRIORITY,'Y','High Priority Patch',NVL(adp.patch_type,'User Request')) Patch_Type ,
DECODE (adh.bug_number, NULL, 'N', 'Y'),
decode (adb.analysis_status,'MISSING','Missing','READY','Unapplied','APPLIED','Applied',adb.analysis_status) patch_status ,
nvl(decode(adp.has_msi_steps,'Y','Yes','N','No',adp.has_msi_steps), ' ') hasMsiSteps ,
ad_pm_patches adp ,
ad_appl_tops adt ,
ad_pa_analysis_run_bugs adb ,
where adb.analysis_status in ('MISSING','READY','APPLIED')
and adb.request_set_id = 20436153 --20436153
and adt.NAME ='GLOBAL'
and typeid ='upgrade'
and vl.patch_id = adp.patch_id
and adb.RECOMMENDED_PATCH_TYPE in ('1','3')
and adb.appl_top_id = adt.APPL_TOP_ID
and adb.bug_number = adp.BUG_NUMBER
and adb.baseline = adp.baseline
and adp.patch_metadata_key = 'DEFAULT'
and (adp.is_high_priority = 'Y' OR adp.is_code_level='N' )
and adh.bug_number(+) = adp.BUG_NUMBER
order by adb.analysis_run_id desc
can you run this query for either you patch request set or analysis_run_id?
I love your query
at least i will be able to answer my people question
until my SR get answered