Anuroop Challa

Critical Patch Updates, Security Alerts and Bulletins:- ============================================================  Below one is link you can latest patches to find  https://www.oracle.com/technetwork/topics/security/alerts-086861.html you can select patch updates month and next page component like(database). and follows steps to download type of patch and version you need.  please note you need oracle account to download these.  if you need any specific number or type of patch you can directly login support account in tabs clock Patches&Update enter patch number and download.  https://support.oracle.com  

oracle 12 patch installation(./datapatch -verbose) did or not check ===================================================== In my environment one of our colleague miss to run ./datapatch -verbose after patch apply, then frequently it produce patch info in alert-log. in this case lsinventory show opatch successfully applied, but she did miss to run post install, in this case we should fallow like below, for this need down time as well plz do with careful and per organization down time procedure. how to check post-install completed or not ------------------------------------------------------------- SQL> set serverout on SQL> exec dbms_qopatch.get_sqlpatch_status; if no output means you miss to run --------------then fallow below procedure to fullfill your patch procedure and make it complete--------- step1: shutdown step2: startup upgrade step3: cd $ORACLE_HOME/OPatch step4: /datapatch -verbose setp5: shutdown step6: startup Thanks for your visit! your comme...

---------to check inventory ok or not------------- select dbms_sqlpatch.verify_queryable_inventory from dual; -------------------------------------------------------------------------------------------------------------------------- ORACLE12c check script -------------------------------------------------------------------------------------------------------------------------- set pages 300; set lines 300; col VERSION format a10; col STATUS format a10; col ACTION_TIME format a20; col DESCRIPTION format a80; select PATCH_ID,PATCH_UID, VERSION,STATUS, ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch; -------------------------------------------------------------------------------------------------------------------------- ORACLE11G check script -------------------------------------------------------------------------------------------------------------------------- set lines 300 set pages 300 col ACTION format a15 col NAMESPACE format a15 col version format a1...