Database Administration (MOSC)

MOSC Banner

Oracle 21c: ora-00059 even after upping db_files

This may be related to our unfamiliarity with CDB/PDB installs. We have an Oracle 21c db that has just one PDB. That PDB had the default db_files of 200 and "select count(*) from dba_data_files" currently shows 182. We attempted to create a new tablespace with 13 datafiles and received an ora-00059: maximum number of datafiles exceeded.

Not much of a surprise. We changed db_files to 300, bounced the database, confirmed the db_files parameter was at 300 and attempted to create the new tablespace. We still received the ora-00059. We increased the db_files to 500, but we are still getting an error.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center