1748274 Members
4369 Online
108761 Solutions
New Discussion юеВ

Re: Oracle export error

 
Adrian Sobers2
Super Advisor

Oracle export error

Whenever I try to run the export utility on Oracle (8.1.7.4, HP-UX 11.11) I get the following error:

Export: Release 8.1.7.4.0 - Production on Thu Jul 20 11:02:47 2006

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Productionexport_base.sh[14]: 27333 Bus error(coredump)
oracle:PRODUCTION>

Any ideas as to what might be causing this?
17 REPLIES 17
Steven E. Protter
Exalted Contributor

Re: Oracle export error

Shalom,

Missing oracle patch can cause it.

Missing OS patch can cause it.

http://www.google.com/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Farchives.neohapsis.com%2Farchives%2Fhp%2F2000-q4%2F0089.html&ei=JY-_RI2GE5_M2wLvy9nJCQ&sig2=r6kWk9WubFINSMpaWf_-2A

Most likely you need a patch dealing with the export utility.

Since java is involved, make sure that is patched and is a supported version from oracles standpoint.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Adrian Sobers2
Super Advisor

Re: Oracle export error

All of the latest OS and DB patches have been applied. Is there a specific patch for java or something for HP-UX that I need?

Peter Godron
Honored Contributor

Re: Oracle export error

I support Steven analysis, but could you please also post the code for export_base.sh ?
Adrian Sobers2
Super Advisor

Re: Oracle export error

#!/usr/bin/ksh
#==============================================================================#

SID=IRDS
JOUR=`date '+%d%m'`

# remove the previous export..
rm /opt/oracle/data/Exports/${SID}????.dmp

# this is for a FULL DATABASE export
#exp userid=system/manager full=y file=/opt/oracle/data/Exports/${SID}${JOUR}.dmp log=/opt/oracle/data/Exports/${SID}.log

# this is for a schema level export for the IRDS database
exp userid=ird/ird2006ADm owner=ird file=/opt/oracle/data/Exports/${SID}${JOUR}.dmp log=/opt/oracle/data/Exports/${SID}.log

Patti Johnson
Respected Contributor

Re: Oracle export error

Adrian,

Anything in the alert.log (ora-7445 perhaps). Also does it fail when you try and export only one table? Another schema?

Local or remote db that you are exporting from?

Patti
Adrian Sobers2
Super Advisor

Re: Oracle export error

Patti,

Nothing in those files at all.

It fails when I try to export another schema, table level only etc. I've been through all of that with an Oracle rep. They are still 'researching' the problem. I just wondered if anyone had come across this error before.
Peter Godron
Honored Contributor

Re: Oracle export error

Adrian,
can you check the dates on the files in $ORACLE_HOME/bin . Could somebody have slipped in a different version of exp?
Patti Johnson
Respected Contributor

Re: Oracle export error

Guessing this worked before. Have you tried to relink the exp binary?
TwoProc
Honored Contributor

Re: Oracle export error

I think I saw this back then when two objects of different types had the same name. I believe the conflict was between table names and trigger names.

Do you have triggers that have the same name as tables? If so, change the trigger name, and retry.

to locate candidates for further review:

select object_name,count(*)
from dba_objects
group by object_name
having count(*) >1;

check what comes out of here, and see if there are triggers with the same name of tables.
We are the people our parents warned us about --Jimmy Buffett