Thanks for your response. I was researching for the past few hours and found that the mime types for css and js were missing in the xdbconfig.xml file. Now i am going in a loop on how to update the xdbconfig.xml file. I have figured out how to modify and upload the file. However, it is not allowing me to delete the resource using
exec dbms_xdb.deleteresource('/xdbconfig.xml'); but it keeps giving me access denied. Now i am delving deep into the murky world of ACLs etc.
do you know which user would have permissions to delete this resource. i modified the acls and they currently read as follows. I am not able to delete as sysdba or any other user.
select dbms_xdb.getacldocument('/xdbconfig.xml').getclobval() from dual;
<acl description="Public:All privileges to PUBLIC" xmlns="http://xmlns.oracle.com/xdb/acl.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/xdb/acl.xsd http://xmlns.oracle.com/xdb/acl.xsd" shared="true">
I am guessing your about to corrupt the XDB environment ;-)
Have a look here: DBMS_XDB --DBMS_XDB.ADDMIMEMAPPING
You are allowed to update the xdbconfig.xml file if you have the XDBADMIN role... Try to avoid updating the xdbconfig.xml file via an editor or otherwise. The safest methods are via the packages or methods described in http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/appaman.htm#i641079
In this case, there is no reason to fiddle around with the XDB ACL's. Let the database handle it. You are playing with fire, if you do anyway...