The server is asking for your user name and password. The server reports that it is from XDB.

Issue:

“The server” “is asking for
your user name and password”. “The server reports that it is from XDB”
Got the above error while accessing the apex
application page and it’s not accepting any password.

Environment:

DB Version: 12.1.0.2
Apex version: 5.1 and configured using PL/SQL
gateway.

Solution
  • Verify whether local_listener parameter is set,
    If not set this parameter and register.

     SQL> Alter system register
  • Make sure DB user ANONYMOUS account is unlocked.
  • Enable enable anonymous access to the XML DB repository 

CONN sys/password AS SYSDBA

SET SERVEROUTPUT ON
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;
/

  • February 26, 2019 | 25 views
  • Comments