Upgrading Oracle to 19.2.0.0000

Tools and Libraries
1

We are on version 5.3.10.63-SNAPSHOT, and we’re trying to upgrade the Oracle driver from 12.0.1.0 to 19.2.0.0000. No matter what we try, we always get the following error (the number 66 and 66.0 can vary and change):

lucee.runtime.exp.NativeException: Unresolved constraint in bundle org.lucee.oracle [66]: Unable to resolve 66.0: missing requirement [66.0] osgi.ee; (&(osgi.ee=JavaSE)(version=10)) at org.apache.felix.framework.Felix.resolveBundleRevision(Felix.java:4097) at org.apache.felix.framework.Felix.startBundle(Felix.java:2114) at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:977) at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:964) at lucee.loader.osgi.BundleUtil.start(BundleUtil.java:135) at lucee.loader.osgi.BundleUtil.start(BundleUtil.java:133) at lucee.runtime.osgi.OSGiUtil._start(OSGiUtil.java:1266) at lucee.runtime.osgi.OSGiUtil._startIfNecessary(OSGiUtil.java:1219) at lucee.runtime.osgi.OSGiUtil._loadBundle(OSGiUtil.java:526) at lucee.runtime.osgi.OSGiUtil.loadBundle(OSGiUtil.java:504) at lucee.commons.lang.ClassUtil.loadClassByBundle(ClassUtil.java:153) at lucee.transformer.library.ClassDefinitionImpl.getClazz(ClassDefinitionImpl.java:110) at lucee.runtime.config.XMLConfigAdmin.setClass(XMLConfigAdmin.java:6695) at lucee.runtime.config.XMLConfigAdmin._updateJDBCDriver(XMLConfigAdmin.java:1803) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:5040) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:4701) at lucee.runtime.config.XMLConfigAdmin._updateRHExtension(XMLConfigAdmin.java:4683) at lucee.runtime.tag.Admin.doUpdateRHExtension(Admin.java:4343) at lucee.runtime.tag.Admin._doStartTag(Admin.java:768) at lucee.runtime.tag.Admin.doStartTag(Admin.java:355) at ext_applications_cfm184$cf.call(/admin/ext.applications.cfm:81) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1017) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921) at web_cfm$cf.call(/admin/web.cfm:492) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1017) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921) at server_cfm$cf.call(/admin/server.cfm:2) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1017) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2485) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2470) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2441) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: org.osgi.framework.BundleException: Unresolved constraint in bundle org.lucee.oracle [66]: Unable to resolve 66.0: missing requirement [66.0] osgi.ee; (&(osgi.ee=JavaSE)(version=10)) … 63 more

We are moving our Oracle from 12c to 19c, and whatever articles we found concerning this do not seem to work.

Thanks,
Harry

2

@harry.devine Can you please mention your java version?

For me, updating the oracle Database version 12.1.0.2 to 19.12.0.0000 with java 11, it was successfully updated. But It throws the same error with java 8.

3

Here goes:

[root@server1 ~]#java -version

openjdk version “1.8.0_342”

OpenJDK Runtime Environment (build 1.8.0_342-b07)

OpenJDK 64-Bit Server VM (build 25.342-b07, mixed mode)

[root@server1 ~]#cat /etc/redhat-release

Red Hat Enterprise Linux Server release 7.9 (Maipo)

I believe that the Java version is the highest that Red Hat supports in 7.9 and 8.6. We try to not use outside repositories to ensure that everything is uniform across our systems.

Thanks,

Harry

4

So I found that I can, in fact, install Java 11 on RHEL 7.9, so I did that.

[root@server1 ~]#java -version

openjdk version “11.0.16” 2022-07-19 LTS

OpenJDK Runtime Environment (Red_Hat-11.0.16.0.8-1.el7_9) (build 11.0.16+8-LTS)

OpenJDK 64-Bit Server VM (Red_Hat-11.0.16.0.8-1.el7_9) (build 11.0.16+8-LTS, mixed mode, sharing)

However, when I try to install the Oracle 19.12.0.0000 again, I still get the same error:

Unresolved constraint in bundle org.lucee.oracle [59]: Unable to resolve 59.0: missing requirement [59.0] osgi.ee; (&(osgi.ee=JavaSE)(version=10))

