Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Question about installing APEX and ORDS

Juan S.Jun 18 2020 — edited Jun 19 2020

Hi all,

I'm new to ORDS and APEX and I've been asked to install both in order to run a complementary solution to ERP Cloud.

I create the DB system (Oracle Vmstandard2.2) on OCI and I downloaded the ORDS and APEX installation files. I following along this doc: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-… and I got the following error when executing the java -jar ords.war install advanced command:

ERROR

[oracle@lacls ords19]$ java -jar ords.war install advanced

2020-06-18T18:26:04.861Z SEVERE No provider found for:  requires oracle.dbtools.common.pools.legacy.ConfigurationFilesProvider

oracle.dbtools.common.di.MissingDependencyException: No provider found for:  requires oracle.dbtools.common.pools.legacy.ConfigurationFilesProvider

        at oracle.dbtools.common.di.DependencyInjectionException.convert(DependencyInjectionException.java:56)

        at oracle.dbtools.common.di.Services.newInstance(Services.java:251)

        at oracle.dbtools.common.di.Services$SelfServices.newInstance(Services.java:532)

        at oracle.dbtools.cmdline.DefaultCommand.command(DefaultCommand.java:171)

        at oracle.dbtools.cmdline.DefaultCommand.execute(DefaultCommand.java:120)

        at oracle.dbtools.cmdline.Commands.execute(Commands.java:208)

        at oracle.dbtools.cmdline.Commands.main(Commands.java:164)

        at oracle.dbtools.cmdline.Commands.main(Commands.java:370)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at oracle.dbtools.jarcl.Entrypoint.invoke(Entrypoint.java:66)

        at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:77)

Caused by: oracle.dbtools.injector.impl.MissingDependencyException: No provider found for:  requires oracle.dbtools.common.pools.legacy.ConfigurationFilesProvider

        at oracle.dbtools.injector.impl.MissingDependencyException.noProvider(MissingDependencyException.java:75)

        at oracle.dbtools.injector.impl.MissingDependencyException.noProvider(MissingDependencyException.java:62)

        at oracle.dbtools.injector.impl.DependencyInjectionException.instantationError(DependencyInjectionException.java:107)

        at oracle.dbtools.injector.impl.ServiceFactory.instantiate(ServiceFactory.java:122)

        at oracle.dbtools.injector.impl.ServiceFactory.access$300(ServiceFactory.java:29)

        at oracle.dbtools.injector.impl.ServiceFactory$ResolvedDependenciesFactory.newInstance(ServiceFactory.java:366)

        at oracle.dbtools.injector.impl.ServiceFactory$ResolvedSingletons.newInstance(ServiceFactory.java:393)

        at oracle.dbtools.injector.impl.SingletonsBase.get(SingletonsBase.java:35)

        at oracle.dbtools.injector.impl.ServiceFactory.resolveDependencies(ServiceFactory.java:244)

        at oracle.dbtools.injector.impl.ServiceFactory.instantiate(ServiceFactory.java:97)

        at oracle.dbtools.injector.impl.ServiceFactory.access$200(ServiceFactory.java:29)

        at oracle.dbtools.injector.impl.ServiceFactory$InstanceFactory.newInstance(ServiceFactory.java:348)

        at oracle.dbtools.injector.impl.Singletons.newInstance(Singletons.java:121)

        at oracle.dbtools.injector.impl.SingletonsBase.get(SingletonsBase.java:35)

        at oracle.dbtools.injector.impl.ServiceFactory.newInstance(ServiceFactory.java:55)

        at oracle.dbtools.injector.impl.InjectorImpl.newInstance(InjectorImpl.java:107)

        at oracle.dbtools.common.di.Services.newInstance(Services.java:249)

        ... 12 more

