Re: imp hangs then ora-3113 error

oops, sorry....we are running oracle 8.1.6.0.0 on linux redhat advanced server (2.4.9-e.10smp).thanks for the link....i've looked at those issues in the past. the only thing i can think of at this point is it's a memory issue in where some new process can't spwan off. no processies seem to be dieing. there are no defunct or rouge processies. however, the first few tables import with no problem...it's just when it gets to that call _Records table (which is the largest table in the dump...about 4 million rows)....the imp is taking place on the same machine as the oracle instance and the listener are running on and there are no errors in any of the logs (alert, listener, sqlnet). i would hope that if an oracle process that needed to spwan and couldn't because of memory would be written to the a log any log some log but i guess that's asking to much. the machine has dual hyper threaded processors and 2gigs of ram where around 1gig of which appears to be allocated to the shared_pool_size in the orace init file.

thanks again.

"Spark" <markfle_at_yahoo.com> wrote in message news:<3eedd520$0$10627$ed9e5944_at_reading.news.pipex.net>...
> Version and operating system not specified but here goes
>
> http://www.oracle-error.com/ora-03113.htm
>
> hth
>
> Spark
> "richie" <richchri_at_erols.com> 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 Mon Jun 16 2003 - 15:20:44 CDT