This discussion is archived
8 Replies Latest reply: Aug 14, 2012 11:50 PM by mkirtley-Oracle RSS

Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)

848387 Newbie
Currently Being Moderated
Is Oracle Database Gateway for SQL Server available for the Solaris x86 (64bit) operating system? I know it is available for Solaris SPARC, however I am using the x86 (64bit) version.
  • 1. Re: Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)
    kgronau Guru
    Currently Being Moderated
    no, there is no gateway available for Solaris x86.
  • 2. Re: Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)
    848387 Newbie
    Currently Being Moderated
    I don't believe you are correct. It looks like it is already installed. My current inventory includes..

    Oracle Database Gateway for ODBC 11.2.0.1.0

    Here are some of my installation log entries.

    INFO: *** Entering Component: oracle.rdbms.hsodbc installation
    INFO: Processing Oracle Database Gateway for ODBC 11.2.0.1.0
    INFO: Processing Oracle Database Gateway for ODBC 11.2.0.1.0
    INFO: Calling Query generalQueries10.2.0.2.0 getOSName
    INFO: Query Returned: Intel_Solaris
    INFO: Setting variable 's_operatingSystem' to 'Intel_Solaris'. Received the value from the variable calculation.
    INFO: Setting variable 's_makeLogFile' to 'make.log'. Received the value from the variable calculation.
    INFO: Setting variable 's_gtwSID' to 'dg4odbc'. Received the value from the variable calculation.
    INFO: Setting variable 's_gtwExe' to 'dg4odbc'. Received the value from the variable calculation.

    INFO: Copying files for 'Oracle Database Gateway for ODBC 11.2.0.1.0 '
    INFO: Copying files for 'Oracle Database Gateway for ODBC 11.2.0.1.0 '
    INFO: 3/6/10 4:52:05 PM CST: Starting install Install Phase 1 of component Oracle Database Gateway for ODBC

    INFO: 3/6/10 4:52:19 PM CST: Starting install Link Phase of component Generic Connectivity Common Files
    INFO: Linking 'Oracle Database Gateway for ODBC 11.2.0.1.0 '
    INFO: Linking 'Oracle Database Gateway for ODBC 11.2.0.1.0 '
    INFO: 3/6/10 4:52:19 PM CST: Starting install Link Phase of component Oracle Database Gateway for ODBC
    INFO: Calling Action unixActions10.2.0.3.0 registerForMake
         installMakePath = /usr/ccs/bin/make
         installMakeFileName = /opt/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk
         installTarget = idg4odbc
         installArguments = ORACLE_HOME=/opt/oracle/product/11.2.0/db_1
         undoMakeFileName = null
         undoTarget = null
         undoArguments = null
         logFile = /opt/oracle/product/11.2.0/db_1/install/make.log
         progMsg = Linking dg4odbc Executables

    INFO: Setting up 'Oracle Database Gateway for ODBC 11.2.0.1.0 '
    INFO: Setting up 'Oracle Database Gateway for ODBC 11.2.0.1.0 '
    INFO: 3/6/10 4:53:27 PM CST: Starting install Install Phase 2 of component Oracle Database Gateway for ODBC
    INFO: Calling Action fileActions10.2.0.6.0 instantiateFile
         selectedNodes = null
         source = /opt/oracle/product/11.2.0/db_1/hs/admin/listener.ora.sample
         destination = /opt/oracle/product/11.2.0/db_1/hs/admin/listener.ora.sample
         variables = null
         encoding = null

    INFO: instantiating '/opt/oracle/product/11.2.0/db_1/hs/admin/listener.ora.sample'.
    INFO: instantiating '/opt/oracle/product/11.2.0/db_1/hs/admin/listener.ora.sample'.
    INFO: Calling Action fileActions10.2.0.6.0 instantiateFile
         selectedNodes = null
         source = /opt/oracle/product/11.2.0/db_1/hs/admin/tnsnames.ora.sample
         destination = /opt/oracle/product/11.2.0/db_1/hs/admin/tnsnames.ora.sample
         variables = null
         encoding = null
  • 3. Re: Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    There was a problem where DG4ODBC was included on the install media for some platforms where it is not actually supported and it looks like Solaris x86 is one of those.
    There is no official port of DG4ODBC to this platform.

    Regards,
    Mike
  • 4. Re: Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)
    848387 Newbie
    Currently Being Moderated
    Thank you for your reply. I will contact Oracle Support to find out if or when they expect the product to become functional.
  • 5. Re: Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)
    kgronau Guru
    Currently Being Moderated
    There's an official certification matrix available on OTN:http://www.oracle.com/technetwork/database/gateways/certmatrix-168347.pdf

    => it shows Solaris SPARC as certified platform not x86.
    So although it is linked on Solaris x86 this platform it is not supported nor is there a guarantee it will work.
  • 6. Re: Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)
    audreyj Newbie
    Currently Being Moderated
    Did you get a response, will it be available for the Solaris x86-64 platform?
  • 7. Re: Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)
    918463 Newbie
    Currently Being Moderated
    Where make download in Software install Database Gateway for Sql server for solaris x86(64bits)?
  • 8. Re: Availabilty of Database Gateway for SQL Server for Solaris x86(64bit)
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    As it says in the earlier updates the gateway products are not available on Solaris x86(64bits) and are only available on Solaris Sparc 64-bit.
    As far as I know there are no plans to port to Solaris x86(64bits). The only workround is to install the gateway on a supported platform and access the gateway from the RDBMS on Solaris x86(64bits) using database links.

    Regards,
    Mike

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points