Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

database export

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

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.

Question has a verified solution.

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

Suggested Solutions

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

856 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