locked
SSMA - Oracle Instantclient or Full Client ? RRS feed

  • Question

  • Hi

    Just trying to set up SSMA for Oracle.

    Have downloaded SSMA V7.6 and set it up on a Windows Server 2012 R2 (x64).

    SQL Server 2014 installed.

    SSMA connects to the new SQL Server target database without issue.

    Downloaded and installed Oracle Instant Client - 12.2.0.1.0.

    Having connection issues with the Oracle DB - ORA-12170 - we are going to check the firewall settings to try and resolve the error.

    I just wanted to check if SSMA can work with the Instant Client or if it needs the full client installed - the system requirements say "Oracle Client 9.0 or a later version" ?

    Kind regards

    Ian



    • Edited by IWDukes Tuesday, October 10, 2017 10:39 PM
    Tuesday, October 10, 2017 10:37 PM

Answers

  • Hello Ian,

    ODAC = "Oracle Data Access Compents" is quite enough to run SSMA for Oracle; for me it worked.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • Edited by Olaf HelperMVP Wednesday, October 11, 2017 1:51 AM
    • Marked as answer by IWDukes Wednesday, October 11, 2017 7:20 AM
    Wednesday, October 11, 2017 1:51 AM
  • Hi IWDukes,

     

    >>I just wanted to check if SSMA can work with the Instant Client or if it needs the full client installed - the system requirements say "Oracle Client 9.0 or a later version" ?

     

    This means SSMA is designed to work with Oracle 9 or later versions and can only support Oracle 9 and later version. A limitation is that the Oracle client version must be the same version as, or a later version than, the Oracle database version.

     

    As mentioned by Olaf, SSMA only needs the Oracle Data Access Components (ODAC) to access the metadata in Oracle, The instant client is enough, SQL Server requires many permissions in Oracle, you can refer to this document: https://docs.microsoft.com/en-us/sql/ssma/oracle/connecting-to-oracle-database-oracletosql to check if you have missed anything.

     

    Best Regards,

    Teige

     


    MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    • Marked as answer by IWDukes Wednesday, October 11, 2017 7:21 AM
    Wednesday, October 11, 2017 5:36 AM

All replies

  • Hello Ian,

    ODAC = "Oracle Data Access Compents" is quite enough to run SSMA for Oracle; for me it worked.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • Edited by Olaf HelperMVP Wednesday, October 11, 2017 1:51 AM
    • Marked as answer by IWDukes Wednesday, October 11, 2017 7:20 AM
    Wednesday, October 11, 2017 1:51 AM
  • Hi IWDukes,

     

    >>I just wanted to check if SSMA can work with the Instant Client or if it needs the full client installed - the system requirements say "Oracle Client 9.0 or a later version" ?

     

    This means SSMA is designed to work with Oracle 9 or later versions and can only support Oracle 9 and later version. A limitation is that the Oracle client version must be the same version as, or a later version than, the Oracle database version.

     

    As mentioned by Olaf, SSMA only needs the Oracle Data Access Components (ODAC) to access the metadata in Oracle, The instant client is enough, SQL Server requires many permissions in Oracle, you can refer to this document: https://docs.microsoft.com/en-us/sql/ssma/oracle/connecting-to-oracle-database-oracletosql to check if you have missed anything.

     

    Best Regards,

    Teige

     


    MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    • Marked as answer by IWDukes Wednesday, October 11, 2017 7:21 AM
    Wednesday, October 11, 2017 5:36 AM
  • Thanks Olaf
    Wednesday, October 11, 2017 7:21 AM
  • Thanks for your advice Teige.
    Wednesday, October 11, 2017 7:21 AM