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.
Blog 
Twitter 
LinkedIn ![image[7][2][2][2]](https://soacommunity.files.wordpress.com/2013/04/image7222.png?w=20&h=20&h=20 "image[7][2][2][2]"){kind=small}
Facebook ![clip_image002[8][4][2][2][2]](https://soacommunity.files.wordpress.com/2013/04/clip_image00284222.jpg?w=26&h=23&h=23 "clip_image002[8][4][2][2][2]"){kind=small}
Wiki
About Jürgen Kress
