RE: Migrate users from 10-11
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
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of D'Hooge Freek Sent: Wednesday, November 30, 2011 8:55 AM To: niall.litchfield_at_gmail.com; stmontgo_at_gmail.com Cc: oracle-l_at_freelists.org
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.
Oracle Database Administrator
tel +32(0)3 451 23 82
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: woensdag 30 november 2011 16:48
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_at_gmail.com>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 http://www.orawin.info -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 30 2011 - 14:58:19 CST