Applying A Patch Is Hanging With Error ORA-12514 in the worker log

Noname123

    I am applying a workflow patch in Oracle EBS  R12.2.5 environment.   The patch is hanging.  Worker 1 is running with no progress for more than 12 hours while the other workers are in wait state.  I checked worker 1 log and I found  ORA-12514.  See the error below from worker 1 log:

     

    Reading language information from applUS.txt ...

      Temporarily resetting CLASSPATH to:

      "/u01/EBS_HOME/fs2/EBSapps/appl/ad/12.0.0/java/adjava.zip:/u01/EBS_HOME/fs2/EBSapps/comn/util/jdk32/lib/dt.jar:/u01/EBS_HOME/fs2/EBSapps/comn/util/jdk32/lib/tools.jar:/u01/EBS_HOME/fs2/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u01/EBS_HOME/fs2/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/EBS_HOME/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/EBS_HOME/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/EBS_HOME/fs2/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/EBS_HOME/fs2/EBSapps/comn/java/classes:/u01/EBS_HOME/fs2/EBSapps/10.1.2/forms/java:/u01/EBS_HOME/fs2/EBSapps/10.1.2/forms/java/frmall.jar:/u01/EBS_HOME/fs2/EBSapps/10.1.2/jlib/ewt3.jar:/u01/EBS_HOME/fs2/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

     

     

      Calling /u01/EBS_HOME/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...

    Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:

    ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

     

    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:490)

    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)

    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:235)

    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)

    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)

    at java.sql.DriverManager.getConnection(DriverManager.java:571)

    at java.sql.DriverManager.getConnection(DriverManager.java:215)

    at oracle.apps.ad.worker.AdJavaWorker.getAppsConnection(AdJavaWorker.java:1050)

    at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:278)

    Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:

    ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

     

    at oracle.net.ns.NSProtocol.connect(NSProtocol.java:432)

    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1230)

    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)

    ... 8 more

     

     

     

     

    The listener is up  since I am applying online.  I tried to connect using sqlplus from application tier and I was able to connect successfully.

     

     

    Can you anyone know what the issue might be?

      • 1. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
        mdtaylor

        Please review the following note:

         

        ORA-12514 When Applying Patch in the Patch Edition Using Adpatch (Doc ID 1472560.1)

        • 2. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
          Noname123

          Hi   Thanks for your reply.   However, I am able to connect via sqlplus after sourcing patch file system.  See below:

           

           

          $ . EBSapps.env

            E-Business Suite Environment Information

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

            RUN File System           : /u01/EBS_HOME/fs1/EBSapps/appl

            PATCH File System         : /u01/EBS_HOME/fs2/EBSapps/appl

            Non-Editioned File System : /u01/EBS_HOME/fs_ne

            DB Host: <hostname>  Service/SID: TEST

            E-Business Suite Environment Setting

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

            - Enter [R/r] for sourcing Run File System Environment file, or

            - Enter [P/p] for sourcing Patch File System Environment file, or

            - Enter anything else to exit

            Please choose the environment file you wish to source [R/P]:p

            Sourcing the PATCH File System ...

          $ sqlplus

          SQL*Plus: Release 10.1.0.5.0 - Production on Thu Apr 30 13:10:28 2020

          Copyright (c) 1982, 2005, Oracle.  All rights reserved.

          Enter user-name: system

          Enter password:

          Connected to:

          Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

          With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

          SQL>

           

           

          Furthermore, the shared note by you is related to adpatch.  I don't know if it makes any difference.  However, I am using online patching cycle via (adop) utilily.

           

          Note that the parameter (service_name) already has the value  (  <ORACLE_SID>,  ebs_patch).  See the output below:

          SQL> show parameter service_name

          NAME                                 TYPE        VALUE

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

          service_names                        string      TEST, ebs_patch

          • 3. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
            mdtaylor

            It depends on your AD/TXK level.  If you are AD/TXK C Delta 10 or higher, the patch service name needs the sid before it.

             

            Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

            With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

             

            SQL> show parameter service_name

             

            NAME      TYPE VALUE

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

            service_names      string prd122, prd122_ebs_patch

            SQL>

            • 4. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
              Noname123

              Mine is  AD/TXK C Delta  7.  How different it is here? See below

               

              $ sqlplus

               

              SQL*Plus: Release 10.1.0.5.0 - Production on Mon May 4 15:25:00 2020

              Copyright (c) 1982, 2005, Oracle.  All rights reserved.

               

               

              Enter user-name: apps

              Enter password:

               

              Connected to:

              Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

              With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

               

               

              SQL> show parameter service

              NAME                                 TYPE        VALUE

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

              service_names                        string      TEST, ebs_patch

               

               

              • 5. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
                mdtaylor

                What is your local_listener database paraneter?  I recently had a similar issue because local_listener was not TEST_LOCAL.

                 

                adop phase=prepare fails with: Error Message : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (Doc ID 2007225.1)

                 

                What do you get from sqlplus apps@TEST_patch?  It should connect successfully from run and patch FS if adop session is open.

                • 6. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
                  Noname123

                  SQL> show parameter listener

                   

                   

                  NAME                                 TYPE        VALUE

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

                  listener_networks                    string

                  local_listener                       string      TEST_LOCAL

                  remote_listener                      string

                   

                   

                   

                  I was able to run adop phase=prepare successfully.  The error in the worker log occurred at the time of running adop phase=apply

                  • 7. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
                    mdtaylor

                    What do you get from sqlplus apps@TEST_patch?  It should connect successfully from run and patch FS if adop session is open.

                    • 8. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
                      Noname123

                      From Run file system:

                       

                      $ . EBSapps.env

                       

                       

                        E-Business Suite Environment Information

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

                        RUN File System           : /u01/EBS_HOME/fs1/EBSapps/appl

                        PATCH File System         : /u01/EBS_HOME/fs2/EBSapps/appl

                        Non-Editioned File System : /u01/EBS_HOME/fs_ne

                       

                       

                       

                       

                        DB Host: <host_name>  Service/SID: TEST

                       

                       

                       

                       

                        E-Business Suite Environment Setting

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

                        - Enter [R/r] for sourcing Run File System Environment file, or

                        - Enter [P/p] for sourcing Patch File System Environment file, or

                        - Enter anything else to exit

                       

                       

                        Please choose the environment file you wish to source [R/P]:r

                       

                       

                        Sourcing the RUN File System ...

                       

                       

                      $ sqlplus apps@TEST_PATCH

                       

                       

                      SQL*Plus: Release 10.1.0.5.0 - Production on Tue May 5 16:09:49 2020

                       

                       

                      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

                       

                       

                      Enter password:

                       

                       

                      Connected to:

                      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

                      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

                       

                       

                      SQL>

                       

                       

                       

                       

                      ===============================================================

                      From patch file system

                       


                      $ . EBSapps.env

                       

                       

                        E-Business Suite Environment Information

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

                        RUN File System           : /u01/EBS_HOME/fs1/EBSapps/appl

                        PATCH File System         : /u01/EBS_HOME/fs2/EBSapps/appl

                        Non-Editioned File System : /u01/EBS_HOME/fs_ne

                       

                       

                       

                       

                        DB Host: <hostname>  Service/SID: TEST

                       

                       

                       

                       

                        E-Business Suite Environment Setting

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

                        - Enter [R/r] for sourcing Run File System Environment file, or

                        - Enter [P/p] for sourcing Patch File System Environment file, or

                        - Enter anything else to exit

                       

                       

                        Please choose the environment file you wish to source [R/P]:p

                       

                       

                        Sourcing the PATCH File System ...

                       

                       

                      $ sqlplus apps@TEST_PATCH

                       

                       

                      SQL*Plus: Release 10.1.0.5.0 - Production on Tue May 5 16:12:02 2020

                       

                       

                      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

                       

                       

                      Enter password:

                       

                       

                      Connected to:

                      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

                      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

                       

                       

                      SQL>

                      • 9. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
                        mdtaylor

                        Can you please attach the entire worker1 log, and the adpatch log.  Which patch are you trying to apply?

                        • 10. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
                          Noname123

                          I couldn't find attachment upload button in this page.   Therefore, I have uploaded it to onedrive and shared the link below:

                          https://1drv.ms/u/s!AlMyQ-25HX-Gjx2e5MOdyRo1eNme?e=VrTt2p

                           

                           

                          The patch I am trying to apply is OW related patch (29158460)

                          • 12. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
                            mdtaylor

                            It appears due to your TXK level, it is looking for TEST_ebs_patch in your service_name.  Like in my entry for prd122_ebs_patch, update your service_name init.ora parameter to show TEST_ebs_patch, restart the database and try again.

                             

                            Time when worker completed job: Fri Apr 17 2020 09:10:56

                             

                            JDBC connect string from AD_APPS_JDBC_URL is

                            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ritpedbl1.bahri.sa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST_ebs_patch)(INSTANCE_NAME=TEST)))

                             

                            Time when worker started job: Fri Apr 17 2020 09:10:56

                             

                            Also type tnsping '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ritpedbl1.bahri.sa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST_ebs_patch)(INSTANCE_NAME=TEST)))'

                             

                            It should respond OK.

                            • 13. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log
                              Noname123

                              Hi.  Thanks for the reply.  I will try the offered solution then I am going to update this thread.