Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

Tablespace out of space. Can't find errors ORA-01650, 51, 52, 53, 54 etc in the alert logs... Why?

in Storage Management (ASM ACFS DNFS ODM) (MOSC) 3 commentsAnswered ✓

Summary: Alert logs not showing expected error messages. …"ORA-01653: unable to extend table .. in tablespace…" OR similar message.

Is it possible Oracle error ORA-01653 is not written to the alert log even though a tablespace extent cannot be created??

Querying dba_data_files, dba_tablespaces, dba_free_space views we have noticed a tablespace out of space (at 0% available)… We immediately added a new data file to the tablespace. BUT when we examined the alert logs and trace files we did not see any errors concerning tablespace out of space.

DB version: ORACLE Database Enterprise Edition v19c
OS version: Linux RHEL 7

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center