Utility Oratop Fails With ORA-01476 (Doc ID 2941209.1)
Applies to:
Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Information in this document applies to any platform.
Symptoms
The command oratop is failed caused by ORA-01476 as below:
./oratop -i 10 / as sysdba
oratop: Release 16.5.1 Production on Sun Dec 11 10:30:00 CST 2022
Copyright (c) 2011, Oracle. All rights reserved.
Connecting
ORA-01476: divisor is equal to zero
Error - database not open.
Changes
Upgraded to 19c.
Cause
The below SQL is included into oratop utility from 19c:
SELECT
(SPACE_USED - SPACE_RECLAIMABLE) / SPACE_LIMIT * 100 fra
FROM
V$RECOVERY_FILE_DEST
If the value of V$RECOVERY_FILE_DEST.SPACE_LIMIT is 0(after configure Fast Recovery Area, then dis-configure it), the above SQL will fail by error ORA-01476.
Solution
Setting parameter db_recovery_file_dest_size to a non-zero value.