This content has been marked as final. Show 2 replies
Reversing HTTPS Requirement To reverse the Require HTTPS instance-level requirement:
1. Connect in SQL*Plus or SQL Developer with the Application Express engine
schema as the current schema, for example:
■ On Windows:
■ On UNIX and Linux:
SYSTEM_DRIVE:\ sqlplus /nolog connect sys as sysdba
When prompted enter the appropriate password.
$ sqlplus /nolog connect sys as sysdba
2. Run the following statement:
3. Run the following statements:
ALTER SESSION SET CURRENT_SCHEMA = APEX_040100;
This will set the HTTPS back to No
BEGIN APEX_INSTANCE_ADMIN.SET_PARAMETER('REQUIRE_HTTPS', 'N'); commit; end; /
Thank you, Mehabub.
I've already re-installed the APEX, after exporting my app using PL\SQL via this VERY helpful post by Joe Upshaw: Re: How to Export APEX Pages (don't forget to populate the app ID in APEX_APP_BACKUP_TARGETS), and that helped to reverse this situation.
Your suggestion worked also to reverse this setting (yes, checked it again).
But the question is what is the problem in requiring HTTPS, and how do I solve it.