Re: imp hangs then ora-3113 error

For all that care:

   to get around this i lowered the shared_pool_size in the orainit file freeing up more free ram to other processies (which i guess oracle couldn't then spwan off hence the ora-03113 error). what bothers me is that this database was up and running with no problem for months. it's strickly backup storage. we do not develope on it, no processies use it. so it's not like the ram usage requirements went up in the last few months. now with oracle you allocate the fixed amount of ram it can eat up, is this not correct? so it shouldn't of been trying to use anymore ram then was already allocated for it?

richchri_at_erols.com (richie) wrote in message news:<9a436674.0306160618.3203e5d1_at_posting.google.com>...
> Every now and then I have this problem where i can't import anything
> any longer into the database. It will just hang at the same spot.
> Then eventually come back with an error shown below. In the past
> restarting the database would clear up the issue and the import would
> work. However, restarting the database doesn't appear to help
> anylonger. There are no errors in the alert<sid>.log or any other log
> that I can find. Any help would be greatly appreciated as this issue
> is really starting to get on my nerves! Thanks in advance for your
> help.
>
>
> . . importing table "ACCESS_FLAGS"
> 4 rows
> imported
> . . importing table "BILL_DETAIL_MAP"
> 40 rows
> imported
> . . importing table "BILL_SECTIONS"
> 7 rows
> imported
> . . importing table "BROWSER_OPTIONS"
> 9 rows
> imported
> . . importing table "BUTTON_WEIGHT"
> 30 rows
> imported
> . . importing table "CALL_RECORDS_200305_1"
> IMP-00058: ORACLE error 3113 encountered
> ORA-03113: end-of-file on communication channel
> IMP-00058: ORACLE error 3114 encountered
> ORA-03114: not connected to ORACLE
> IMP-00000: Import terminated unsuccessfully
Received on Wed Jun 18 2003 - 12:05:05 CDT