Skip to Main Content

APEX

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!

ORDS install problem - Failed to connect to ORDS_PUBLIC_USER

alan_dNov 27 2019 — edited Nov 27 2019

Hello, I am trying to install Oracle APEX 19.2, ORDS 19.2 on a Windows 10 machine running Oracle database 18c XE.

I have successfully installed 18c XE and APEX, but cannot get ORDS working after installing as follows:

C:\Oracle\ords19.2>java -jar ords.war install simple --parameterFile C:\ORACLE\ORDS19.2\PARAMS\ORDS_PARAMS.PROPERTIES

Nov 27, 2019 1:33:58 AM oracle.dbtools.rt.config.setup.SchemaSetup getInstallOrUpgrade

WARNING: Failed to connect to user ORDS_PUBLIC_USER jdbc:oracle:thin:@localhost:1521:xe

IO Error: The Network Adapter could not establish the connection

Nov 27, 2019 1:33:59 AM

INFO: reloaded pools: []

The procedure fails to create the user ORDS_PUBLIC_USER.

Here is my parameters file (passwords removed):

#Wed Nov 27 01:33:59 EST 2019

db.hostname=localhost

db.password=

db.port=1521

db.sid=xe

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=8080

standalone.mode=false

user.apex.listener.password=

user.apex.restpublic.password=

user.public.password=

user.tablespace.default=USERS

user.tablespace.temp=TEMP

I can connect without problem to the database with sqlplus and Oracle EM at localhost:5500/em...

Please advise what to try next as I can't find any other resources that address this issue.

Any help would be much appreciated!

Let me know if I can post any addtional info to help troubleshoot.

Alan

Comments
Post Details
Added on Nov 27 2019
8 comments
11,538 views