Wednesday, 11 April 2012

Oracle Export hangs with: "exporting cluster definitions"

1. Stop the database and the listener.

2. Set LD_LIBRARY_PATH so the first directory referenced is $ORACLE_HOME/lib
Example (replace $ORACLE_HOME with the full path of the Oracle home directory):

csh:

> setenv LD_LIBRARY_PATH=$ORACLE_HOME/lib
> setenv LIBPATH=$ORACLE_HOME/lib

ksh:

> export LD_LIBRARY_PATH=$ORACLE_HOME/lib
> export LIBPATH=$ORACLE_HOME/lib

For Oracle9i and higher on AIX: set environment variable LIBPATH and afterwards, run /usr/sbin/slibclean as root

For Oracle9i and higher on HP-UX, Linux, Solaris, and Tru64: set environment variable LD_LIBRARY_PATH

3. Re-start the database and the listener.

4. Re-run the export.

No comments:

Post a Comment

Number of Visitors