Re: imp hangs then ora-3113 error

richie,

You are incorrect. Morgan has been a jerk since I have been monitoring this NG and it seems the little darling can not help itself.

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.
Received on Mon Jun 16 2003 - 20:46:18 CDT