4 Replies Latest reply on Nov 21, 2016 6:23 AM by Ramaraju

    EBS R12.2.0 to R12.2.4 Upgrade

    Ramaraju

      Hi All,

      We are upgrading EBS R12.2.0 to R12.2.4.

      We have applied all required pre-requisite patches like DB, Forms & Report, WLS etc..

      While applying the application patch using ADOP, the following error occurred. Please help me on this issue.

       

      [ERROR]     *** Error occurred while calling ad_zd_log. Please check log file for the details. ***

      [START 2016/11/16 08:37:10]Arguments passed to adop

          phase=apply patches=18288881 restart=no abandon=yes

      [END   2016/11/16 08:37:10]Arguments passed to adop

      [START 2016/11/16 08:37:10] Performing verification of parameters

      [END   2016/11/16 08:37:30] Performing verification of parameters

      [ERROR]     Cannot connect to database

      [ERROR]     Error Message :

      [ERROR]     *** Error occurred while calling ad_zd_log. Please check log file for the details. ***

      [ERROR]     *** Error occurred while calling ad_zd_log. Please check log file for the details. ***

      [ERROR]     *** Error occurred while calling ad_zd_log. Please check log file for the details. ***

      [ERROR]     *** Error occurred while calling ad_zd_log. Please check log file for the details. ***

      [ERROR]     *** Error occurred while calling ad_zd_log. Please check log file for the details. ***

      [UNEXPECTED]Error occurred while trying to determine admin node

       

      As per Oralce Doc ID: 2041291.1, we have soft link

      $ cd $ORACLE_HOME/lib

       

      $ ll libclntsh.so.10.1

      -rwxr-xr-x 1 oracle12 oinstall 13710872 Nov 15 04:47 libclntsh.so.10.1

       

      $ ll libclntsh.so

      lrwxrwxrwx 1 oracle12 oinstall 17 Nov 11 23:28 libclntsh.so -> libclntsh.so.10.1

       

      Please help on this issue.

       

      Thanks,

      Ramaraju

        • 1. Re: EBS R12.2.0 to R12.2.4 Upgrade
          Srk600

          Did you get chance to see why it is throwing "

          [ERROR]     Cannot connect to database

           

          Did you double verify the values for DB parameters

           

          service_names

          local_listener

          sec_case_sensitive_logon

           

          Also Please check the Invalids, Especially related to "AD".

           

          Thx

          • 2. Re: EBS R12.2.0 to R12.2.4 Upgrade
            Ramaraju

            Hi,

            Please find below.

            SQL> select name from v$database;

            NAME

            ---------

            VIS

             

            SQL> show parameter service_names

            NAME     TYPE VALUE

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

            service_names     string VIS, ebs_patch

            SQL> show parameter local_listener

            NAME     TYPE VALUE

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

            local_listener     string VIS_LOCAL

            SQL> show parameter sec_case_sensitive_logon

            NAME     TYPE VALUE

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

            sec_case_sensitive_logon     boolean FALSE

             

            SQL> select count(1) from dba_objects where status like 'INVALID';

              COUNT(1)

            ----------

              0

             

            Thanks,

            Ramaraju

            • 3. Re: EBS R12.2.0 to R12.2.4 Upgrade
              Srk600

              Did you see any other supported messages in Patch ID Logs. Check in the respective patch ID directory.

               

              also please share the outpu for

               

              adopscanlog -latest=yes    

              • 4. Re: EBS R12.2.0 to R12.2.4 Upgrade
                Ramaraju

                Hi,

                Thank you for your support.

                adopscanlog -latest=yes command not found.

                It will work after applying major application release patch(12.24/12.2.5).

                 

                We have started fresh upgradation again.

                 

                Thanks,

                Ramaraju