How to stop XDB Authentication window in Apex
How to stop XDB Authentication window in Apex Log in as SYS with SYSDBA Privilege in the database
1 |
SQL> SET SERVEROUTPUT ON; |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
DECLARE l_configxml XMLTYPE; l_value VARCHAR2(5) := ‘true’; — (true/false) BEGIN l_configxml := DBMS_XDB.cfg_get(); IF l_configxml.existsNode(‘/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access’) = 0 THEN – Add missing element. SELECT insertChildXML ( l_configxml, ‘/xdbconfig/sysconfig/protocolconfig/httpconfig’, ‘allow-repository-anonymous-access’, XMLType(‘‘ || l_value || ‘‘), ‘xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”‘ ) INTO l_configxml FROM dual; DBMS_OUTPUT.put_line(‘Element inserted.’); ELSE – Update existing element. SELECT updateXML ( DBMS_XDB.cfg_get(), ‘/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()’, l_value, ‘xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”‘ ) INTO l_configxml FROM dual; DBMS_OUTPUT.put_line(‘Element updated.’); END IF; DBMS_XDB.cfg_update(l_configxml); DBMS_XDB.cfg_refresh; END; / |
Note : the above procedure must be executed successfully. Also execute the below command, you can copy and paste and execute :
1 |
SQL > ALTER USER ANONYMOUS IDENTIFIED BY anonymous; |
1 |
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK; |
1 |
SQL> ALTER USER XDB IDENTIFIED BY xdb; |
1 |
SQL> ALTER USER XDB ACCOUNT UNLOCK; |
After completing above steps …