Remote password after remap_schema data pump parameter

From: "Joel Patterson" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "parologist@xxxxxxxxx" for DMARC)
To: <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 18 Mar 2015 20:04:09 -0400

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@xxxxxxxxx <mailto:parologist@xxxxxxxxx> 

407 760-3151

Remote password after remap_schema data pump parameter

Other related posts: