I actually posted this in the apex forums but perhaps thinking that the issue could be more relevant here.
I dont see this (presentation=HTTP...) etc when i run the lsnrctl status command on the non-working instance. Could this somehow be the cause of the problem? I somehow thought that this should not matter since i am able to get authenticated and the content is being returned. it is just that the javscript etc dont seem to be getting executed.
appreciate any help or suggestions.
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