Migrating Oracle from Big Endian to Little Endian Platorm Post: 302197764

Sponsored Content

Special Forums UNIX and Linux Applications Migrating Oracle from Big Endian to Little Endian Platorm Post 302197764 by luft on Wednesday 21st of May 2008 04:10:40 PM

05-21-2008

Registered User

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], [], [], [], [], [], []

luft

View Public Profile for luft

Find all posts by luft

7 More Discussions You Might Find Interesting

1. 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,

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

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

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

6. 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?

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

LEARN ABOUT OPENSOLARIS

mlib_vectorreversebyteorder

mlib_VectorReverseByteOrder(3MLIB)			    mediaLib Library Functions				mlib_VectorReverseByteOrder(3MLIB)

NAME

       mlib_VectorReverseByteOrder - reverse byte order of vector

SYNOPSIS

       cc [ flag... ] file... -lmlib [ library... ]
       #include <mlib.h>

       mlib_status mlib_VectorReverseByteOrder(void *z, const void *x,
	    mlib_s32 n, mlib_s32 s);

DESCRIPTION

       The  mlib_VectorReverseByteOrder() function changes the encoding of each element from big endian to little endian, or from little endian to
       big endian.

       It copies and reverses the byte order of each element of the input vector into the output vector.

PARAMETERS

       The function takes the following arguments:

       z    Pointer to the output vector.

       x    Pointer to the input vector.

       n    Number of elements in the vectors.

       s    Size of elements in bytes.

RETURN VALUES

       The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mlib_VectorReverseByteOrder_Inp(3MLIB), mlib_VectorReverseByteOrder_S16(3MLIB), mlib_VectorReverseByteOrder_S16_S16(3MLIB), attributes(5)

SunOS 5.11							    2 Mar 2007					mlib_VectorReverseByteOrder(3MLIB)