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

Home -> Community -> Mailing Lists -> Oracle-L -> Help : ORA-29516

Help : ORA-29516

From: Yigal Ran <ydran_at_usa.net>
Date: 13 Oct 00 12:37:37 EDT
Message-Id: <10648.119212@fatcity.com>


I am receiving ORA-29516 during an Oracle export, did any one encounter t= hat
problem, and has a solution.

EXP-00008: ORACLE error 29516 encountered ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187 Uncaught exception Root of all Java exceptions: EXP-00000: Export terminated unsuccessfully

TIA Yigal



Get free email and a permanent address at http://www.amexmail.com/?A=3D1

 From: Jordi Sanmarti <JSanmarti_at_tss.com.pe>  Date: Fri, 13 Oct 2000 12:09:48 -0500
 Subject: BLOB fields and Delphi 5

        Hi,

	I'm trying to load a binary file into a blob field using delphi 5.
	I tried to define a different BlobTypes as : Memo, Blob, Cblob ...
at the delphi side.
	Unfortunatly, I've got an error telling me that the datatypes (at
both sides -> DB and Delphi)
	are incorrect. Apparently, the insert sql process is trying to
convert datatypes but got a problem during the insertion (wrong datatypes Hex and Binary).

        Does anyone knows how can I fix that problem? or Which type of field in Oracle, should I use for images (blob, long raw, raw(x) ...)?

	Thanks in advance,
	Jordi



------------------------------

 From: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk>  Date: Fri, 13 Oct 2000 16:59:55 +0100
 Subject: RE: Shutdown immediate hangs.

Thanks for all the replies. I am looking into all possible causes suggested by the list.

Regards

Lee

> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>

-----Original Message-----
From: Mohammad Rafiq [mailto:rafiq9857_at_hotmail.com] Sent: 13 October 2000 17:52
To: Multiple recipients of list ORACLE-L Subject: Re: Shutdown immediate hangs.

Please check whether any user running any background job(nohup) on database as shutdown immediate is unable to shut down database and wait for that session to complete processing....
Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Fri, 13 Oct 2000 01:10:23 -0800

All,

Last night our backups were not able to kick in as the shutdowns did not work. The trace file shows the following

This goes on for sometime until a shutdown abort is issued. Am i right in assuming that the DB is attempting to rollback active transactions before shutting down or is there something else causing this. I am new at this place and apparently they say this has never happened before.

Anyone seen this ??

Lee

 > Lee Robertson
 > Acxiom
 > Tel: 	0191 525 7344
 > Fax: 	0191 525 7007
 > Email: lerobe_at_acxiom.co.uk
 >
 >


The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lerobe - Lee Robertson
   INET: LEROBE_at_acxiom.co.uk

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).

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.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).


------------------------------

 From: "Mohan, Ross" <Ross.Mohan_at_PictureVision.com>
 Date: Fri, 13 Oct 2000 13:14:34 -0400
 Subject: RE: db file sequential reads

Break out the champagne, amigo!   ( timed_statistics does NOT require an
instance bounce)


SVRMGR> select * from v$version;

BANNER                                                          
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.5.1.0 - Production      
PL/SQL Release 8.1.5.1.0 - Production                           
CORE Version 8.1.3.0.0 - Production                             
TNS for Solaris: Version 8.1.5.0.0 - Production                 
Received on Fri Oct 13 2000 - 11:37:37 CDT

Original text of this message

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