I've been able to upgrade ORDS on a Developer Days 19c VM by following the docs here:
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.3/ordig/installing-and-configuring-oracle-rest-data-services.html#GUID-E039CB80-F041-4A7B-930B-3BEA6C9D7351
I've been able to verify this via the RESTful services inside of Apex and via the SQL command in SQL Developer, i.e. select ords.installed_version from dual. Apex is running fine and not seeing any anomalies there. I've also gone through the installation log and didn't see any errors.
I'm wanting to enable SQL Developer Web/Database Actions but unclear on the steps needed to make this happen. I've run this procedure as instructed here, substituting my own info appropriately:
https://docs.oracle.com/en/database/oracle/sql-developer-web/22.3/sdweb/accessing-sql-developer-web.html
BEGIN
ords_admin.enable_schema(
p_enabled => TRUE,
p_schema => 'schema-name',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'schema-alias',
p_auto_rest_auth => TRUE
);
commit;
END;
But when going to the URL to login page and enter the schema name and click the login button I've been getting a 404, not found error.
I'm sure I've missed a step somewhere, just not sure what it might have been. I'd be glad to provide more details as needed. Thanks for any help.