My Oracle Support Banner

EM13c : safelyUsableMB Calculation in "Add Space to Tablespace" Corrective Action Script Is Wrong (Doc ID 2642203.1)

Last updated on DECEMBER 10, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 13.3.1.0.0 to 13.3.2.0.0 [Release 13c to 13.2]
Information in this document applies to any platform.

Symptoms

In Enterprise Manager (EM) Cloud Control, safelyUsableMB Calculation in "Add Space to Tablespace" Corrective Action Script Is Wrong.

The "Add Space to Tablespace" Corrective Action (CA) was to correct the Tablespace alert.
dbAddSpaceTS.pl file is having the script for all the calcuations carried out as part of this CA.

Observed the "safelyUsableMB" calculation was not correct thus providing the -ve value for "ASM projected safely usable free space(MB)".

The "ASM projected safely usable free space (MB) is: -1320899.000", due to this wrong calculation it was not able to use the last datafile which is actually small and created a new Datafile.

Current calculation in dbAddSpaceTS.pl:

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.