Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

database export

Posted on 2008-10-28
11
Medium Priority
?
499 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
10 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month10 days, 20 hours left to enroll

572 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