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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Serious import problem (help!)

Re: Serious import problem (help!)

From: Jared Still <jkstill_at_cybcon.com>
Date: Fri, 26 Apr 2002 06:38:31 -0800
Message-ID: <F001.0045081E.20020426063831@fatcity.com>

 

Error: ORA 3125
Text: client-server protocol violation



Cause: The application received a bad escape sequence from the server which

        may indicate a problem with the client application user code. Action: Contact your customer support representative.

Since the client application code is Oracle's, you may need to open a TAR for this.

ORA-1461: Could be bug #1304674

INTERMITTANT ORA-1461 ON OCISTMTEXECUTE() WHEN REBINDING ONLY LONG RAW COLUMN

Jared

On Thursday 25 April 2002 12:32, Conrad, Ben wrote:
> Folks,
>
> I've been exporting data from the production db's every night for over a
> year. We use these exports to import into the test db's that we have setup
> in the office. Well, starting yesterday I am no longer able to import
> successfully into any of our 8.1.6 instances.
>
> The exp/imp are being done with the same version (Export file created by
> EXPORT:V08.01.06 via conventional path, Import: Release 8.1.6.0.0 -
> Production on Thu Apr 25 14:19:59 2000) and we have not upgraded Oracle
> (production or test) ever since it's been installed. Our exp files are
> around 5GB (on NTFS filesystem) when exported, I then gzip (switching to
> bzip2 soon) the files and ftp them off for unzipping and importing into
> another 8.1.6 w2k server. The thing that dazzles me is that nothing has
> changed except that we moved into a new office (new IP address space) this
> week. Were using WINS to resolve machine names (eg oradb2) and that's
> working fine (always has).
>
> 75% of the tables in Schema A load up fine, the other 25% in Schema A are
> random but seem to be breaking on the largest tables.
>
> These are the import errors I get on multiple instances and different DB
> machines, very strange.
>
> imp.exe system/%pass%@%dbname% FILE=%dmpfile% BUFFER=20000000 COMMIT=Y
> LOG=import.log IGNORE=Y FROMUSER=%owners% TOUSER=%owners%
>
> . . importing table "CUSTOMER"
> IMP-00058: ORACLE error 3125 encountered
> ORA-03125: client-server protocol violation
> IMP-00018: partial import of previous table completed: 3718 rows imported
>
>
> . . importing table "ACCOUNT"
> IMP-00058: ORACLE error 1461 encountered
> ORA-01461: can bind a LONG value only for insert into a LONG column
> IMP-00018: partial import of previous table completed: 212793 rows imported
>
>
> . . importing table "AGING_LDC_TMP"
> IMP-00058: ORACLE error 3106 encountered
> ORA-03106: fatal two-task communication protocol error
> IMP-00018: partial import of previous table completed: 264180 rows imported
>
>
> . . importing table "BATCH_LOG"
> IMP-00058: ORACLE error 1461 encountered
> ORA-01461: can bind a LONG value only for insert into a LONG column
> IMP-00018: partial import of previous table completed: 723328 rows imported
>
>
> Any help would be appreciated!
>
> Ben.
>
>
>
> This e-mail communication and any attachments are confidential and
> intended only for the use of the designated recipients named above. If you
> are not the intended recipient, you are hereby notified that you have
> received this communication in error and that any review, disclosure,
> dissemination, or distribution of it or its contents is prohibited. If you
> have received this communication in error, please notify USPowerSolutions
> Corporation immediately by telephone at (617)547-3800 or via e-mail at
> ops_at_uspowersolutions.com and destroy all copies of this communication and
> any attachments.


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Apr 26 2002 - 09:38:31 CDT

Original text of this message

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