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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In