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 DEBIAN

gbsplayrc

gbsplayrc(5)						       Gameboy sound player						      gbsplayrc(5)

NAME

       gbsplayrc - Gameboy sound player configuration file

DESCRIPTION

       /etc/gbsplayrc and ~/.gbsplayrc are used by gbsplay(1).

SYNTAX

       Comments are introduced by hash marks.  A comment continues to the end of the line.  Whitespace, including empty lines, is ignored.  Option
       values follow the option name and an equal sign.  Valid option value types are:

       Boolean
	      An integer number in decimal. 0 is considered false, everything else is true.

       Endian A single character denoting the endianness. n == native endian, l == little endian and b == big endian.

       Integer
	      An integer number in decimal.

       Plugin The name of an output plugin.  Run gbsplay -o list to get a list of all available output plugins.

OPTIONS

       endian = Endian
	      The output endianness.

       fadeout = Integer
	      The fadeout time in seconds.  Instead of cutting of the subsong hard, do a soft fadeout.

       loop = Boolean
	      In loop mode the playback will restart from the beginning after the last subsong.

       output_plugin = Plugin
	      The sound output plugin to be used.

       rate = Integer
	      The samplerate to be used.

       refresh_delay = Integer
	      Set the refresh delay in milliseconds.  Larger values will lower CPU usage, but things as subsong changes,  fadeouts,  reactions	to
	      keypresses and the on-screen display will be delayed.

       silence_timeout = Integer
	      The silence timeout in seconds.  When a subsong contains silence for the given time, the player will skip to the next subsong.

       subsong_gap = Integer
	      The subsong gap in seconds.  Before playing the next subsong after the subsong timeout, play subsong_gap seconds of silence.

       subsong_timeout = Integer
	      The  subsong  timeout  in  seconds.  When a subsong has been played for the given time, the player will skip to the next subsong.  A
	      timeout of 0 seconds disables automatic subsong changes.

       verbosity = Integer
	      Sets the verbosity level (default: 3). A value of 0 means no messages on stdout.

FILES

       /etc/gbsplayrc
	      Default location of the global configuration file.

       ~/.gbsplayrc
	      User configuration file.

SEE ALSO

       gbsplay(1), gbsinfo(1)

BUG REPORTS

       If you encounter bugs, please report them via http://gbsplay.berlios.de/ or write to <gbsplay-dev@lists.berlios.de>.

AUTHOR

       gbsplay was written by Tobias Diedrich <ranma+gbsplay@tdiedrich.de> (with contributions from others, see README).

COPYRIGHT

       gbsplay is licensed under GNU GPL.

Tobias Diedrich 						      0.0.91							      gbsplayrc(5)