My Oracle Support Banner

Datapatch with Big PDB List Results in Error "SP2-0027: Input is too long (> 4999 characters) - line ignored" (Doc ID 2688174.1)

Last updated on AUGUST 25, 2020

Applies to:

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

Symptoms

 Datapatch execution for CDB with huge number of PDBs (~250) results in below error -

Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Error in bootstrap log /oracle/orabase/cfgtoollogs/sqlpatch/sqlpatch_157091_2019_02_28_11_00_25/bootstrap1_<CDB>_CDBROOT.log:
Error at line 2: SP2-0027: Input is too long (> 4999 characters) - line ignored

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.