3 Replies Latest reply: Sep 1, 2013 12:56 PM by Asif Muhammad RSS

    Adpatch default log file names-Raghuram Kotnana

    RaghuramKotnana

      Does using of adpatch default log file names during patching makes it difficult to keep an accurate record of your patch history ?

        • 1. Re: Adpatch default log file names-Raghuram Kotnana
          Srini Chavali-Oracle

          The default log file name is adpatch.log. A more meaningful name (to include the patch number, SID, language etc) is recommended. Patch history is stored in AD_PATCH% tables, and information can be derived from those tables, although errors/warnings are recorded only in the patch log files

           

          HTH
          Srini

          • 2. Re: Adpatch default log file names-Raghuram Kotnana
            Hussein Sawwan-Oracle

            RaghuramKotnana wrote:

             

            Does using of adpatch default log file names during patching makes it difficult to keep an accurate record of your patch history ?

             

            It does make it difficult when you apply many patches and all are logged in the same patch log file. If you encounter issues applying patches while using the default adpatch.log name, it would be also harder to find the proper entries to grep and share with Oracle support.

             

            I would suggest you use the same patch driver name for the log file and replace .drv with .log (i.e. u<patch number>.log).

             

            Details about applied patches from your instance can be found in the tables in (Important tables used by and updated by ADPATCH utility (Doc ID 1520703.1)).

             

            You can also refer to eTRM website for details about each table -- http://etrm.oracle.com/

             

            Thanks,

            Hussein

            • 3. Re: Adpatch default log file names-Raghuram Kotnana
              Asif Muhammad

              Hi Raghuram,

               

               

              Does using of adpatch default log file names during patching makes it difficult to keep an accurate record of your patch history ?

              In addition to above valuable comments, Please note the adpatch.log (default log file) or any user-defined log files that you have during patching session is more valuable to you for troubleshooting purposes if your adpatch session fails.

               

              But if you are more concerned on the maintenance of "accurate of your patch history" or as I understand, Keeping track of the patch history then the answer is; Oracle stores the list of patches that you have applied in the DB and you no need to worry of the what the log file name that you have provided.

               

              In order to find out whether the patch is applied or not, You may use query:

              Select bug_number from ad_bugs

              where bug_number='&Patch_Number'

               

              Thanks &

              Best Regards