My Oracle Support Banner

MGMTDB:SQLPATCH patch fails with error-ORA-01691: unable to extend lob segment SYS.SYS_LOB0000022338C00xxx$$ by 1024 in tablespace SYSTEM (Doc ID 2771430.1)

Last updated on FEBRUARY 10, 2022

Applies to:

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

Symptoms

SQLPLATCH (19.7 to 19.10) failing in last node <NODE2> with below error in MGMTDB.

DBD::Oracle::st execute failed: ORA-01691: unable to extend lob segment SYS.SYS_LOB0000022338C00XXX$$ by 1024 in tablespace SYSTEM
SQL Patching tool complete on Thu Apr 22 02:15:38 2021
2021/04/22 02:15:38 CLSRSC-488: Patching the Grid Infrastructure Management Repository database failed.
Died at /<GI_HOME>/crs/install/crspatch.pm line 1886.
PRGO-1069 : Internal error [# mvDBImpl-modifyMoveDBState-error1 #].
+ RHPCTL_RETVAL=2

[root@<NODE2> ~]# <GI_HOME>/bin/oclumon manage -get repsize

CHM Repository Size = 259260 seconds

 

//From crs_postpatch_apply_oop_danuxb7340db08_2021-04-22_02-36-21AM.log in crs_postpatch_apply_oop_<NODE@>_2021-04-22_02-36-21AM.log

Adding patches to installation queue and performing prereq checks...done
> Installation queue:
> For the following PDBs: CDB$ROOT PDB$SEED GIMR_DSCREP_10
> The following interim patches will be rolled back:
> 30805684 (OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684))
> Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):
> Apply from 19.7.0.0.0 Release_Update 200404035018 to 19.10.0.0.0 Release_Update 210108185017
> The following interim patches will be applied:
> 32067171 (OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171))
>
>
> DBD::Oracle::st execute failed: ORA-01691: unable to extend lob segment SYS.SYS_LOB0000022338C00XXX$$ by 1024 in tablespace SYSTEM>>>>>>>>>>>>>>>>>>>ORA-01691
> ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> INSERT INTO sys.dba_registry_sqlpatch_ru_info
> (patch_id,
> patch_uid,
> patch_descriptor,
> ru_version,
> ru_build_description,
> ru_build_timestamp,
> patch_directory)
> VALUES
> (:patch_id,
> :patch_uid,
> :patch_descriptor,
> :ru_version,
> :ru_build_description,
> TO_TIMESTAMP(:ru_build_timestamp, 'YYMMDDHH24MISS'),
> :patch_directory);
> COMMIT;

CLSRSC-488: Patching the Grid Infrastructure Management Repository database failed.
>End Command output
2021-04-22 02:42:56: CLSRSC-488: Patching the Grid Infrastructure Management Repository database failed.
2021-04-22 02:42:56: ###### Begin DIE Stack Trace ######
2021-04-22 02:42:56: Package File Line Calling
2021-04-22 02:42:56: --------------- -------------------- ---- ----------
2021-04-22 02:42:56: 1: main rootcrs.pl 357 crsutils::dietrap
2021-04-22 02:42:56: 2: crspatch crspatch.pm 1886 main::__ANON__
2021-04-22 02:42:56: 3: crspatch crspatch.pm 2097 crspatch::performPostPatch
2021-04-22 02:42:56: 4: crspatch crspatch.pm 415 crspatch::crsPostPatch
2021-04-22 02:42:56: 5: main rootcrs.pl 370 crspatch::new
2021-04-22 02:42:56: ####### End DIE Stack Trace #######

2021-04-22 02:42:56: ROOTCRS_POSTPATCH checkpoint has failed
2021-04-22 02:42:56: ckpt: -ckpt -oraclebase /<GI_BASE>pt/oracrs/gridbase -chkckpt -name ROOTCRS_POSTPATCH

 

ASM diskgroups are having sufficient free space.

 

ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED HIGH N 512 512 4096 4194304 2589548544 1087839028 13078528 358253500 0 Y DATA1/
MOUNTED HIGH N 512 512 4096 4194304 13603392 13586892 68704 4506062 0 N DBFS1/
MOUNTED HIGH N 512 512 4096 4194304 726517440 723543672 3669280 239958130 0 N RECO1/
MOUNTED HIGH N 512 512 4096 4194304 3698196480 3698145996 18677760 1226489412 0 N SPARSE1/

 


As per the Freespace at each tablespace level in MGMT DB, sysaux and system are having very minimal free space.

 

 

 

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!


In this Document
Symptoms
Cause
Solution
References


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