This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,091 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

after installing ORDS 22.1 can't access apex

2

Answers

  • SmithJohn45
    SmithJohn45 Member Posts: 828 Silver Badge

    @jariola thanks for your passions to help us.

    so, it means i have to make another attempt.

    is there anything for another attempt (upgrade/repair etc.) to must follow, please mention.

    regards

  • jariola
    jariola Architect FinlandMember Posts: 11,045 Gold Crown
    edited Jul 27, 2022 11:40AM

    If I understand correctly, you have now installed ORDS to database, but you didn't create configuration for pool.

    Run again

    ords --config c:\ords\config install
    

    Then just create configuration selecting

    [3] Create or update a database pool only

    Then restart Tomcat, and see does APEX work.

    Also you can check Tomcat logs what it says and does it find configuration for ORDS

    SmithJohn45
  • kevinUCB
    kevinUCB Member Posts: 194 Bronze Badge

    You must (eventually) create the database pool for ORDS to function.

    You can re-run the command

    ords --config c:\ords\config install

    and choose either option 2 or 3 from the Installation Type selection.

    For Tomcat on Windows, launch the application "Configure Tomcat". Navigate to the Java tab, and enter the

    -Dconfig.url=c:\ords\config

    in the Java Options box in the middle of the page.

    SmithJohn45
  • SmithJohn45
    SmithJohn45 Member Posts: 828 Silver Badge

    @jariola

    as instructed, set environment variable: name = JAVA_TOOL_OPTIONS and value = -Dconfig.url=c:\ords\config and re-run the command (below is output of cmd window which run as Administrator): --with env variable JAVA_OPTS this was showing same previous error in browser window--

    C:\Users\Apex221>ords --config c:\ords\config install

    ORDS: Release 22.2 Production on Thu Jul 28 04:22:03 2022

    Copyright (c) 2010, 2022, Oracle.

    Configuration:

     /C:/ords/config/

    The configuration folder C:\ords\config does not contain any configuration files.

    Oracle REST Data Services - Interactive Install

     Enter a number to select the type of installation

      [1] Install or upgrade ORDS in the database only

      [2] Create or update a database pool and install/upgrade ORDS in the database

      [3] Create or update a database pool only

     Choose [2]: 3


     Enter a number to select the database connection type to use

      [1] Basic (host name, port, service name)

      [2] TNS (TNS alias, TNS directory)

      [3] Custom database URL

     Choose [1]:


     Enter the database host name [localhost]:

     Enter the database listen port [1521]:

     Enter the database service name [orcl]: XEPDB1

     Enter a number to select additional feature(s) to enable:

      [1] Database Actions (Enables all features)

      [2] REST Enabled SQL and Database API

      [3] REST Enabled SQL

      [4] Database API

      [5] None

     Choose [1]:


     Enter a number to configure ORDS for standalone mode

      [1] Configure ORDS for standalone mode

      [2] Skip

     Choose [1]: 2


    The setting named: db.connectionType was set to: basic in configuration: default

    The setting named: db.hostname was set to: localhost in configuration: default

    The setting named: db.port was set to: 1521 in configuration: default

    The setting named: db.servicename was set to: XEPDB1 in configuration: default

    The setting named: db.username was set to: ORDS_PUBLIC_USER in configuration: default

    The setting named: db.password was set to: ****** in configuration: default

    The setting named: feature.sdw was set to: true in configuration: default

    The global setting named: database.api.enabled was set to: true

    The setting named: restEnabledSql.active was set to: true in configuration: default

    then run Tomcat and start server. in browser url bar enter: http://localhost:8090/ords 

    now it is showing below error (also same error when enter -Dconfig.url=c:\ords\config in Tomcat's Java tab as mentioned in @kevinUCB post):

    attached log file contains for 2 attempts, first with environment variable JAVA_OPTS and 2nd with JAVA_TOOL_OPTIONS env variable which is showing: null

    please note: i have used XEPDB1 as service name where i have installed Apex 22.1

    regards

  • jariola
    jariola Architect FinlandMember Posts: 11,045 Gold Crown

    Did you check Tomcat log?

    28-Jul-2022 09:29:09.214 WARNING [main] oracle.dbtools.common.logging.JDKLogSink.record The pool named: |default|lo| is invalid and will be ignored: The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked

  • SmithJohn45
    SmithJohn45 Member Posts: 828 Silver Badge

    what it means?

    after last run, i have following files in these folders. files attached, please check. (file extension .xml is not allowed, so i changed to .txt)

    c:\ords\config\databases\default\pool.xml

    c:\ords\config\global\settings.xml

    regards

  • jariola
    jariola Architect FinlandMember Posts: 11,045 Gold Crown
    edited Jul 28, 2022 5:42AM Answer ✓

    You have entered wrong password and/or user when configuring pool. Or database user you have used (ORDS_PUBLIC_USER) is locked or password is expired.

    Check that ORDS_PUBLIC_USER is not locked and make sure you have entered correct password to configuration.

    You can change database user password and then set it for pool

    ords --config c:\ords\config config secret db.password

  • SmithJohn45
    SmithJohn45 Member Posts: 828 Silver Badge
    edited Jul 28, 2022 6:02AM

    on development vm i have used same password " oracle " so i can remember it for all users during Apex and ORDS installations.

    account of ORDS_PUBLIC_USER is showing status as OPEN

    have executed and set password for database pool as mentioned: ords --config c:\ords\config config secret db.password

    and it bring the apex login page. much grateful and highly appreciate your efforts to guide us.

    with best regards

  • frankntx
    frankntx Member Posts: 43 Blue Ribbon

    When you set the db.password when running:

    ords --config c:\ords\config config secret db.password

    what password are you setting/using? The one for ORDS_PUBLIC_USER or the one for SYS or some other user?

    I am going to interpret it as the password for ORDS_PUBLIC_USER is the account related to the above command.

  • frankntx
    frankntx Member Posts: 43 Blue Ribbon

    What does one do if one runs into this issue when installing ORDS 21.4? The command 'ords' does not exist.

    ords --config config mypassword db.password

    -bash: /opt/tomcat/ords/bin/ords: No such file or directory

    Yet the issue is still with the connection pool |default|lo| (see Tomcat log entry below):

    The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked

    oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked

    The ORDS_PUBLIC_USER account is not locked.