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
*** 05/18/00 08:35 am ***
=========================
PROBLEM:
When running OCI binds with LONG RAW datatypes, if the LONG RAW column
is not the last one in the list, rebinding only the one column causes
ORA-1461 errors intermittantly on OCIStmtExecute().
.
This appears to be a regression from 8.1.5, and 8.0.
.
=========================
DIAGNOSTIC ANALYSIS:
Tested on 8.0.5/6, 8.1.5/6, made code changes to test various methods
Rewrote sections of code to narrow down problem to the rebind. The
application always fails on 3rd insert.
.
=========================
WORKAROUND:
ensure that the LONG RAW column is last
do not issue a rebind
issue a rebind for all of the bind variables
...
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
> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
