This content has been marked as final. Show 2 replies
Hi, Ogan, I got this resolved.
After the upgrade by using DBUA, I tried to execute scripts to configure ACLs since my database has dependent objects. That's when I got error saying that dbms_network_acl_admin was not found.
when I queried DBA_registry , it didn't list XDB as one of the components. So, I understood this didn't get installed during the upgrade with DBUA. So, I installed XDB manually by running catqm.sql. This however created a lot of invalid objetcs which wouldnt get validated after tryign to recompile them with utlrp.sql. Most of the errors were looping chain of synonyms. Finally, I de-installed it and re-installed xdb and ran utlrp.sql to validate all the invalid objects. Now, everything is fine.
I guess xdb doesn't get installed during the dbua upgrade and maybe it needs to be installed seperately. But, that's kind of confusing because xdb is supposed to be a mandatory component in 11g. Can someone please clarify this?