REST enabled Oracle Database Cloud Service – my first experiences by Niall Commiskey
October 31, 2016 Leave a comment
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.
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.