I am using Apex 4.2 on Oracle 11g database on Linux platform .We are using Glassfish server as Middle tier. To prevent access from unauthorized IP address,I logged in to APEX workspace Administator account and then i went to MANAGE INSTANCE-->SECURITY-->RESTRICTED IP ADDRESS. Where I entered one IP address (which was dynamic as i was using Internet through Dongle). Now I couldn't access Developer Login page and also Admin login page as I am not getting same IP address from internet service provider. While the application is accessible anywhere as end user. That is i can't connect into workspace as developer but can access application as end User.
I found one solution on internet and then i tried it but it doesn't working. I did following steps to resolve restricted IP address issue.
1. Login as sysdba
2. Alter session set current_schema=apex_040200
So, plz let me know what are the possible solutions.
Login as Sys and change current schema to apex_40200 and run the following script.
wwv_flow_platform.set_preference( p_preference_name => 'RESTRICT_IP_RANGE',
p_preference_value => null );
faced same problem and one of the forum gave this solution, hope it works for you too..