lucee.runtime.exp.NativeException: Unresolved constraint in bundle org.lucee.oracle [59]: Unable to resolve 59.0: missing requirement [59.0] osgi.ee; (&(osgi.ee=JavaSE)(version=10)) at org.apache.felix.framework.Felix.resolveBundleRevision(Felix.java:4097) at org.apache.felix.framework.Felix.startBundle(Felix.java:2114) at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:977) at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:964) at lucee.loader.osgi.BundleUtil.start(BundleUtil.java:135) at lucee.loader.osgi.BundleUtil.start(BundleUtil.java:133) at lucee.runtime.osgi.OSGiUtil._start(OSGiUtil.java:1227) at lucee.runtime.osgi.OSGiUtil._startIfNecessary(OSGiUtil.java:1180) at lucee.runtime.osgi.OSGiUtil.startIfNecessary(OSGiUtil.java:1175) at lucee.runtime.osgi.OSGiUtil._loadBundle(OSGiUtil.java:551) at lucee.runtime.osgi.OSGiUtil.loadBundle(OSGiUtil.java:503) at lucee.commons.lang.ClassUtil.loadClassByBundle(ClassUtil.java:155) at lucee.transformer.library.ClassDefinitionImpl.getClazz(ClassDefinitionImpl.java:110) at lucee.runtime.config.XMLConfigAdmin.setClass(XMLConfigAdmin.java:6611) at lucee.runtime.config.XMLConfigAdmin._updateJDBCDriver(XMLConfigAdmin.java:1799) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:5003) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:4692) at lucee.runtime.config.XMLConfigAdmin._updateRHExtension(XMLConfigAdmin.java:4674) at lucee.runtime.tag.Admin.doUpdateRHExtension(Admin.java:4344) at lucee.runtime.tag.Admin._doStartTag(Admin.java:767) at lucee.runtime.tag.Admin.doStartTag(Admin.java:355) at ext_applications_cfm184$cf.call(/admin/ext.applications.cfm:81) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1015) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:938) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:919) at web_cfm$cf.call(/admin/web.cfm:492) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1015) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:938) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:919) at server_cfm$cf.call(/admin/server.cfm:2) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1015) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:938) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2482) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2468) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2439) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1198) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1144) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: org.osgi.framework.BundleException: Unresolved constraint in bundle org.lucee.oracle [59]: Unable to resolve 59.0: missing requirement [59.0] osgi.ee; (&(osgi.ee=JavaSE)(version=10)

Thanks,

Harry

5

Are you sure that Lucee is using THAT install of Java and not one from elsewhere? Like the embedded version?

6

How do I determine that? We have version 5.3.9.160 of Lucee running, and I don’t see where to find that out.

Thanks,

Harry

7

@harry.devine You can find the java version that lucee is running under the System Information section on the admin overview page. http://127.0.0.1:8888/lucee/admin/server.cfm?action=overview

overview_java
overview_java794×106 3.73 KB

8

OK, I found that Lucee is still using Java 1.8.0_121. I installed the Java 11 JDK as per this article:

https://linuxconcept.com/install-java-on-red-hat-7-operating-system/

I also found this article on upgrading the Lucee JRE: https://docs.lucee.org/guides/installing-lucee/installation-linux/upgrade-JRE.html, but there’s no .bin file to download for Java 11. So how do I update the JRE that is under /opt/lucee/jdk/jre?

Thanks,

Harry

9

9 posts were split to a new topic: Tomcat AJP secret 403 errors

10

Hi @harry.devine

(Sorry if I am stating what you already know)

In linux a BIN is a self-extracting binary file.
For your linux distro - there might not be one.
Oracle Java11 Downloads
Adoptium / AdoptOpenJDK 11 Downloads

But the theme of the page is still correct.

  • Stop lucee
  • Download a Java 11 JRE for your distro
  • Uncompress it
  • Take note of the JRE directory location of the new version
    *** It might not be called JUST jre. It might be something like jre_11_xxx
  • Rename jre_11_xxx to JUST jre - if it isn’t already
  • Remove the current version installed with Lucee
    *** via $ sudo rm -rf /opt/lucee/jdk/jre
  • Move the new jre folder into Lucee
    *** via - sudo mv jre /opt/lucee/jdk/
  • Start Lucee
  • Test

Let us know how you go

11

I am having the same issue updating the oracle driver to 19.12.0

Lucee: 5.3.9.160
Java Used by Lucee: "11.0.16.1 (Oracle Corporation) 64bit "
OS: CentOS7

Unable to resolve org.lucee.oracle [62](R 62.0): missing requirement [org.lucee.oracle [62](R 62.0)] osgi.ee; (&(osgi.ee=JavaSE)(version=10)) Unresolved requirements: [[org.lucee.oracle [62](R 62.0)] osgi.ee; (&(osgi.ee=JavaSE)(version=10))]
12

@harry.devine did you ever resolve this issue?

I am still having the same issue trying to update to oracle 19 drivers.