ORA-03297: file contains used data beyond requested RESIZE value in MGMTDB

(Doc ID 2403295.1)

Last updated on MAY 30, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

The following message reported when resizing the GIMR.

oracle@dc2sscdb201:~$ oclumon manage -reposchangerepossize 8000
Failed to change Cluster Health Monitor repository size.Please retry the operation.

Ologgerd.trc:
=========


2018-03-14 12:33:10.811128 : default:3952101120: Expanding data file size from 2048 MB to 8000 MB
2018-03-14 12:33:10.815500 : CRFOCI:3952101120: crfoci_checkerr: Error - OCI_ERROR ORA-03297: file contains used data beyond requested RESIZE value

2018-03-14 12:33:10.815503 : CRFOCI:3952101120: crfoci_stmt_execute: OCIStmtExecute failed
2018-03-14 12:33:10.815504 : CRFOCI:3952101120: crfoci_stmt_direct_execute: crfoci_stmt_execute failed [19]
2018-03-14 12:33:10.815506 : default:3952101120: crflogdbora_update_config: crfoci_stmt_prpalter returns [19] for statment ALTER TABLESPACE SYSMGMTDATA RESIZE 8000 M
2018-03-14 12:33:10.815507 : default:3952101120: crflogdbora_resizeTSpace: crflogdbora_update_config failed
2018-03-14 12:33:10.816093 : default:3952101120: crflogdbora_resizedb_space: crflogdbora_resizeTSpace failed returns [-11]
2018-03-14 12:33:10.816095 : default:3952101120: crflogdbora_resizedb_space: Creating space connection 1
2018-03-14 12:33:10.816097 : CRFOCI:3952101120: crfoci_conn_create: Connection string discoverd
2018-03-14 12:33:10.835181 : CRFOCI:3952101120: crfoci_getconnstr: DB connection string (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 169.254.120.183)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = dc2sscdbcl)))
2018-03-14 12:33:10.835184 : CRFOCI:3952101120: crfoci_conn_create: Trying to connect to (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 169.254.120.183)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = dc2sscdbcl))).
2018-03-14 12:33:10.854228 : default:3952101120: crflogdbora_space_stmtprep: check table space size in table
2018-03-14 12:33:10.854478 : default:3952101120: crflogdbora_space_stmtprep: Table space size is 2048 MB
2018-03-14 12:33:10.855385 : default:3952101120: space connection is valid
2018-03-14 12:33:10.855388 : default:3952101120: Received new table space size 8000 MB, currect size 2048 MB  <=====Current size is 2048 MB only.
2018-03-14 12:33:10.855389 : default:3952101120: Expanding data file size from 2048 MB to 8000 MB
2018-03-14 12:33:10.860764 : CRFOCI:3952101120: crfoci_checkerr: Error - OCI_ERROR ORA-03297: file contains used data beyond requested RESIZE value <======

 

 

Cause

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 hundreds of Community platforms