Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE

On Fri, 02 Apr 2004 15:54:49 GMT, Hans Forbrich <forbrich_at_yahoo.net> wrote:

>Kalvin wrote - and wrote, and wrote, unnecessarily to several different
>Oracle newsgroups:
>
>> Hi,
>>
>
>> Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
>...
>> . exporting cluster definitions
>>
>> EXP-00056: ORACLE error 1403 encountered
>>
>> ORA-01403: no data found
>
>(I'm sure you are aware that ORA-01403 is simply an empty result set. Just
>a surprise that exp loudly complains about this.)
>
>More symptoms please .... does it terminate there or continue?
>
>I have not run into this. From basic troubleshooting, a few things to
>check:
>
>-I didn't see the exp header, just the connect to database header. Is it
>possible that the exp version does not match the database? (IOW, do you
>have multiple DB versions on the machine?)
>-During install, were there any obvious errors, especially during building
>the catalog?
>-Anything in the Alert.log?
>-In the background dump directory?
>
>Do you have another 9.2.0.4 server machine elsewhere, possibly on a
>different OS? If yes, could you try exp across the net to this DB ...
>(quick way of checking whether you have a problem with exp or catalog)
>
>/Hans

Ran into *exactly* the same problem today and have a few answers for your questions.

1 It continues
2 In my case: 9.2.0.3 database server here and 9.0.1 client 3 The system was installed by Oracle India 4 There is nothing in the alert log.
5 There is nothing obvious in the background dump dest

I didn't resolve this problem yet, I got too fed up with this installation to continue.
I was also facing exp-0079 and exp-0091 and initially didn't even see above error.

--
Sybrand Bakker, Senior Oracle DBA