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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
