"PLS-00201: identifier 'MDS_INTERNAL_SHREDDED.GETREPOSITORYVERSION' must be declared" Error When Starting WLS_Spaces (Doc ID 863237.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle WebCenter Portal - Version 11.1.1.1.0 and later
Information in this document applies to any platform.
Checked for relevance on 20-Feb-2015


Symptoms

Attempting to start WLS_Spaces after installation of WebCenter 11g is showing this error:

oracle.mds.internal.lcm.logging.MDSLCMLogger severe
SEVERE:
oracle.mds.lcm.exception.MDSLCMException: ORA-06550: line 1, column 12:
PLS-00201: identifier 'MDS_INTERNAL_SHREDDED.GETREPOSITORYVERSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.mds.internal.lcm.MDSLifecycleListenerImpl.start(MDSLifecycleListenerImpl.java:169)
at oracle.mds.lcm.weblogic.WLLifecycleListener.preStart(WLLifecycleListener.java:191)
at

weblogic.application.internal.flow.BaseLifecycleFlow$PreStartAction.run(BaseLifecycleFlow.java:277)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at

weblogic.application.internal.flow.BaseLifecycleFlow$LifecycleListenerAction.invoke(BaseLifecycleFlo
w.java:194)
at weblogic.application.internal.flow.BaseLifecycleFlow.preStart(BaseLifecycleFlow.java:57)
at weblogic.application.internal.flow.HeadLifecycleFlow.prepare(HeadLifecycleFlow.java:279)
at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:609)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:185)
at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:53)
at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
at
....
Caused by: oracle.mds.internal.persistence.db.fcf.MDSDBIOException: ORA-06550: line 1, column
12:
PLS-00201: identifier 'MDS_INTERNAL_SHREDDED.GETREPOSITORYVERSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.mds.internal.persistence.db.fcf.FailoverUtils.executeDBCode(FailoverUtils.java:555)
at oracle.mds.internal.persistence.db.fcf.FailoverUtils.executeDBFunction(FailoverUtils.java:429)
at oracle.mds.persistence.stores.db.DBMetadataStore.getRepositoryVersion(DBMetadataStore.java:939)
at oracle.mds.persistence.stores.db.DBMetadataStore.checkRepositoryCompatibilityInternal(DBMetadataStore.java:1208)
at oracle.mds.persistence.stores.db.DBMetadataStore.checkRepositoryCompatibility(DBMetadataStore.java:847)
at oracle.mds.persistence.stores.db.DBMetadataStore.checkCompatibility(DBMetadataStore.java:1090)
at oracle.mds.persistence.stores.db.DBMetadataStore.<init>(DBMetadataStore.java:268)
at oracle.mds.internal.lcm.MDSLCMManager.createMetadataStore(MDSLCMManager.java:1869)
at oracle.mds.internal.lcm.deploy.DeployManager.createMetadataStore(DeployManager.java:6
oracle.mds.internal.lcm.logging.MDSLCMLogger severe
SEVERE:
oracle.mds.lcm.exception.MDSLCMException: ORA-06550: line 1, column 12:
PLS-00201: identifier 'MDS_INTERNAL_SHREDDED.GETREPOSITORYVERSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.mds.internal.lcm.MDSLifecycleListenerImpl.start(MDSLifecycleListenerImpl.java:169)
at oracle.mds.lcm.weblogic.WLLifecycleListener.preStart(WLLifecycleListener.java:191)
at

weblogic.application.internal.flow.BaseLifecycleFlow$PreStartAction.run(BaseLifecycleFlow.java:277)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at
....
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: oracle.mds.internal.persistence.db.fcf.MDSDBIOException: ORA-06550: line 1, column
12:
PLS-00201: identifier 'MDS_INTERNAL_SHREDDED.GETREPOSITORYVERSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms