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?