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: ORA-01092: ORACLE instance terminated. Disconnection forced
Next Topic: SQL loader for null DATE column
Goto Forum:
  


Current Time: Sat Dec 03 18:34:22 CST 2016

Total time taken to generate the page: 0.05170 seconds