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'
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.