Re: RE: Convert DB from 32-bit to 64 Bit in 9.2

From: <tim_at_sagelogix.com>
Date: Thu, 20 May 2004 08:07:49 -0600 (MDT)
Message-ID: <4157726.1085062069210.JavaMail.oracle@ocs.sagelogix.com>

There is no need to recreate control files when converting word size. That is an unnecessary (and therefore dangerous) step. There is excellent documentation on MetaLink for doing this conversion, for databases that are not using Java and those that are, but you've listed the essential steps save one:

0. Get a full backup of the database

Hope this helps...

Attached file included as plaintext by Ecartis --
File: RE: Convert DB from 32-bit to 64 Bit in 9.2

Return-Path: <oracle-l-bounce_at_freelists.org> Received: from mail.sagelogix.com by ocs.sagelogix.com

with ESMTP id 1746171085061410; Thu, 20 May 2004 07:56:50 -0600 Received: by mail.sagelogix.com (Postfix, from userid 70101)

id 0885C317B3; Thu, 20 May 2004 08:58:04 -0600 (MDT) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])

	by mail.sagelogix.com (Postfix) with ESMTP id 1D5EE317AB
	for <tim_at_sagelogix.com>; Thu, 20 May 2004 08:47:37 -0600 (MDT)
Received: from localhost (localhost [127.0.0.1])
	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP
	id 79DD972C3A7; Thu, 20 May 2004 09:43:02 -0500 (EST)

Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10957-61; Thu, 20 May 2004 09:43:02 -0500 (EST) Received: from turing (localhost [127.0.0.1])

	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP
	id B9AFA72C358; Thu, 20 May 2004 09:43:01 -0500 (EST)

Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 20 May 2004 09:41:55 -0500 (EST) X-Original-To: oracle-l_at_freelists.org
Delivered-To: oracle-l_at_freelists.org
Received: from localhost (localhost [127.0.0.1])

	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B6EE372C2A0
	for <oracle-l_at_freelists.org>; Thu, 20 May 2004 09:41:54 -0500 (EST)

Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10413-60 for <oracle-l_at_freelists.org>; Thu, 20 May 2004 09:41:54 -0500 (EST)
Received: from smtp1.corpsys.csedge.com (unknown [12.28.86.143])

	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AD79E72C194
	for <oracle-l_at_freelists.org>; Thu, 20 May 2004 09:41:52 -0500 (EST)

Received: from CSMAIL.corpsys.csedge.com ([172.21.100.103]) by smtp1.corpsys.csedge.com with InterScan Messaging Security Suite; Thu, 20 May 2004 09:59:28 -0500 Received: by csmail.corpsys.csedge.com with Internet Mail Service (5.5.2653.19)

id <JS3K7MS7>; Thu, 20 May 2004 09:59:28 -0500 Message-ID: <0C3690346404A94CBF4DDDD4724FC61411E8F035_at_csmail.corpsys.csedge.com> From: Bob Lofstrand <blofstrand_at_csedge.com> To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>,

"LazyDBA.com Discussion" <oracledba_at_lazydba.com> Subject: RE: Convert DB from 32-bit to 64 Bit in 9.2 Date: Thu, 20 May 2004 09:59:28 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)

Content-type: text/plain
X-Virus-Scanned: by amavisd-new at freelists.org
Content-Transfer-Encoding: 8bit

X-archive-position: 973
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce_at_freelists.org
Errors-To: oracle-l-bounce_at_freelists.org X-original-sender: blofstrand_at_csedge.com Precedence: normal
Reply-To: oracle-l_at_freelists.org
X-list: oracle-l
X-Virus-Scanned: by amavisd-new at freelists.org

Before shutting down your database, backup the control file to trace. You will need to create new control files using the 64 bit software. At least that was the case on AIX 5L.

-----Original Message-----

From: VIVEK_SHARMA [mailto:VIVEK_SHARMA_at_infosys.com] Sent: Monday, May 17, 2004 2:04 AM
To: oracle-l_at_freelists.org; LazyDBA.com Discussion Subject: Convert DB from 32-bit to 64 Bit in 9.2

Folks

Any Steps that I have missed other than the following?

Install 64 Bit Oracle Software
Shutdown Database (DB) using 32 Bit version
Export ORACLE_HOME Env variable to this 64-bit installation Path
Copy required DB startup parameter files i.e. init$SID.ora to the 64 Bit ORACLE_HOME/dbs=20
Bring up DB using 64 Bit version
As sysdba oracle user, from the 64 Bit path, run $ORACLE_HOME/rdbms/admin/utlirp.sql

Thanks

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu May 20 2004 - 12:06:13 CDT