Running 'db-control extend TEMP_TBS' results in the error 'DBD::Oracle::db do failed: ORA-02009: the size specified for a file must not be zero'

Solution Verified - Updated -

Issue

  • I ran the db-control report command to see what it says before trying to change anything, and it gave the following output:
$ db-control report
Tablespace                  Size    Used   Avail   Use%
DATA_TBS                    7.8G    6.6G    1.1G    85%
SYSAUX                      500M  132.9M    367M    27%
SYSTEM                      400M  252.8M  147.1M    63%
Use of uninitialized value in subtraction (-) at /usr/share/perl5/vendor_perl/Dobby/CLI/MiscCommands.pm line 171.
Use of uninitialized value in subtraction (-) at /usr/share/perl5/vendor_perl/Dobby/CLI/MiscCommands.pm line 172.
Use of uninitialized value $n in numeric gt (>) at /usr/share/perl5/vendor_perl/Dobby/CLI/MiscCommands.pm line 139.
Use of uninitialized value $n in concatenation (.) or string at /usr/share/perl5/vendor_perl/Dobby/CLI/MiscCommands.pm line 144.
Use of uninitialized value in division (/) at /usr/share/perl5/vendor_perl/Dobby/CLI/MiscCommands.pm line 173.
Illegal division by zero at /usr/share/perl5/vendor_perl/Dobby/CLI/MiscCommands.pm line 173.
  • I went ahead and tried the extend command anyway and got the following error:
$ db-control extend TEMP_TBS
Use of uninitialized value $bytes in numeric lt (<) at /usr/share/perl5/vendor_perl/Dobby/CLI/MaintCommands.pm line 76.
Extending TEMP_TBS... Use of uninitialized value $bytes in division (/) at /usr/share/perl5/vendor_perl/Dobby/CLI/MaintCommands.pm line 86.
DBD::Oracle::db do failed: ORA-02009: the size specified for a file must not be zero (DBD ERROR: error possibly near <*> indicator at char 82 in 'ALTER TABLESPACE TEMP_TBS ADD TEMPFILE '/rhnsat/data/rhnsat/temp_03.dbf' SIZE 0 K <*>REUSE') [for Statement "ALTER TABLESPACE TEMP_TBS ADD TEMPFILE '/rhnsat/data/rhnsat/temp_03.dbf' SIZE 0 K REUSE"] at /usr/share/perl5/vendor_perl/Dobby/DB.pm line 153.

Environment

  • Red Hat Network Satellite 5.5
  • Embedded Oracle database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content