12 Replies Latest reply on May 14, 2020 9:45 PM by mdtaylor

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

Noname123 Apr 29, 2020 11:16 AM

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 Apr 29, 2020 12:02 PM (in response to Noname123)

Please review the following note:

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

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

Noname123 Apr 30, 2020 10:18 AM (in response to mdtaylor)

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
Like Show 0 Likes(0)

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

mdtaylor Apr 30, 2020 10:32 AM (in response to Noname123)

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>
Like Show 0 Likes(0)

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

Noname123 May 4, 2020 12:28 PM (in response to mdtaylor)

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
Like Show 0 Likes(0)

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

mdtaylor May 4, 2020 12:49 PM (in response to Noname123)

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.
Like Show 0 Likes(0)

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

Noname123 May 4, 2020 12:47 PM (in response to mdtaylor)

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
Like Show 0 Likes(0)

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

mdtaylor May 4, 2020 12:50 PM (in response to Noname123)

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

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

Noname123 May 5, 2020 1:13 PM (in response to mdtaylor)

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>
Like Show 0 Likes(0)

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

mdtaylor May 5, 2020 1:27 PM (in response to Noname123)

Can you please attach the entire worker1 log, and the adpatch log. Which patch are you trying to apply?
Like Show 0 Likes(0)

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

Noname123 May 10, 2020 12:42 PM (in response to mdtaylor)

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)
Like Show 0 Likes(0)

Actions
11. Re: Applying A Patch Is Hanging With Error ORA-12514 in the worker log

Noname123 May 13, 2020 12:30 PM (in response to Noname123)

Any update?
Like Show 0 Likes(0)

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

mdtaylor May 14, 2020 9:45 PM (in response to Noname123)

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.
Like Show 0 Likes(0)

Actions

Go to original post