My Oracle Support Banner

ORA-01017 When Trying To Test Restfull Service Via APEX (Doc ID 2382969.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle REST Data Services - Version 17.4.1 and later
Information in this document applies to any platform.

Symptoms

On : 17.4.1 version, All Issues

ORA-01017 when trying to test a RESTful service via APEX


APEX Version: 5.1.4.00.08
ORDS Version: 17.4.1.353.06.48

APEX is running fine after the configuration is done.
When trying to configure and test a RESTful Service via APEX it gives me the following error:

The username or password for the connection pool named apex_rt, are invalid, expired, or the account is locked.

But the user APEX_REST_PUBLIC_USER is not expired the password is correct and the user is not locked.
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
APEX_INSTANCE_ADMIN_USER EXPIRED
APEX_050100                           EXPIRED
APEX_LISTENER                        OPEN
APEX_PUBLIC_USER                 OPEN
APEX_REST_PUBLIC_USER       OPEN

It is possible to connect to the user via SQL*Plus.



ERROR
-----------------------
ORA-01017

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