Forum Stats

  • 3,750,413 Users
  • 2,250,175 Discussions
  • 7,866,972 Comments

Discussions

localhost:8080/ords/apex_admin user/pwd ?

User_IK6T0
User_IK6T0 Member Posts: 15 Green Ribbon

It apperas I installed everything (db,apex,ords) OK.


does not work: localhost:8080/ords/apex_admin


added following to listener.ora:

 (DESCRIPTION=

     (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=8080))(Presentation=HTTP)(Session=RAW)

   )

 )


at this point listener service will not even start without that in listener.ora


Anyway, at this point even only http://localhost:8080/ brings up

user name/pwd form.


Have no idea which user name and pwd ?

'admin' and pwd of db does not work.


I guess, since I did

alter user APEX_PUBLIC_USER account unlock;

the user should be that, APEX_PUBLIC_USER ? Does not work either.


I did set username & pwd with @apxchpwd.sql

That does not work either.


Since I read APEX_PUBLIC_USER has some randome pwd, executed:

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password

Has no effect to my problem, can't log in.

Answers

  • cormaco
    cormaco Member Posts: 1,644 Bronze Crown

    Did you configure and run ORDS?

    Also you have to close port 8080 in the database for ORDS to use it.

  • User_IK6T0
    User_IK6T0 Member Posts: 15 Green Ribbon

    F:\ORACLEDB_ORDS>java -jar ords.war

    Using existing ORDS configuration files located at F:\ORACLEDB_ORDS\params\ords


    Verify ORDS schema in Database Configuration apex using connection url jdbc:orac

    le:thin:@//localhost:1521/XEPDB1


    Retrieving information.

    2021-09-07T06:17:33.387Z INFO Oracle REST Data Services schema version 21

    .2.4.r2431032 is installed.

    2021-09-07T06:17:33.556Z INFO HTTP and HTTP/2 cleartext listening on host

    : localhost port: 9090

    2021-09-07T06:17:33.604Z INFO The document root is serving static resourc

    es located in: F:\ORACLEDB_ORDS\params\ords\standalone\doc_root

    2021-09-07T06:17:34.784Z INFO Configuration properties for: |apex||

    cache.caching=false

    cache.directory=/tmp/apex/cache

    cache.duration=days

    cache.expiration=7

    cache.maxEntries=500

    cache.monitorInterval=60

    cache.procedureNameList=

    cache.type=lru

    database.api.enabled=true

    db.connectionType=basic

    db.hostname=localhost

    db.port=1521

    db.servicename=XEPDB1

    debug.debugger=false

    debug.printDebugToScreen=false

    error.keepErrorMessages=true

    error.maxEntries=50

    jdbc.DriverType=thin

    jdbc.InactivityTimeout=1800

    jdbc.InitialLimit=3

    jdbc.MaxConnectionReuseCount=1000

    jdbc.MaxLimit=10

    jdbc.MaxStatementsLimit=10

    jdbc.MinLimit=1

    jdbc.statementTimeout=900

    log.logging=false

    log.maxEntries=50

    misc.compress=

    misc.defaultPage=apex

    restEnabledSql.active=true

    security.disableDefaultExclusionList=false

    security.maxEntries=2000

    security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

    security.validationFunctionType=plsql

    db.password=******

    db.username=APEX_PUBLIC_USER

    resource.templates.enabled=true


    2021-09-07T06:17:34.786Z WARNING *** jdbc.MaxLimit in configuration |apex||

    is using a value of 10, this setting may not be sized adequately for a productio

    n environment ***

    2021-09-07T06:17:34.787Z WARNING *** jdbc.InitialLimit in configuration |ape

    x|| is using a value of 3, this setting may not be sized adequately for a produc

    tion environment ***

    2021-09-07T06:17:38.294Z WARNING The pool named: |apex|al| is invalid and wi

    ll be ignored: The username or password for the connection pool named |apex|al|,

    are invalid, expired, or the account is locked

    2021-09-07T06:17:38.384Z INFO Configuration properties for: |apex|pu|

    cache.caching=false

    cache.directory=/tmp/apex/cache

    cache.duration=days

    cache.expiration=7

    cache.maxEntries=500

    cache.monitorInterval=60

    cache.procedureNameList=

    cache.type=lru

    database.api.enabled=true

    db.connectionType=basic

    db.hostname=localhost

    db.port=1521

    db.servicename=XEPDB1

    debug.debugger=false

    debug.printDebugToScreen=false

    error.keepErrorMessages=true

    error.maxEntries=50

    jdbc.DriverType=thin

    jdbc.InactivityTimeout=1800

    jdbc.InitialLimit=3

    jdbc.MaxConnectionReuseCount=1000

    jdbc.MaxLimit=10

    jdbc.MaxStatementsLimit=10

    jdbc.MinLimit=1

    jdbc.statementTimeout=900

    log.logging=false

    log.maxEntries=50

    misc.compress=

    misc.defaultPage=apex

    restEnabledSql.active=true

    security.disableDefaultExclusionList=false

    security.maxEntries=2000

    security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

    security.validationFunctionType=plsql

    db.password=******

    db.username=ORDS_PUBLIC_USER

    resource.templates.enabled=true


    2021-09-07T06:17:38.384Z WARNING *** jdbc.MaxLimit in configuration |apex|pu

    | is using a value of 10, this setting may not be sized adequately for a product

    ion environment ***

    2021-09-07T06:17:38.384Z WARNING *** jdbc.InitialLimit in configuration |ape

    x|pu| is using a value of 3, this setting may not be sized adequately for a prod

    uction environment ***

    2021-09-07T06:17:39.724Z WARNING The pool named: |apex|rt| is invalid and wi

    ll be ignored: The username or password for the connection pool named |apex|rt|,

    are invalid, expired, or the account is locked

    2021-09-07T06:17:41.574Z INFO Oracle REST Data Services initialized

    Oracle REST Data Services version : 21.2.4.r2431032

    Oracle REST Data Services server info: jetty/9.4.43.v20210629


    After that I get login screen on

    localhost:9090/ords/apex_admin

    localhost:9090/ords/apex


    with just before message: There are issues with the configuration of the Static Files in your environment. Please consult the "Configuring Static File Support" section in the Application Express Installation Guide.


    login: APEX_PUBLIC_USER/pwd - ither your sessin expired or invalid user credentials

    user name and pwsd set with @apxchpwd.sql does not work, should it work ?


    Any insight to that ?