Last 19c upgrade issue. Working on our new 19c database, several things died off with errors like this:
SQL> execute DBMS_STATS.CREATE_STAT_TABLE ('MYSCHEMA','MYSTATTAB','MYTS');
BEGIN DBMS_STATS.CREATE_STAT_TABLE ('MYSCHEMA','MYSTATTAB','MYTS'); END;
*
ERROR at line 1:
ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
ORA-06512: at "SYS.DBMS_STATS", line 20827
ORA-06512: at "SYS.DBMS_STATS", line 20770
ORA-06512: at "SYS.DBMS_STATS", line 20765
ORA-06512: at line 1Our tablespaces had small uniform extents and our 19c database had defaulted the parameter db_securefile to PREFERRED. We bumped our uniform extent sizes up to 1 megabyte and the problem went away. Setting db_securefile to PERMITTED also resolved the issue.
Oracle’s support site has a bunch of good information about this. This might be a relevant bug:
Bug 9477178 : ORA-60019: CREATING INITIAL EXTENT OF SIZE X IN TABLESPACE FOR SECUREFILES
Bobby
True, but not really a 19c issue per se. We switched to preferred in 12.1 🙂
Thanks Connor. That sounds familiar. I probably learned that when I did the 12.1 certification but it really hasn’t mattered to us until this upgrade.
Hi Bobby. First, thanks for posting this. We just upgraded to 19c and are encountering ORA-60019 when utilizing the dbms_obfuscation_toolkit.md5 function. Interestingly, altering the session to set db_securefile to “PERMITTED” does not resolve our issue.
When you say you “bumped our uniform extent sizes up to 1 megabyte”, what exactly do you mean? Did you create a new tablespace, or alter the existing tablespace? If the latter, which value did you increase – MIN_EXTLEN?
Thanks, Dan
Sorry that I did not notice this comment sooner. I dropped and recreated the tablespaces with 1 megabyte uniform extents.
Bobby