Hello,
I've upgraded to an oracle 10g release 2 database and i'm not allowed to access the resources without authentication even if i unlock the ANONYMOUS ACCOUNT. According to the link below, with the release 2 the xdbconfig.xml configuration file has automatically upgraded so that it can have an additional element <allow-repository-anonymous-access>.
https://dpt-info.u-strasbg.fr/doc/oracle/server.102/b14238/afterup.htm
But when i try to modify the xdbconfig.xml file by inserting this element as follows :
DECLARE
configxml SYS.XMLType;
configxml2 SYS.XMLType;
BEGIN
-- Get the current configuration
configxml := DBMS_XDB.cfg_get();
-- Modify the configuration
SELECT INSERTCHILDXML(configxml,'/xdbconfig/sysconfig/protocolconfig/httpconfig', 'allow-repository-anonymous-access', XMLType('<allow-repository-anonymous-access>true</allow-repository-anonymous-access>','http://xmlns.oracle.com/xdb/xdbconfig.xsd'))
INTO configxml2 FROM DUAL;
-- Update the configuration to use the modified version
DBMS_XDB.cfg_update(configxml2);
END;
/
I got an ORA-31043 error indicating that this element is not defined in the schema xdbconfig.xsd. I've checked the schema and it doesn't define the <allow-repository-anonymous-access> element !!!!
Does anybody know what can i do in order to allow anonymous access? I'm new with Oracle XML DB, thanks for your help.
Lionel