Restful Services give 404, 500, 503 errors after seen ORA-1017 in ords debug logs
(Doc ID 2139373.1)
Last updated on FEBRUARY 16, 2019
Applies to:Oracle REST Data Services - Version 2.0.10 to 18.4
Information in this document applies to any platform.
*** Checked for relevance on 16-Feb-2019 ****
Testing Restful Services for first time using the sample/demo HR
Was working fine before and suddenly gets 404, 500, or 503 errors in the browser for RESTFul
---logs excerpt --
Error during evaluation of resource template: GET hr/empinfo/, SQL Error Code: 1,017, SQL Error Message: ORA-01017: invalid <username>/<password>; logon denied
The users: APEX_LISTENER, APEX_REST_PUBLIC_USER or ORDS_PUBLIC_USER expired at database (DB) level and even when the availability was restored the Restful access can not be consumed
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document