Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle database export problem (RAC)

rana786
Regular Advisor

Oracle database export problem (RAC)

Error on cluster node while exporting schema on database:
[blbill01]oracle:/orabin/appl/oracle/product/9.2.0>sh exptabs.sh

Export: Release 9.2.0.6.0 - Production on Thu Jan 19 19:06:19 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TABS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TABS
About to export TABS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions ……….it’s stuck here

Please help.
Walker_dhk
3 REPLIES
Steven E. Protter
Exalted Contributor

Re: Oracle database export problem (RAC)

Shalom,

What do the alert logs say?

Consider shutting down the database and restarting it and then trying the export. It may not want to come down. shutdown abort may be needed.

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
Victor Fridyev
Honored Contributor

Re: Oracle database export problem (RAC)

Hi,

Please check permissions of the directory where you put export file. The directory must be writable for the user, which creates export. Also check whether the export file does not exist before the export.

HTH
Entities are not to be multiplied beyond necessity - RTFM
rana786
Regular Advisor

Re: Oracle database export problem (RAC)

its ok.
Walker_dhk