The server is asking for your user name and password. The server reports that it is from XDB.
your user name and password”. “The server reports that it is from XDB”
application page and it’s not accepting any password.
gateway.
- Verify whether local_listener parameter is set,
If not set this parameter and 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;
/