troubleshooting Question

Oracle 11.1.0.7 Upgrade to 11.2.0.3

Avatar of AshleySPM
AshleySPMFlag for United States of America asked on
Oracle Database
9 Comments1 Solution1225 ViewsLast Modified:
Hello,

I am testing an Oracle database upgrade. My current version is 11.1.0.7 and I am going to 11.2.0.3. I would like to move it to a new virtual server instead of an in place upgrade. I am trying the export/import method using the following commands:

expdp scott/tiger@oracle11.1.0.7 directory=DIR_DATAPUMP full=y dumpfile=dumpfile.dmp logfile=dumpfile.log encryption=ALL encryption_password=tiger


impdp scott/tiger@oracle11.2.0.3 directory=data_pump_dir full=y dumpfile=dumpfile.dmp logfile=impdp.log encryption_password=tiger


The export works fine. The import just repeats the command over and over in a command prompt but doesnt seem to do anything. Any suggestions?


Thank you,

Ashley
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros