Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8174 32 bit to 9204 64 big

RE: 8174 32 bit to 9204 64 big

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Fri, 02 Apr 2004 12:37:20 -0500
Message-ID: <BAY99-F167b5MiKhBiM00029d21@hotmail.com>


I think there should not be any disagreement on this. As suggested by Dennis , create a new database under 9i and import 8i database export there.

I did the same thing last month as I have to change the 1)platform Sun to Linux
2)from 64 bit to 32 bit machine and oracle as well.

There was no issue with that and of course it was suggested by Dennis and great Mladen at that time.

Regards
Rafiq

From: "Hodgkinson, Stephen" <Stephen.Hodgkinson_at_cba.com.au> Reply-To: oracle-l_at_freelists.org
To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org> Subject: RE: 8174 32 bit to 9204 64 big
Date: Fri, 2 Apr 2004 22:44:27 +1000

I thought the same as Thomas Biju - oracle takes care of the 32-64 bit conversion
for you, when you do the upgrade and the DBA has no additional tasks to do.

Please let me known if you disagree as I will be upgrading production in a few weeks.

Stephen

-----Original Message-----
From: Thomas Biju [mailto:BThomas_at_br-inc.com] Sent: Friday, 2 April 2004 8:13
To: oracle-l_at_freelists.org
Subject: RE: 8174 32 bit to 9204 64 big

>>>Install 8174 (64 bit) software
>>>Convert the db from 32 bit to 64 (8174)
>>>migrate the db from 8174 (64 bit) to 9204 (64 bit).

Srinivas,
I do not think you need to perform the 64 bit conversion step at all. Oracl= e does the word size conversion during the upgrade implicitly.=20 I have done such upgrade using the DBUA and using scripts without any issue= s...
B.

-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Thursday, April 01, 2004 3:46 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: 8174 32 bit to 9204 64 big

Srinivas

    My theory as a DBA is to perform tasks in a manner that is least likely to cause bad consequences. Is there any way export/import would work for you? I have a much warmer feeling about using that to relocate my important data. Just create a new 9i database, check it out, make sure it is ready to go, practice the export/import, then perform the cutover. Much less to go wrong.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com=20

___________________________________________________________________________=
__________________________________

This electronic transmission and any attached files are intended solely for=   the person or entity to which they are addressed and may contain informati=
on that is privileged, confidential or otherwise protected from disclosure.=   Any review, retransmission, dissemination or other use, including taking a=

ny action concerning this information by anyone other than the named recipi=
ent, is strictly prohibited. If you are not the intended recipient or have =
received this communication in error, please immediately notify the sender =
and destroy this communication.

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
-----------------------------------------------------------------


**************   IMPORTANT MESSAGE  **************
This e-mail message is intended only for the addressee(s) and contains 
information which may be confidential. If you are not the intended recipient 
please advise the sender by return email, do not use or disclose the 
contents, and delete the message and any attachments from your system. 
Unless specifically indicated, this email does not constitute formal advice 
or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 
123 123 124) or its subsidiaries.
**************************************************

----------------------------------------------------------------
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
-----------------------------------------------------------------

_________________________________________________________________
Limited-time offer: Fast, reliable MSN 9 Dial-up Internet access FREE for 2 
months! 
http://join.msn.com/?page=dept/dialup&pgmarket=en-us&ST=1/go/onm00200361ave/direct/01/

----------------------------------------------------------------
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
-----------------------------------------------------------------
Received on Fri Apr 02 2004 - 11:33:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US