Error LS-00302: component 'SESSION_NAMESPACE' must be declared

[Former Member]

Hi All,

I am getting an error when i try to execute the script sapbundle/SAP_102051_201012/catsbp.sql.This is part of the post installation steps for Oracle® Database SAP® Bundle Patch 10.2.0.5.1 - 201012

The error we are getting is

ERROR at line 1:

ORA-06550: line 1, column 47:

PLS-00302: component 'SESSION_NAMESPACE' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

Any pointers related to this issue will be appreciated.Thanks.

[Former Member · Accepted solution]

Hi Ambarish,

Can you please check dbms_registry.Execute the script

$ORACLE_HOME/rdbms/admin/prvtcr.plb

Before doing that please make sure that you backup the binaries first.

[Former Member · Accepted solution]

Thanks Sanketh It worked out.