Forum Stats

  • 3,874,176 Users
  • 2,266,677 Discussions
  • 7,911,754 Comments

Discussions

ORDS install latest version and 22.2 failed and unable to launch APEX 22.1

Hi,

I am doing a fresh install ORDS 22.2

I get the following error

  • The procedure named apex could not be accessed, it may not be declared, or the user executing this request may not have been granted execute privilege on the procedure, or a function specified by security.requestValidationFunction configuration property has prevented access. Check the spelling of the procedure, check that the execute privilege has been granted to the caller and check the configured security.requestValidationFunction function.

Since it is a fresh install I am not sure if I need to remove the lines suggested above the XML file as per the link below; still I tried and I had no luck

ORDS-22001 After Upgrading Apex And Ords To 22.1 (oracle.com)

Please advise.

Also, I tried to install the latest ORDS 22.3.1 and for that I get the following error; so my attempts for the past week with different versions have failed

2022-10-24T17:45:03.236Z WARNING   * jdbc.MaxLimit in configuration |default|lo| is using a value of 10, this setting may not be sized adequately for a production environment * 2022-10-24T17:45:03.252Z WARNING   * jdbc.InitialLimit in configuration |default|lo| is using a value of 3, this setting may not be sized adequately for a production environment * 2022-10-24T17:45:08.314Z INFO    Oracle REST Data Services initialized Oracle REST Data Services version : 22.3.1.r2901647 Oracle REST Data Services server info: jetty/10.0.11 Oracle REST Data Services java info: Java HotSpot(TM) 64-Bit Server VM 11.0.16.1+1-LTS-1  "2022-10-24T17:45:10.955Z WARNING  PL/SQL Gateway mode of pool |default|lo| is set to proxied but ORDS could not read the proxy configuration from the database oracle.dbtools.url.mapping.db.DatabaseURLMappingBase$PlsqlGatewayConfigurationException: PL/SQL Gateway mode of pool |default|lo| is set to proxied but ORDS could not read the proxy configuration from the database ' ' Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:629)     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:563)     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1230)     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:511)     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:162)     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1009)     at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1270)     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1148)     at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1660)     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1469)     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3760)     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3935)     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1101)     at oracle.ucp.jdbc.proxy.oracle$1ucp$1jdbc$1proxy$1oracle$1StatementProxy$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeQuery(Unknown Source)     at oracle.dbtools.url.mapping.db.DatabaseURLMappingBase$PlsqlGatewayProxyUserLoader.call(DatabaseURLMappingBase.java:1236)     ... 77 more Caused by: Error : 942, Position : 45, Sql = select plsql_gateway_user from ords_metadata.plsql_gateway_config where runtime_user = sys_context('userenv', 'session_user'), OriginalSql = select plsql_gateway_user from ords_metadata.plsql_gateway_config where runtime_user = sys_context('userenv', 'session_user'), Error Msg = ORA-00942: table or view does not exist     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:636)     ... 93 more 2022-10-24T17:45:11.987Z WARNING  :::got unchecked exception from user-defined connection labeling callback 2022-10-24T17:45:12.035Z SEVERE   <wIuNJ9k1WAf6ngTc7fHnyA> GET localhost /ords/apex_admin 503 The database user for the connection pool named |default|lo|, is not able to proxy to the schema named APEX_PUBLIC_USER. This could be a configured restriction on the maximum number of database sessions or an authorization failure. ServiceUnavailableException [statusCode=503, logLevel=SEVERE, reasons=[The database user for the connection pool named |default|lo|, is not able to proxy to the schema named APEX_PUBLIC_USER. This could be a configured restriction on the maximum number of database sessions or an authorization failure.]]

Thanks,

Nisha

Answers