My Oracle Support Banner

datapatch fails with Error: "Error: prereq checks failed!" ,"PLS-00302: component 'SET_SESSION_NAMESPACE' must be declared" (Doc ID 2918274.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


datapatch fails with error:

Connecting to database...OK
Gathering database info...Error: prereq checks failed!
DBD::Oracle::db do failed: ORA-06550: line 1, column 25:
PLS-00302: component 'SET_SESSION_NAMESPACE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicator at char 24 in 'BEGIN sys.dbms_registry.<*>set_session_namespace('SERVER'); END;') [for Statement "BEGIN sys.dbms_registry.set_session_namespace('SERVER'); END;"] at /u01/app/oracle/19c/dbhome_1/sqlpatch/ line 1904.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.