1 Reply Latest reply on Jul 13, 2018 2:13 AM by thatJeffSmith-Oracle

    APEX 18.1 installation of ORDS into PDB

    siegwin.port

      Hi,

      I try to install and run ORDS into a PDB using ORACLE 12.2.

      I have the following ords_params.properties:

       

      C:\app\oracle1\rest_data_services\params

       

      #Thu Jul 12 14:14:54 CEST 2018

      db.hostname=vmpc3

      db.password=\!oracle

      db.port=8082

      db.servicename=pdb2

      db.username=APEX_PUBLIC_USER

      migrate.apex.rest=false

      plsql.gateway.add=true

      rest.services.apex.add=true

      rest.services.ords.add=true

      schema.tablespace.default=SYSAUX

      schema.tablespace.temp=TEMP

      standalone.http.port=8082

      standalone.mode=true

      standalone.static.images=C\:\\app\\oracle1\\product\\12.2.0\\apex18\\apex\\images

      standalone.use.https=false

      user.apex.listener.password=\!oracle

      user.apex.restpublic.password=\!oracle

      user.public.password=@058E1A6A1F5455E487B1B8D3190D98242A

      user.tablespace.default=USERS

      user.tablespace.temp=TEMP

       

      When I start  ORDS then I get the following Messages and Errors:

      C:\app\oracle1\rest_data_services>java -jar ords.war install

      ORDS-Schema in Datenbankkonfiguration apex mit Verbindung Host: vmpc3 Port: 8082
      Servicename: pdb2 verifizieren

      Jul 12, 2018 4:06:56 PM oracle.dbtools.rt.config.setup.SchemaSetup getInstallOrU
      pgrade
      WARNUNG: Verbindung zu Benutzer ORDS_PUBLIC_USER jdbc:oracle:thin:@//vmpc3:8082/
      pdb2
      I/O-Fehler: The Network Adapter could not establish the connection konnte nicht
      hergestellt werden
      2018-07-12 16:06:57.572:INFO::main: Logging initialized @119243ms to org.eclipse
      .jetty.util.log.StdErrLog
      Jul 12, 2018 4:06:59 PM
      INFORMATION: HTTP and HTTP/2 cleartext listening on port: 8082
      Jul 12, 2018 4:06:59 PM
      INFORMATION: The document root is serving static resources located in: C:\app\or
      acle1\rest_data_services\params\ords\standalone\doc_root
      2018-07-12 16:07:42.056:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018
      -05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_1
      71-b11
      2018-07-12 16:07:47.744:INFO:oejs.session:main: DefaultSessionIdManager workerNa
      me=node0
      2018-07-12 16:07:47.759:INFO:oejs.session:main: No SessionScavenger set, using d
      efaults
      2018-07-12 16:07:47.759:INFO:oejs.session:main: node0 Scavenging every 600000ms
      Jul 12, 2018 4:07:57 PM
      WARNUNG: The pool named: |apex|| is invalid and will be ignored: Der Verbindungs
      pool namens apex ist aufgrund der folgenden Fehler nicht korrekt konfiguriert: I
      /O-Fehler: The Network Adapter could not establish the connection
      Jul 12, 2018 4:07:58 PM
      WARNUNG: The pool named: |apex|al| is invalid and will be ignored: Der Verbindun
      gspool namens apex_al ist aufgrund der folgenden Fehler nicht korrekt konfigurie
      rt: I/O-Fehler: The Network Adapter could not establish the connection
      Jul 12, 2018 4:07:59 PM
      WARNUNG: The pool named: |apex|pu| is invalid and will be ignored: Der Verbindun
      gspool namens apex_pu ist aufgrund der folgenden Fehler nicht korrekt konfigurie
      rt: I/O-Fehler: The Network Adapter could not establish the connection
      Jul 12, 2018 4:08:00 PM
      WARNUNG: The pool named: |apex|rt| is invalid and will be ignored: Der Verbindun
      gspool namens apex_rt ist aufgrund der folgenden Fehler nicht korrekt konfigurie
      rt: I/O-Fehler: The Network Adapter could not establish the connection
      Jul 12, 2018 4:08:02 PM
      INFORMATION: Oracle REST Data Services initialized
      Oracle REST Data Services version : 18.2.0.r1831332
      Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT

      2018-07-12 16:08:02.244:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@6e1567f1{/ords,null,AVAILABLE}
      2018-07-12 16:08:02.259:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@5cb9f472{/,null,AVAILABLE}
      2018-07-12 16:08:02.259:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@cb644e{/i,null,AVAILABLE}
      2018-07-12 16:08:08.119:INFO:oejs.AbstractConnector:main: Started ServerConnector@38bc8ab5{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8082}
      2018-07-12 16:08:08.228:INFO:oejs.Server:main: Started @189909ms

       

      What can I do to solve the Problems and start ORDS for APEX 18.1

      Thank you for your help

      Regards

      Siegwin