Caused by: oracle.dbtools.plugin.api.types.TypeDependencyNotAvailableException: The type: (provides oracle.dbtools.common.pools.legacy.ConfigurationFilesProvider) could not be instantiated due to the following error: java.nio.file.AccessDeniedException: /u01/ords-19.4/ords

        at oracle.dbtools.plugin.api.types.TypeDependencyNotAvailableException.from(TypeDependencyNotAvailableException.java:92)

        at oracle.dbtools.plugin.api.types.TypeDependencyNotAvailableException.from(TypeDependencyNotAvailableException.java:40)

        at oracle.dbtools.plugin.api.types.TypeDependencies.newInstance(TypeDependencies.java:154)

        at oracle.dbtools.plugin.api.types.TypeReflections$ReflectiveInstantiator.load(TypeReflections.java:568)

        at oracle.dbtools.injector.impl.ServiceFactory.instantiate(ServiceFactory.java:119)

        ... 25 more

Caused by: java.lang.IllegalStateException: java.nio.file.AccessDeniedException: /u01/ords-19.4/ords

        at oracle.dbtools.common.pools.legacy.ConfigurationFilesBase.ensureDefaultsExist(ConfigurationFilesBase.java:204)

        at oracle.dbtools.common.pools.legacy.ConfigurationFilesBase.<init>(ConfigurationFilesBase.java:47)

        at oracle.dbtools.common.pools.legacy.ConfigurationFilesProvider.<init>(ConfigurationFilesProvider.java:30)

        at java.lang.invoke.MethodHandle.invokeWithArguments(Unknown Source)

        at oracle.dbtools.plugin.api.types.TypeDependencies.newInstance(TypeDependencies.java:151)

        ... 27 more

Caused by: java.nio.file.AccessDeniedException: /u01/ords-19.4/ords

        at sun.nio.fs.UnixException.translateToIOException(Unknown Source)

        at sun.nio.fs.UnixException.rethrowAsIOException(Unknown Source)

        at sun.nio.fs.UnixException.rethrowAsIOException(Unknown Source)

        at sun.nio.fs.UnixFileSystemProvider.createDirectory(Unknown Source)

        at java.nio.file.Files.createDirectory(Unknown Source)

        at java.nio.file.Files.createAndCheckIsDirectory(Unknown Source)

        at java.nio.file.Files.createDirectories(Unknown Source)

        at oracle.dbtools.common.util.Files.mkdirs(Files.java:359)

        at oracle.dbtools.common.pools.legacy.ConfigurationFilesBase.ensureDefaultsExist(ConfigurationFilesBase.java:202)

        ... 31 more

The DB system version is 19c

JDK is Java HotSpot(TM) 64-Bit Server VM (build 25.231-b11, mixed mode)

Could you help me out?

Thanks in advance.

Juan
This post has been answered by cormaco on Jun 19 2020
Jump to Answer

Comments

Juan S.

One clarification: ORDS version is 19.4

cormaco

It seems that you have a file permission problem:

Caused by: java.nio.file.AccessDeniedException: /u01/ords-19.4/ords

Also when installing APEX with ORDS, you should install APEX first:

5   Installing Application Express and Configuring Oracle REST Data Services 

2 people found this helpful
Juan S.

Hi Cormaco,

Thanks for answering! Actually it was an issue with /u01/ords-19.4/ords/defaults.xml file. I granted 755  permissions and it worked, at least it moved forward on the installation process and I'm getting an error far ahead.

On per the link you sent, it states "Oracle Application Express requires Oracle REST Data Services (ORDS) 19.x or later." My understanding would be I need to install ORDS first and then APEX, is this accurate? Sorry in advance to ask this again, but it's a little bit confusing when comparing what you wrote and what the doc says.

Kind regards

Juan

cormaco
Answer

ORDS is a requirement for using APEX as it is the only web listener left that is supported by Oracle, since EPG and OHS are now deprecated:

.4 Web Listener Requirements  

Oracle Application Express requires access to a Web listener.
Supported Web listeners include:
     Oracle REST Data Services (ORDS)
     Embedded PL/SQL Gateway (Deprecated)
     Oracle HTTP Server and mod_plsql (Deprecated)

It does not mean that ORDS must be installed and configured first.

The sequence of steps the installation guide is first APEX then ORDS:

5.4  Downloading and Installing Oracle Application Express    
5.5  Downloading and Installing Oracle REST Data Services 
Marked as Answer by Juan S. · Sep 27 2020
1 person found this helpful
Juan S.

Thanks, cormaco!

Regards

Juan

1 - 5

Post Details

Added on Jun 18 2020
5 comments
1,628 views