PaaS Partner Community

  • October 31, 2016

REST enabled Oracle Database Cloud Service – my first experiences by Niall Commiskey

Juergen Kress
PaaS & Middleware Partner Adoption


I have heard that APEX supports REST so I decided to try this out on my SOA CS environment's
DB CS instance. AS per usual, I studiously avoided reading any documentation.
This should be simple, right?
I created a simple table Customers -

Now, as luck would have it I locked my ADMIN APEX user out.
This I fixed as follows -
ssh into the DB CS machine
start sqlplus

conn system/yourPwd@yourSOADB;

alter session set current_schema = APEX_050000;

select user_id, substr(user_name, 1,10), account_locked from wwv_flow_fnd_user;

update APEX_050000.WWV_FLOW_FND_USER

set web_password = 'yourNewPassword'

where user_name = 'ADMIN'

Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.