| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Convert DB from 32-bit to 64 Bit in 9.2
I did not mean to imply that recreating the control files will be necessary
in all cases. This was very likely a bug specific to our configuration. It
was a while back so I do not recall the specifics. In our case it was
necessary to create new controlfiles using the 'create controlfile' command.
Best to be cautious and backup your controlfile(s) to trace as part of
backing up you whole system if you don't do so already.
-----Original Message-----
From: tim_at_sagelogix.com [mailto:tim_at_sagelogix.com]
Sent: Thursday, May 20, 2004 9:08 AM
To: oracle-l_at_freelists.org; oracledba_at_lazydba.com
Subject: Re: RE: Convert DB from 32-bit to 64 Bit in 9.2
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...
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
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?
Thanks
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.
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.
 |
 |