3 Replies Latest reply on Sep 24, 2018 10:30 AM by Beauty_and_dBest

    Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for Oracle E-Business Suite schema

    Beauty_and_dBest

      Upgrade 12.0.6 to 12.2.7

       

      Oracle® E-Business Suite

      Upgrade Guide

      Release 12.0 and 12.1 to 12.2

      Part No. E73540-04

      July 2018

       

      Hi ALL,

       

      In page >> 4-44 Oracle E-Business Suite Upgrade Guide above, it says below

       

       

      How do I query the profile for EBS schema?

       

       

      Kind regards,

      jc

        • 1. Re: Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for Oracle E-Business Suite schema
          Shaik

          Hi JC

           

          SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES

          WHERE PROFILE='DEFAULT';

          • 2. Re: Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for Oracle E-Business Suite schema
            Beauty_and_dBest

            Thanks Shaik

             

            How do I know if default profile is assigned to EBS schemas?

             

            RESOURCE_NAME||','||LIMIT

            --------------------------------------------------------------------------------

            COMPOSITE_LIMIT, UNLIMITED

            SESSIONS_PER_USER, UNLIMITED

            CPU_PER_SESSION, UNLIMITED

            CPU_PER_CALL, UNLIMITED

            LOGICAL_READS_PER_SESSION, UNLIMITED

            LOGICAL_READS_PER_CALL, UNLIMITED

            IDLE_TIME, UNLIMITED

            CONNECT_TIME, UNLIMITED

            PRIVATE_SGA, UNLIMITED

            FAILED_LOGIN_ATTEMPTS, UNLIMITED

            PASSWORD_LIFE_TIME, UNLIMITED

            PASSWORD_REUSE_TIME, UNLIMITED

            PASSWORD_REUSE_MAX, UNLIMITED

            PASSWORD_VERIFY_FUNCTION, NULL

            PASSWORD_LOCK_TIME, UNLIMITED

            PASSWORD_GRACE_TIME, UNLIMITED

             

            16 rows selected.

             

            SQL> l

              1* SELECT RESOURCE_NAME||', '||LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT'

             

             

            Kind regards,

            • 3. Re: Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for Oracle E-Business Suite schema
              Beauty_and_dBest

              Hi Shaik and ALL,

               

              Can you help me please, about this upgrade task >> Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)

               

              I followed this docs  but seems not updated of some task is missing? Can you share me the completed one?

              Kind regards,

               

               


                • Make directory
              2.  Patch 10117518. (Merge Patch: 10117518, 19796564, 21670164, 21833257 )
              3.   

              $mkdir -p <PATCH_TOP>/AD_SOURCE

              $mkdir -p <PATCH_TOP>/10117518_CUP6

              • Copy all the above merge patches and put it to “AD_SOURCE” directory and unzip all the patches.

              $unzip <patches>

              • Run the admrgpch utility will help to generate a single patch location under “10117518_CUP6”

              admrgpch -s /prodapps/Application_Patches/AD_source -d /prodapps/Application_Patches/10117518_CUP6 -merge_name 10117518_cup6 –admode

               

              • Run adgrants.sql from merged patch location

              Copy the “adgrants.sql” from merged patch directory and then transfer sql file to database node.

                                                                                                                                                                                   

               

              1. Merged Main 10117518_CUP6

               

               

               

              6. Apply consolidated upgrade patches

               

              • Apply the below patches with option pre-install=y

               

              1. Sl.No

              Patches

              1

              19796566

              2

              21632403

               

                       

               

               

                 

              1. Patch 21632403

               

              7. Apply American Upgrade Patch Driver

                          Note: Ensure tablespace APPS_TS_TX_DATA has enough space

               

                          To bring database to the full Oracle E-Business Suite Release 12.2 level, use Auto Patch to run the  (American English) unified driver (u10124646.drv). It is located in $AU_TOP/patch/115/driver