Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 25411 invoked from network); 17 Dec 2007 08:21:55 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 17 Dec 2007 08:21:55 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 12AF87D9A4D; Mon, 17 Dec 2007 09:21:55 -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 09208-06; Mon, 17 Dec 2007 09:21:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 834207D9E0C; Mon, 17 Dec 2007 09:21:54 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 17 Dec 2007 08:34:29 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 03B737D9DCF for ; Mon, 17 Dec 2007 08:34:29 -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 32518-04 for ; Mon, 17 Dec 2007 08:34:28 -0500 (EST) Received: from outbound2-sin-R.bigfish.com (outbound-sin.frontbridge.com [207.46.51.80]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 569C37D9D74 for ; Mon, 17 Dec 2007 08:34:28 -0500 (EST) Received: from outbound2-sin.bigfish.com (localhost.localdomain [127.0.0.1]) by outbound2-sin-R.bigfish.com (Postfix) with ESMTP id 68B3E12CA15B; Mon, 17 Dec 2007 13:33:02 +0000 (UTC) Received: from mail199-sin-R.bigfish.com (unknown [10.3.252.3]) by outbound2-sin.bigfish.com (Postfix) with ESMTP id 59A51B8005B; Mon, 17 Dec 2007 13:33:02 +0000 (UTC) Received: from mail199-sin (localhost.localdomain [127.0.0.1]) by mail199-sin-R.bigfish.com (Postfix) with ESMTP id 477D512E83BC; Mon, 17 Dec 2007 13:33:06 +0000 (UTC) X-BigFish: VP X-MS-Exchange-Organization-Antispam-Report: OrigIP: 12.23.250.36;Service: EHS Received: by mail199-sin (MessageSwitch) id 1197898386263962_1693; Mon, 17 Dec 2007 13:33:06 +0000 (UCT) Received: from spobmexc02.adprod.directory (smtp.ingramindustries.com [12.23.250.36]) by mail199-sin.bigfish.com (Postfix) with ESMTP id A26F91AF008E; Mon, 17 Dec 2007 13:33:05 +0000 (UTC) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: convert oracle from 10.1.0.5 linux 32 bit to 10.2.0.3 linux x86_64 Date: Mon, 17 Dec 2007 07:34:24 -0600 Message-ID: <17E4CDE8F84DC44A992E8C00767402E0860DCA@spobmexc02.adprod.directory> In-Reply-To: <3edcb66e0712141742xd9f7860oc0814ab979dd00ed@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: convert oracle from 10.1.0.5 linux 32 bit to 10.2.0.3 linux x86_64 References: <3edcb66e0712141742xd9f7860oc0814ab979dd00ed@mail.gmail.com> From: "Taylor, Chris David" To: , X-archive-position: 3967 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Chris.Taylor@ingrambarge.com Precedence: normal Reply-to: Chris.Taylor@ingrambarge.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 X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Well, since there are no other replies. My recommendation is to do an export/import. I opened up a SAR with Oracle about doing something very similar to this. The trick is moving from 32-bit to 64-bit. There's scripts to do this (coverting word size for the 64bit platform), but its really cleaner to do the export/import or datapump export/import. Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@ingrambarge.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ujang Jaenudin Sent: Friday, December 14, 2007 7:42 PM To: oracle-l@freelists.org Subject: convert oracle from 10.1.0.5 linux 32 bit to 10.2.0.3 linux x86_64 all, is there any one short way to do that job? is the upgrade script a.k.a catupgrd can magically doing convert?? thanks for your share... -- regards ujang jakarta - indonesia -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l