Remote password after remap_schema data pump parameter

From: Joel Patterson <parologist_at_yahoo.com>
Date: Wed, 18 Mar 2015 20:04:09 -0400
Message-ID: <003601d061d8$3b099ba0$b11cd2e0$_at_yahoo.com>



Oracle 11.2.0.4 but appears to be any version.  

Create account1 identified by password;

Expdp account1 as SYS,

Impdp remap_schema account1:account2  

Connections can be made locally (on the unix box) with or without the listener to account2 with the same password as account1, (and of course also to account1).

Also connections can be made if environment is set to another database but same oracle version -- locally from the unix box to both accounts with the same password with or without using the listener.  

However if the environment is set to an oracle 10g database, or if trying to log in remotely (in this case from oracle client 11.1.0.x), and Oracle error 1017 invalid username or password is produced trying to log into account2. Account1 login remotely is no problem of course.  

Anyone run into this? We thought it might be a Hash Value issue, but the Hash values of the passwords are identical. There is something about logging in remotely using the listener only that produces and invalid password 1017 error - not when logging in locally?    

Joel Patterson

parologist_at_yahoo.com <mailto:parologist_at_yahoo.com>

407 760-3151  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 19 2015 - 01:04:09 CET

Original text of this message