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 laterInformation 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
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! |