Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: imp hangs then ora-3113 error
richie wrote:
> i posted a few minutes ago with the info i realized i left out. it
> just hasn't appeared on the site yet. you don't have to be a jerk.
> people make mistakes..the kernel parameters are correct as required in
> the install doc.
> don't want your help if you're going to be like that!
>
> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EEDE538.56F28EC0_at_exxesolutions.com>...
> > richie wrote:
> >
> > > 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
> >
> > No hardware and operating system?
> > No version and edition?
> > And you want help?
> >
> > I'll guess. You are running on a UNIX platform and didn't set the
> > appropriate kernel parameters based
> > on the usage and init.ora settings for your database.
> >
> > If I guessed incorrectly next time post enough information for someone to
> > help you.
If pointing out that you didn't include essential information makes me I jerk I plead guilty.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Mon Jun 16 2003 - 18:23:42 CDT