Forum Stats

  • 3,875,722 Users
  • 2,266,954 Discussions
  • 7,912,318 Comments

Discussions

after installing ORDS 22.1 can't access apex

2

Answers

  • SmithJohn45
    SmithJohn45 Member Posts: 789 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 Member Posts: 10,926 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: 789 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 Member Posts: 10,926 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: 789 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 Member Posts: 10,926 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: 789 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.