Test Restful Services gives 404,500, 503 errors after ORA-1017 in ords debug logs (Doc ID 2139373.1)

Last updated on MAY 10, 2017

Applies to:

Oracle REST Data Services - Version 2.0.10 to 3.0.5
Information in this document applies to any platform.

Symptoms

Testing Restful Services for first time using the sample HR
or
Was working fine before and suddenly started giving 404, 500, or 503 errors in the browser

---

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 and even when the availability was restored the Restful access can not be performed

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms