RE: Migrate users from 10-11

  • From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
  • To: "Freek.DHooge@xxxxxxxxx" <Freek.DHooge@xxxxxxxxx>, "niall.litchfield@xxxxxxxxx" <niall.litchfield@xxxxxxxxx>, "stmontgo@xxxxxxxxx" <stmontgo@xxxxxxxxx>
  • Date: Wed, 30 Nov 2011 20:58:19 +0000

We have had no problems with passwords not working going between 10 and 11; 
however, if you the client is still using 10g then you need to disable case 
sensitive passwords

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of D'Hooge Freek
Sent: Wednesday, November 30, 2011 8:55 AM
To: niall.litchfield@xxxxxxxxx; stmontgo@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Migrate users from 10-11


It is true that the hash changed in 11 (with case sensitive passwords now), but 
the old hashes are still accepted.
I think there is even a flag that tells you if this the password is using the 
old or the new method.

Kind regards,

Freek D'Hooge
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Niall Litchfield
Sent: woensdag 30 november 2011 16:48
To: stmontgo@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Migrate users from 10-11

The password hash changes in 11! Why didn't you just allow datapump to create 
the users (or whisper it not in Gath) just perform a database upgrade?
On Wed, Nov 30, 2011 at 3:11 PM, steve montgomerie <stmontgo@xxxxxxxxx>wrote:

> Greetings Oracle List!
> We're moving an Oracle Database to a new Server upgrading from 10 to
> 11 with Datapump. Can we migrate the schema's without knowing/changing 
> the passwords?

Niall Litchfield
Oracle DBA




Other related posts: