RE: RE: Convert DB from 32-bit to 64 Bit in 9.2
- From: Bob Lofstrand <blofstrand@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>,oracledba@xxxxxxxxxxx
- Date: Thu, 20 May 2004 16:16:32 -0500
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@xxxxxxxxxxxxx [mailto:tim@xxxxxxxxxxxxx]
Sent: Thursday, May 20, 2004 9:08 AM
To: oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx
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...
-- 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@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx>; 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@xxxxxxxxxxxxx
Delivered-To: oracle-l@xxxxxxxxxxxxx
Received: from localhost (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with
ESMTP id B6EE372C2A0
for <oracle-l@xxxxxxxxxxxxx>; 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@xxxxxxxxxxxxx>;
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@xxxxxxxxxxxxx>; 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@xxxxxxxxxxxxxxxxxxxxxxxxx>
From: Bob Lofstrand <blofstrand@xxxxxxxxxx>
To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>,
"LazyDBA.com Discussion" <oracledba@xxxxxxxxxxx>
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@xxxxxxxxxxxxx
Errors-To: oracle-l-bounce@xxxxxxxxxxxxx
X-original-sender: blofstrand@xxxxxxxxxx
Precedence: normal
Reply-To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx]
Sent: Monday, May 17, 2004 2:04 AM
To: oracle-l@xxxxxxxxxxxxx; 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?
1) Install 64 Bit Oracle Software
2) Shutdown Database (DB) using 32 Bit version
2) Export ORACLE_HOME Env variable to this 64-bit installation Path
3) Copy required DB startup parameter files i.e. init$SID.ora to the 64
Bit ORACLE_HOME/dbs=20
4) Bring up DB using 64 Bit version
5) 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
