Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

database export

Posted on 2008-10-28
11
Medium Priority
?
493 Views
Last Modified: 2013-12-19
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.
0
Comment
Question by:AlbIT
  • 4
  • 3
  • 2
  • +1
11 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 22821260
Define a log file and see there for error messages.
0
 
LVL 10

Expert Comment

by:dbmullen
ID: 22822125
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"
0
 

Author Comment

by:AlbIT
ID: 22857031
ok the database is running and the listener too. I could connect as user and  as sysdba too.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 10

Expert Comment

by:dbmullen
ID: 22857589
now, do what schwertner says above

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

Author Comment

by:AlbIT
ID: 22865411
this is the log file
log.log
0
 
LVL 48

Expert Comment

by:schwertner
ID: 22867006
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).
0
 

Author Comment

by:AlbIT
ID: 22874312
how can be set these parameters properly to fix it?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 22875275
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.
0
 

Author Comment

by:AlbIT
ID: 22920459
i drop two user in database CTXSYS and DBMX and the export was ok!!!!
0
 

Accepted Solution

by:
ee_auto earned 0 total points
ID: 23370956
Question PAQ'd, 250 points refunded, and stored in the solution database.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question