Error Import DMP 10.2.0 - 11.2.0 XE

[rafasnn]

I need a help, I have a Dell 2950 running 100% with CentOS 6.4 only for Oracle Xe 10.2.0, for physical questions I will need to migrate our BD to another dedicated machine A Dell 1950, well installed Centos 6.4 and Oracle 11.2.0 Xe, apparently is turning beleza, but I can not import the DMP at all.

Select all

 
[root@oracle home]# imp soma/soma file=arcom02092013.dmp 
 
Import: Release 11.2.0.2.0 - Production on Tue Sep 3 10:54:17 2013 
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. 
 
 
IMP-00058: ORACLE error 1017 encountered 
ORA-01017: invalid username/password; logon deniedUsername: 

I created the user "Soma" in Oracle, I can connect to the bank with that user without problems.

Is it possible to import a DMP between different versions of Oracle?

[fbifabio]

In the old import / export, also known as conventional do not know if it is possible (I believe yes), but in the Export / Import via DataPump is possible. If you generate a dump in 10g and try to import in 11g, you have to provide value for an additional parameter called version, which in this case could be version = 10.2.0

ok?

[rafasnn]

Fabiano,

grateful for return, I tried the parameter he mentioned but gave error:

Select all

 
[root@oracle home]# imp soma/Sistemaerp1! file=arcom02092013.dmp VERSION=10.2.0 
LRM-00101: unknown parameter name 'VERSION' 
 
IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help 
IMP-00000: Import terminated unsuccessfully 

[fbifabio]

I have informed that the parameter can be used in Export / Import via DataPump and did not know how to do it in the conventional! Why do not you use EXPDP / IMPDP?

[rafasnn]

I have no idea how to do this, at 10.2.0 exp / imp works 100%.

[fbifabio]

Read http://www.profissionaloracle.com.br/gp ... -aplicacao

[] S

[stcoutinho]

RafaSnn,

If you do not have USASR the EXPDP and IMPDP, you can follow this steps:

1) Run - with Oracle Client 10g - A Export of the Schema "Soma" in the 10G base of origin;
2) Run - with Oracle Client 11g - An IMPORT OF SCHEMA "SOMA" in the 11G destination base;
3) CAUTION 1: You need to make sure you have the "Sum" user in the destination base, and that this user has the same permissions that you have in the source base.
4) CAUTION 2: Be careful with Schema tables "Soma" that have never been populated in the source base. You need to manually allocate a segment in these empty tables so that they are related to Oracle Export. Perhaps this is a problem related to 11G, but by doubts, ensure that even empty tables have a "extent" allocated;
5) CAUTION 3: I noticed that it is running the imp soma/soma file=... command Why do not you configure your tnsnames.ora from your machine with 11g and try to run the command informing the service name? Try to create a "base_11g.world" name service in tnsnames.ora, test the connection by informing this service sqlplus soma/soma@base_11g and finally rewrites the command command (eg add sum / sum @ base_11g file = ... . ");

Hugs and good luck,

Sergio Coutinho