Mega Search
23.2 Million


Sign Up

Make a donation  
EXP-00056: ORACLE error 1403 encountered HELP PLEASE  
News Group: comp.databases.oracle.server

Hi,

Problems start the export:
Linux version 2.4.9-e.3 (bhcompile@stripples.devel.redhat.com) (gcc version
2.96 20000731 (Red Hat Linux 7.2 2.96-108.1)) #1 Fri May 3 17:02:43 EDT 2002

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export the entire database ...

.. exporting tablespace definitions

.. exporting profiles

.. exporting user definitions

.. exporting roles

.. exporting resource costs

.. exporting rollback segment definitions

.. exporting database links

.. exporting sequence numbers

.. exporting directory aliases

.. exporting context namespaces

.. exporting foreign function library names

.. exporting PUBLIC type synonyms

.. exporting private type synonyms

.. exporting object type definitions

.. exporting system procedural objects and actions

.. exporting pre-schema procedural objects and actions

.. exporting cluster definitions

EXP-00056: ORACLE error 1403 encountered

ORA-01403: no data found

EXP-00056: ORACLE error 1403 encountered



Scan Metalink not found upper error, please English.



Atte.






Vote for best question.
Score: 0  # Vote:  0
Date Posted: 2-Apr-2004, at 11:26 AM EST
From: kalvin
 
Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE  
News Group: comp.databases.oracle.server
On Fri, 02 Apr 2004 20:02:06 GMT, Hans Forbrich 
wrote:

>Don't quite get this part - you have a separate 9.0.1 client, or the 9.0.1
>client from the Infrastruture is taking precedence?
>

Probably the latter. Didn't look at PATH or anything. When you fire up
sql*plus you get the 9.0.1 executable.



>And, knowing your skill set, you've checked the connectivity to the 9.2.0.3
>using both the 9.0.1 and and the 9.2.0.3 SQLPlus executables - which of
>course, in Windows, implies the correct ORACLE_HOME since the selecting the
>binary with a full OH/bin path automatically decides the OH.

Didn't do that yet.
We are talking politics here.
Officially we don't maintain this system yet. Prior to taking it into
maintenance, as we didn't design it, and we weren't involved into any
of it's architecture, knowing it was architected against the
guidelines in the Oracle 9iAS documentation, by Oracle, we would
execute a formal 'intake' procedure first.

Yet the customer requested urgently the RMAN backup to be configured.
Then I hit the issue both databases were running in NOARCHIVELOG
Then I hit the issue NLS_LANG wasn't properly set.
Then I hit the issue I couldn't export because of exp-0079 and
exp-0091.
At that point I decided to try to resolve the exp-0079 and exp-0091
because they had no backup at all.

I decided not to go into troubleshooting, as my firm doesn't get paid
for any activity on that system yet, and the RMAN configuration
(backup to disk) clearly couldn't be completed in the projected number
of hours.
As far as we are concerned either the customer or Oracle is going to
pay for this.

Regards


--
Sybrand Bakker, Senior Oracle DBA

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 3-Apr-2004, at 12:56 AM EST
From: Sybrand Bakker
 
Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE  
News Group: comp.databases.oracle.server
Sybrand Bakker wrote:

> Answers embedded
> 
> On Fri, 02 Apr 2004 17:28:35 GMT, Hans Forbrich 
> wrote:
> 
>>Since it happens (for the OP) at the Cluster section, I'd suggest checking
>>whether there are any clusters.  If not, there is probably not a problem
>>(just another example of deteriorating QA tests cases).  I hear your
>>comment already & agree - it still needs to be verified.
>>
>>> 2 In my case: 9.2.0.3 database server here and 9.0.1 client
>>
>>Intrigued by the 9.0.1 client part.  Are you saying you are using a 9.0.1
>>client for the connection betw. exp and server?  Or a 9.0.1 exp client?
> 
> Guess a full 9.0.1 client; 2 databases here and Oracle 9ias
> Infrastructure.
> When I fire up sqlplus it shows a 9.0.1 banner
> IIRC 9.0.1 is desupported, isn't it

Let's see if I understand this ......

You have a couple of 9.2.0.3 'live' instances and a 9.0.1.x 'infrastructure'
instance ('cause that's the only version of infra database instance
allowed).  Which should be in separate ORACLE_HOMEs and are hopefully full,
and not customized (bastardized), installs, therefore providing two
versions of the exp command.

Probably on a Wintel box ('cause of the McAfee/Norton AV statement).

Don't quite get this part - you have a separate 9.0.1 client, or the 9.0.1
client from the Infrastruture is taking precedence?

And, knowing your skill set, you've checked the connectivity to the 9.2.0.3
using both the 9.0.1 and and the 9.2.0.3 SQLPlus executables - which of
course, in Windows, implies the correct ORACLE_HOME since the selecting the
binary with a full OH/bin path automatically decides the OH.

And there are no clusters.  (Except, of course, SYS owns at least 6 cluster
objs such as C_COBJ#, C_OBJ#, C_TS# ... )

And the ORA-1403 and EXP-00056 are happening consistently from both the 9.2
and 9.0 exp executables?

And (you could not know this) my full exp of a 9.2.0.1 test database, using
both a 9.0.1.3 and 9.2.0.1 exp executables, cleanly passes the cluster
def'n export both times.

Then I'd guess you either have corrupt executables (unlikely) or a corrupt
catalog.

But that's just a guess.
/Hans

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 2-Apr-2004, at 8:02 PM EST
From: Hans Forbrich
 
Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE  
News Group: comp.databases.oracle.server
Answers embedded

On Fri, 02 Apr 2004 17:28:35 GMT, Hans Forbrich 
wrote:

>Since it happens (for the OP) at the Cluster section, I'd suggest checking
>whether there are any clusters.  If not, there is probably not a problem
>(just another example of deteriorating QA tests cases).  I hear your
>comment already & agree - it still needs to be verified.
>
>> 2 In my case: 9.2.0.3 database server here and 9.0.1 client
>
>Intrigued by the 9.0.1 client part.  Are you saying you are using a 9.0.1
>client for the connection betw. exp and server?  Or a 9.0.1 exp client?

Guess a full 9.0.1 client; 2 databases here and Oracle 9ias
Infrastructure.
When I fire up sqlplus it shows a 9.0.1 banner
IIRC 9.0.1 is desupported, isn't it
>
>Original suggestion still stands - can you do a remote exp from a different
>exp (pref. different OS) and still get the same error?

I can't do that, because the system is not in our network. Can take
over the server with Dameware, but that is all there is to it.

>
>> 3 The system was installed by Oracle India
>
>a) Not going there!!!

Oracle Netherlands outsourced development to Oracle India, because
that was cheaper

>b) Wonder if catalog/catexp ran OK?

Who can tell? There is no documentation whatsoever, and the server was
thrown over the fence.
We already now there is McAfee AND Norton Antivirus on the server.
>
>> 4 There is nothing in the alert log.
>> 5 There is nothing obvious in the background dump dest
>
>All the more reason to believe this is just a stoopid unsuppressed message.
>
>> 
>> 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.
>
>Ouch.

Regards


--
Sybrand Bakker, Senior Oracle DBA

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 2-Apr-2004, at 9:19 PM EST
From: Sybrand Bakker
 
Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE  
News Group: comp.databases.oracle.server
Sybrand Bakker wrote:

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

Since it happens (for the OP) at the Cluster section, I'd suggest checking
whether there are any clusters.  If not, there is probably not a problem
(just another example of deteriorating QA tests cases).  I hear your
comment already & agree - it still needs to be verified.

> 2 In my case: 9.2.0.3 database server here and 9.0.1 client

Intrigued by the 9.0.1 client part.  Are you saying you are using a 9.0.1
client for the connection betw. exp and server?  Or a 9.0.1 exp client?

Original suggestion still stands - can you do a remote exp from a different
exp (pref. different OS) and still get the same error?

> 3 The system was installed by Oracle India

a) Not going there!!!
b) Wonder if catalog/catexp ran OK?

> 4 There is nothing in the alert log.
> 5 There is nothing obvious in the background dump dest

All the more reason to believe this is just a stoopid unsuppressed message.

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

Ouch.

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 2-Apr-2004, at 5:28 PM EST
From: Hans Forbrich
 
Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE  
News Group: comp.databases.oracle.server
On Fri, 02 Apr 2004 15:54:49 GMT, Hans Forbrich 
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

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 2-Apr-2004, at 7:15 PM EST
From: Sybrand Bakker
 
Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE  
News Group: comp.databases.oracle.server
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

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 2-Apr-2004, at 3:54 PM EST
From: Hans Forbrich