Received: (qmail 22137 invoked from network); 30 Nov 2011 14:59:58 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.ip-pool.com with SMTP; 30 Nov 2011 14:59:52 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 47405E63BA1; Wed, 30 Nov 2011 15:59:51 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1322686791; bh=tDXILpQjZPcKqUtwrrOpEf6Q/c90C697799Atl1Y fpM=; h=From:To:CC:Subject:Date:Message-ID:References:In-Reply-To: Content-type:Content-Transfer-Encoding:MIME-Version:Sender: Reply-To:List-help:List-unsubscribe:List-Id:List-subscribe: List-owner:List-post:List-archive; b=XJwZfNfHMpQiezu8gPd5juwSYTeCc Q5qmJCA3IXqvXdPipcchERrwxBwhD2BJCt93MSarkmq8K1C1fOx/ar3ppIwW/YilQcb +CUdz2DMZmSdE4AS/FaAJbDcCcIuccnJCy7yhVUwUALv91AtqVSWU831ciKLHVd0AuT aUpMuVyY= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ZhZeojEgRpaB; Wed, 30 Nov 2011 15:59:50 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 038A5E63A5C; Wed, 30 Nov 2011 15:59:06 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 30 Nov 2011 15:58:24 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4000EE63A4E for ; Wed, 30 Nov 2011 15:58:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id vML082egA1WO for ; Wed, 30 Nov 2011 15:58:24 -0500 (EST) Received: from pacdcimo01.cable.comcast.com (PacdcIMO01.cable.comcast.com [24.40.8.145]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C9E46E63A10 for ; Wed, 30 Nov 2011 15:58:22 -0500 (EST) Received: from ([147.191.124.12]) by pacdcimo01.cable.comcast.com with ESMTP id 5503620.147265453; Wed, 30 Nov 2011 15:58:20 -0500 Received: from COPDCEXMB08.cable.comcast.com ([fe80::3011:502:d530:7d25]) by copdcexhub01.cable.comcast.com ([fe80::22:42f7:39c7:1328%10]) with mapi id 14.01.0339.001; Wed, 30 Nov 2011 13:58:20 -0700 From: "Walker, Jed S" To: "Freek.DHooge@uptime.be" , "niall.litchfield@gmail.com" , "stmontgo@gmail.com" CC: "oracle-l@freelists.org" Subject: RE: Migrate users from 10-11 Thread-Topic: Migrate users from 10-11 Date: Wed, 30 Nov 2011 20:58:19 +0000 Message-ID: References: <4814386347E41145AAE79139EAA398981939EB8592@ws03-exch07.iconos.be> In-Reply-To: <4814386347E41145AAE79139EAA398981939EB8592@ws03-exch07.iconos.be> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [165.137.32.103] Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 X-archive-position: 40413 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Jed_Walker@cable.comcast.com Precedence: normal Reply-To: Jed_Walker@cable.comcast.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of D'Hooge Freek Sent: Wednesday, November 30, 2011 8:55 AM To: niall.litchfield@gmail.com; stmontgo@gmail.com Cc: oracle-l@freelists.org Subject: RE: Migrate users from 10-11 Niall, 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 Uptime Oracle Database Administrator email: freek.dhooge@uptime.be tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Niall Litchfield Sent: woensdag 30 november 2011 16:48 To: stmontgo@gmail.com Cc: oracle-l@freelists.org 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 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-l