Migrating Oracle from Big Endian to Little Endian Platorm


 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Migrating Oracle from Big Endian to Little Endian Platorm
# 1  
Old 05-21-2008
Migrating Oracle from Big Endian to Little Endian Platorm

Hi,
We are trying to migrate an oracle database from Sun Solaris (SunOS 5.9 Generic_118558-28 sun4u sparc SUNW,Ultra-60) to Linux 2.6.18-53.1.19.el5 #1 SMP Tue Apr 22 03:01:10 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux which is basically a Big Endian to Little Endian conversion.

We shutdown the source database in Solaris and took a cold backup and placed the backup on the the Linux machine. We then converted each datafiles on Linux using the following RMAN commands.

convert datafile
'/d2/oradata/iol2005d/orig/bf2007q2.dbf'
,'/d2/oradata/iol2005d/orig/bf2007q4.dbf'
,'/d2/oradata/iol2005d/orig/system01.dbf'
....

.....

db_file_name_convert ('/d2/oradata/iol2005d/orig/','/d2/oradata/iol2005d/')
from platform 'Solaris[tm] OE (64-bit)';
parallelism = 3;

All the datafiles got converted sucessfully except the system datafile which errored out. Can we not convert the system datafile from Big Endian to Little Endian?

Thanks
# 2  
Old 05-21-2008
The more usual way to migrate corss-platform is to export all of the schemas, then import them onto the new box.

If this is failing you'll have to resort to export/import. Did RMAN return any error?
# 3  
Old 05-21-2008
Yes export/import would work but it will take some time. We could also use transportable tablespace but we would like to see if the RMAN convert would work..As you can see from the putput listed below, normal datafiles get converted successfully. It is only the system datafile we have problems with..

Converting Non system datafile - successful
=======================================


RMAN> CONVERT DATAFILE
'/d3/oradata/IOL64/custom_01.dbf'
TO PLATFORM="Linux 64-bit for AMD"
FROM PLATFORM="Solaris[tm] OE (64-bit)"
DB_FILE_NAME_CONVERT="/d3/oradata/IOL64", "/d3/oradata/IOL32";

2> 3> 4> 5>
Starting backup at 21-MAY-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=114 devtype=DISK
channel ORA_DISK_1: starting datafile conversion
input filename=/d3/oradata/IOL64/custom_01.dbf
converted datafile=/d3/oradata/IOL32/custom_01.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:07:16
Finished backup at 21-MAY-08

Converting Non system datafile - Erroring out
=======================================

RMAN> CONVERT DATAFILE
'/d3/oradata/IOL64/system01.dbf'
TO PLATFORM="Linux 64-bit for AMD"
FROM PLATFORM="Solaris[tm] OE (64-bit)"
DB_FILE_NAME_CONVERT="/d3/oradata/IOL64", "/d3/oradata/IOL32";

2> 3> 4> 5>
Starting backup at 21-MAY-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=149 devtype=DISK
channel ORA_DISK_1: starting datafile conversion
input filename=/d3/oradata/IOL64/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/21/2008 10:26:46
ORA-00600: internal error code, arguments: [ktu_format_nr-1], [0], [], [], [], [], [], []
# 4  
Old 05-22-2008
Did you check for known problems on Metalink?
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Endian vs pfsense??

Hi Endian firewall free version if we do compare pfsense For a LAN network with active user 1000 Which do you recommend Share (0 Replies)
Discussion started by: mnnn
0 Replies

2. Solaris

question about the little-endian in sparc

hi folks, in the sparc v9 manul , it says it is possible to access the memory data in little-endian mode, but there is only privilaged instruction that could set the PSTATE ( the cle bit ) regist. if I'm in the user mode , is it possible for me to access the data in little-endian mode? (10 Replies)
Discussion started by: zerocool_08
10 Replies

3. UNIX for Dummies Questions & Answers

Little Endiean and Big Endian

Dear Friends, I have one question in my mind. That question is "how to detect whether the system is little endiean or big endian" Processing the bit position is the difference between this endians. But I could not understand how to find the pariticular sytem works... (3 Replies)
Discussion started by: Nirmal Babu
3 Replies

4. UNIX for Advanced & Expert Users

Endian Conversion

Hi everybody, I met this week a problem. For now, we used TRU64 system based on alpha. Now, we're installing UP-UX systems (on Itanium). And we have problem with our files. Indeed, we use file with COMP-3, COMP-5 data. These files are used on both platforms. (we use also TXT files which... (1 Reply)
Discussion started by: bigmike59270
1 Replies

5. Programming

Big and Little Endian

We are developing an application using TLI for network communication.The Server Code is developed in Sun and client in SCO unix. When we route data from Client to Server we encrypt the data using DES algotithm utility.The problem we are facing that Sun uses Big Endian methodology to store data in... (1 Reply)
Discussion started by: S.P.Prasad
1 Replies

6. UNIX for Advanced & Expert Users

AIX endian again

Hi all I know AIX is big-endian machine.But does it read bytes in normal way from LSB. Does it happen in some machine that at multi-byte integer level it is Little-endian and while reading a single byte it is Big-Endian. This is urgent Thanks in advance. (3 Replies)
Discussion started by: Shobhit
3 Replies

7. UNIX for Advanced & Expert Users

Endian issues in TCP/IP

Hello, Can anybody tell me whether the little endian-big endian issues will affect porting from True64 to HP UNIX or TCP/IP will take care of that? If it affects what can be the solution. Thank you, (3 Replies)
Discussion started by: informshilpa
3 Replies
Login or Register to Ask a Question

Featured Tech Videos