Install ORDS

siegwin.port

Hi,

I have 3 PDBs (PDB1 and APEX 21.2,PDB2 APEX 19.2, PDB3 APEX 21.2).I cannot install ORDS for PDB3 because I get an error:

C:\ords_PDB3>java -jar C:\ords_PDB3\ords.war standalone --parameterFile C:\ords_PDB3\params\ords_params.properties

Diese Oracle REST Data Services-Instanz wurde noch nicht konfiguriert.

Nehmen Sie an den folgenden Prompts die entsprechenden Einstellungen vor

Geben Sie den Speicherort für Konfigurationsdaten ein: C:\ords_PDB3\params\ords_params.properties

Exception in thread "main" java.lang.reflect.InvocationTargetException

       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: java.lang.OutOfMemoryError: Java heap space

       at java.util.Arrays.copyOf(Unknown Source)

       at java.io.ByteArrayOutputStream.grow(Unknown Source)

       at java.io.ByteArrayOutputStream.ensureCapacity(Unknown Source)

       at java.io.ByteArrayOutputStream.write(Unknown Source)

       at java.util.zip.DeflaterOutputStream.deflate(Unknown Source)

       at java.util.zip.DeflaterOutputStream.write(Unknown Source)

       at java.util.zip.ZipOutputStream.write(Unknown Source)

       at java.nio.channels.Channels$WritableByteChannelImpl.write(Unknown Source)

       at oracle.dbtools.util.StreamCopy.drain(StreamCopy.java:44)

       at oracle.dbtools.util.StreamCopy.drain(StreamCopy.java:31)

       at oracle.dbtools.zip.ZipBuilder._addEntry(ZipBuilder.java:55)

       at oracle.dbtools.zip.ZipBuilder.addEntry(ZipBuilder.java:63)

       at oracle.dbtools.common.zip.ZipBuilder.addEntry(ZipBuilder.java:24)

       at oracle.dbtools.common.zip.MutatedZip.mutate(MutatedZip.java:68)

       at oracle.dbtools.common.zip.MutatedZip.<init>(MutatedZip.java:34)

       at oracle.dbtools.cmdline.ModifyConfigDir.modified(ModifyConfigDir.java:145)

       at oracle.dbtools.cmdline.ModifyConfigDir.modify(ModifyConfigDir.java:117)

       at oracle.dbtools.cmdline.Commands.configurationContext(Commands.java:568)

       at oracle.dbtools.cmdline.Commands.prepareApplicationContext(Commands.java:447)

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

       ... 6 more

Meine Parameterdatei sieht wie folgt aus:

#

db.hostname=pc4

db.port=1522

db.servicename=pc4pdb3

# db.sid=

db.username=APEX_PUBLIC_USER

migrate.apex.rest=false

rest.services.apex.add=

rest.services.ords.add=true

schema.tablespace.default=SYSAUX

schema.tablespace.temp=TEMP

standalone.http.port=7780

standalone.static.images=

user.tablespace.default=USERS

user.tablespace.temp=TEMP

When I used

C:\ords_PDB3>java -Xmx1024m -Xms1024m -jar ords.war install advanced

Als Konfigurationsdatei habe ich angegeben:

C:\ords_PDB3\params\ords_params.properties

Leider erfolglos

2022-03-20T06:53:04.981Z 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

Please help me to install ORDS for PDB3

Regards,

Siegwin

Christian Pitet

Maybe you could find an answer on the Oracle ORDS forum :

https://community.oracle.com/tech/developers/categories/oracle_rest_data_services

Bas de Klerk

I see some java out of memory error in your output. Retry with bigger memory settings.

java -Xmx1024m -jar ords.war

regards

Bas