RE: Cloning databases from Sun Solaris to Sun X86 architecture

The 'endianness' depends on the hardware architecture. x86 is little endian, Sparc is big endian.  

So, if you're moving from Solaris Sparc to Solaris x86, you're looking at changing endianness. With 10g, RMAN can be used to move tablespaces across machines with differing endianness.  

-Mark  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest/CSA 

"There are 10 types of people in the world:  Those who understand
binary, and those who don't." 

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Reidy, Ron
Sent: Wednesday, April 18, 2007 4:15 PM
To: paulastankus_at_yahoo.com; Oracle-L Freelists
Subject: RE: Cloning databases from Sun Solaris to Sun X86 architecture



To determine the ENDIAN format of your source DB:

 

select t.endian_format

from v$transpotable_platform t, v$database d

where t.platform_name = d.platform_name;

 

Not sure how you can tell the same for the Sun box you are on, unless
you create a small test DB instance and execute the above query on it.
My guess is if your source is x86 and the Sun is x86, you are dealing
with the same ENDIAN format - YMMV.

 

--

Ron Reidy

Lead DBA

Array BioPharma, Inc.

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula Stankus
Sent: Wednesday, April 18, 2007 1:39 PM
To: Oracle-L Freelists
Subject: re: Cloning databases from Sun Solaris to Sun X86 architecture

 

My system administrator recommended and purchased a box with the Sun X86
architecture.  It allowed a lot of capacity and a low price. 

 

Now I am supposed to clone an existing 10g database to it.  Can I do
this and be sure that there are no little endian, big endian issues?  

 

How can I tell for certain if there will be or if there are?

 

Any assistance would be greatly appreciated.

 

Thanks,

Paula

  

________________________________

Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.
<http://us.rd.yahoo.com/evt=48245/*http:/autos.yahoo.com/new_cars.html;_
ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM-


>  


________________________________

This electronic message transmission is a PRIVATE communication which
contains information 
which may be confidential or privileged. The information is intended to
be for the use of the individual 
or entity named above. If you are not the intended recipient, please be
aware that any disclosure, 
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender 
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), 
and then delete it from your system. 


--
http://www.freelists.org/webpage/oracle-l