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