Solved

database export

Posted on 2008-10-28
11
477 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 47

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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 47

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 47

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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 information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now