Home » RDBMS Server » Server Administration » when resizing SQL database i get error ORA-03113
when resizing SQL database i get error ORA-03113 [message #196006] Tue, 03 October 2006 11:29 Go to next message
ghetto1
Messages: 2
Registered: October 2006
Location: canada
Junior Member
When i 1st resized the database from default to 20G i got error ORA-03113. But when i resize it +-4G then there is no errors. If anyone came accross this b4 and know's how to solve it, please enlighten me, thx. Joe.


SQL>ALTER DATABASE DATAFILE
2 '/u01/app/oracle/oradata/TSH1/users01.dbf'
3 resize 20G ;
~ the result is~
ALTER DATABASE DATAFILE
*
ERROR at line 1;
ORA-03113; end-of-file on communication channel
Re: when resizing SQL database i get error ORA-03113 [message #196007 is a reply to message #196006] Tue, 03 October 2006 11:41 Go to previous message
ghetto1
Messages: 2
Registered: October 2006
Location: canada
Junior Member
i comfirmed that when using 2 sticks of 1GB ddr-533 kingston instead of 4 sticks i don't get an error. Im going to keep testing this with different sticks to see if maybe it's a physically damanged memory.
Previous Topic: availability of oracle CPU patch for 3rd quarter 2006
Next Topic: Need Help
Goto Forum:
  


Current Time: Sat Aug 19 19:30:46 CDT 2017

Total time taken to generate the page: 0.17647 seconds