Oracle export error

[Adrian Sobers2]

Yes this used to work before, it stopped only after I applied the April 2006 CPU patch update...

I checked the date, and also did the relinking of the exp whilst trouble-shooting with Oracle Rep. and that didn't solve the problem.

[Patti Johnson]

Any invalid objects? Possibly the ones for export/import. Have they suggested backing out the patch?
I'd consider running $O_H/rdbms/admin/catexp to recreate the export objects.

Patti

[Adrian Sobers2]

Patti,

Backing out of the patch didn't help at all.

I will try running the script you recommended.

[Adrian Sobers2]

Patti,

Running that script didn't help either.

Isn't there something wrong on the HP-UX OS side since the error involves, a Bus error (core dump)?

[Patti Johnson]

Do you get any messages from export before the Bus error ? Does it produce a core file - have you tried to ananlyze the core file?
What about other tools - sqlplus, imp ? can these tools run?
Did any of you environment variables change?
Also have you tried direct=y for the export.

[TwoProc]

Since you're on an unsupported version (and you're not going to get any help from Oracle on this) - try running the export from another ORACLE_HOME. Maybe on another HPUX, Linux or Windoze box hooked to that database via sqlnet. It could be that you can export just the troublesome sections from a remote connection - or, even the whole thing if need be.

[Adrian Sobers2]

Patti,

All of the other utilities run fine, except the export.

Oracle is analyzing the core dump.

I will try the remote connection export thingy ;)

[TwoProc]

Wow Adrian, I'm absolutely amazed that they are helping you on a version that is no longer supported. Cool though!