POINTER: Oracle on Solaris connecting to SQL Server on Windows

Posted on 2006-04-03
Last Modified: 2013-12-27
Question by:davidlars99
    LVL 10

    Accepted Solution

    This question really has nothing to do with Solaris - literally nothing.  The vaguely closest thing is the endian architecture of the system the OS is running on - notice I said OS and not Solaris.  If Solaris is running on a SPARC chip, then the bits will be ordered within Oracle using Big Endian.  SQL server is running on a Little Endian machine and is probably Little Endian ordered.  From what I recall - and I'm not a DB - I'm almost positive to manually to get data from a Big Endian machine to a Little Endian machine you have to perform a database export on the Big Endian machine and then import the export into the Little Endian DB instance.  You can't just copy the files over like you can between say to SPARC servers.

    But again, the *endian* nature of the data has nothing to do with Solaris - Solaris is bound by the Endian laws just like Windows is.  You can't go from Big Endian to Little Endian with a middle translation process.
    LVL 13

    Author Comment

    thank you!

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    This tech tip describes how to install the Solaris Operating System from a tape backup that was created using the Solaris flash archive utility. I have used this procedure on the Solaris 8 and 9 OS, and it shoudl also work well on the Solaris 10 rel…
    Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now