My Oracle Support Banner

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 ****

Symptoms

Testing Restful Services for first time using the sample/demo HR
But also 
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

----

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.