Link to home
Start Free TrialLog in
Avatar of AlbIT
AlbIT

asked on

database export

in my oracle 10g XE, when i try to export the database seems that the export doesn't look to be completed. the web interface of the Oracle 10g XE doesn't work too.
Avatar of schwertner
schwertner
Flag of Antarctica image

Define a log file and see there for error messages.
well..  that's 2 questions..  let's start with the first one.
   1)  is the database running
   2)  is the listener running
   3)  can you connect
   4)  can you connect "as sysdba"
Avatar of AlbIT
AlbIT

ASKER

ok the database is running and the listener too. I could connect as user and  as sysdba too.
now, do what schwertner says above

exp userid=user/pass file=c:\dump.dmp log=c:\log_file.log full=y
Avatar of AlbIT

ASKER

this is the log file
log.log
SQLNET.AUTHENTICATION_SERVICES = (NONE)


Also
http://oradbatips.blogspot.com/2008/01/tip-69-export-hangs-shutdown-immediate.html

All of the next runs of exp and expdp hung same as before bounce.
Eventually, I found that problem was because of improper setting of LD_LIBRARY_PATH and LIBPATH.This parameter needs to be set to point to $ORACLE_HOME/lib in 10g as first reference. Setting those parameter properly fixed the situation including shutdown problem and exp/expdp problem. (For more info, please refer to metalink note : 351650.1).
Avatar of AlbIT

ASKER

how can be set these parameters properly to fix it?
The first is in sqlnet.ora file.

LD_LIBRARY_PATH and LIBPATH are environment variables.
In windows - find them in Registry
In Unix - in profile of the Oracle user.
Avatar of AlbIT

ASKER

i drop two user in database CTXSYS and DBMX and the export was ok!!!!
ASKER CERTIFIED SOLUTION
Avatar of ee_auto
ee_auto

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial