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.
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"
1) is the database running
2) is the listener running
3) can you connect
4) can you connect "as sysdba"
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
exp userid=user/pass file=c:\dump.dmp log=c:\log_file.log full=y
ASKER
this is the log file
log.log
log.log
SQLNET.AUTHENTICATION_SERV ICES = (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).
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).
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.
LD_LIBRARY_PATH and LIBPATH are environment variables.
In windows - find them in Registry
In Unix - in profile of the Oracle user.
ASKER
i drop two user in database CTXSYS and DBMX and the export was ok!!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.