My Oracle Support Banner

EM 13.5C: Corrective Action Created For "Tablespace Full" Metric Fail With An Error "ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range" 32K Blocksize Tablespaces (Doc ID 2993759.1)

Last updated on DECEMBER 18, 2023

Applies to:

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

Symptoms

Corrective Action Created for "Tablespace Full" Metric for 32K Blocksize tablespace.

When Corrective action "Add Space to Tablespace" for adding space in 32K blocksize Tablespace is triggered , failed with below error when MAXSIZE kept as blank

Below error message shows in CA job when trying to add data files.

ALTER TABLESPACE <TABLESPACE_NAME> ADD DATAFILE '+DATA' SIZE 1024M AUTOEXTEND ON NEXT 256M MAXSIZE 131072M
Error at line 1
ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range

 

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.