after upgrading from 11.1.1.3 to 11.1.1.4, I get this error:
oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid.
ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DEV_MDS.MDS_INTERNAL_SHREDDED"
ORA-06512: at line 1
even if I drop the schemas and create again, I still have the problem. I tried reinstalling SOASuite, nothing.
I have uninstalled OracleXE, reinstalled it, before I run RCU I do:
set RCU_JDBC_TRIM_BLOCKS=TRUE
and :
run SQLPlus
conn system/oracle (or whatever password)
show parameter processes
by default “processes” should be 40. We should make it 300:
alter system set processes=300 scope=spfile;
conn / as sysdba
shutdown immediate
startup
conn / as sysdba
show parameter sga
(sga_target should be 768MB)
alter system set sga_target=350M scope=spfile;
alter system set sga_max_size=350M scope=spfile;
shutdown immediate
startup
and it works....
If you still get errors, open the 3 MDS packages in Oracle SQL Developer and recompile them, you should get rid of the MDS SHREDDED bla error message
Lesson learned:
a) always wait a couple of weeks from a software release before you install the product yourself
b) choose a volunteer to perform the installation, and give the green light to the others only after he has successfully tested the product
Friday, January 21, 2011
Subscribe to:
Post Comments (Atom)
12 comments:
That was great. How did you figure it out?
Chintan
when you are desperate you try literally everything...
After dropping/recreating/reinstalling the oracle xe I finally ended up with this error. And your post helped me to fix it.
Thanks Pierluigi Vernetto for posting this.
Cheers
Ganesh
I am very glad to have been of some help, Ganesh. Incidentally I always have a small statue of Lord Ganesh with me whenever I go, he protects me and gives me courage.
Thank you so much! It works now.
Just to start a knowledge base here:
I was using the same files without a problem on my old noteboook but started to have some issues on my new one. They have similar specs, the biggest difference is the OS version: Win7 (32bits) vs Win7 (64bits).
Maybe is a problem with the JDK 64bits?
Win 7 64bit is indeed problematic, please do use JDK 64bit all the time for WebLogic ( JDev should work fine with a 32 bit JDK)
Thanks.
I had the same issue and was able to resolve it without re-installing Oracle XE. It was only the RCU_JDBC_TRIM_BLOCKS environment variable that needed to be set when re-creating the MDS schema using RCU.
Great work.After uninstalling XE Database,I again installed,By compiling packages. then setting parameter and running rcu worked
Hey Brother, Thanks a LOT!
I had to come here to say that you helped a lot lot lot!!!
Just for information, i got the same problem, but I didn't Unistalled OracleXE database... i only did this:
1) Got sick with the problem... lol
1.5) Stoped Weblogic.
2) Run rcu.bat and choosed drop->next..next..next..drop..finish..
3) Open SQL and did all this post say you to do to set the parameters
4) Run rcu.bat and choosed create.
5) Started Weblogic and saw:"SOA Platform is running and accepting requests"
6) I got happy!! ;)
Thanks and cya!!
Bruno Barrios
Brazil
hey Bruno thanks a lot. It's comments like your which keep me motivated to write this blog
Thank you!
3 years passed, but the new OSB 12's RCU still has the same problem with the very same packages.
And RCU_JDBC_TRIM_BLOCKS=TRUE fixes it.
Thank you again!
Thanks!Great article.
Post a Comment