Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: imp hangs then ora-3113 error

Re: imp hangs then ora-3113 error

From: richie <richchri_at_erols.com>
Date: 16 Jun 2003 14:51:31 -0700
Message-ID: <9a436674.0306161351.666ef182@posting.google.com>


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 - 16:51:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US