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