locked
Cannot connect to Oracle server via SQL Server tester extensions RRS feed

  • Question

  • Dear pro,

    I'm using:
       SQL Server Migration Assistant for Oracle v7.10.0 32 bit
       Oracle Client: OraClient11g_home1   32 bit
       Windows 7 32 bit JP

    When convert schema -> OK
     - Connect to Oracle (provider: Oracle Client provider, mode: Standart mode): -> OK
     - Connect to SQL Server: -> OK
     - Convert schema -> OK

    But when i run test case then throw error in step Prerequisites(Loading Oracle version...): Cannot connect to Oracle server via SQL Server tester extensions.
    Please support me fix this error.

    Log:

    [Mandatory: Generic] [6664/1] [2018-10-30 14:28:21]: SQL Server Migration Assistant for Oracle v7.10.0
    [Mandatory: Generic] [6664/1] [2018-10-30 14:28:21]: Starting assembly: SSMAforOracle, Version=7.10.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
    Created: 2018/09/06 17:20:26
    Last Modified: 2018/09/06 17:20:26
    OS Version: Microsoft Windows NT 6.1.7601 Service Pack 1
    OS architecture: x86
    Processor architecture: x86
    Current culture: ja-JP
    UI culture: ja-JP
    [Mandatory: Collector] [6664/1] [2018-10-30 14:29:10]: Oracle connection provider: oracleclient.
    [Mandatory: Collector] [6664/1] [2018-10-30 14:29:10]: Oracle connection mode: Standard.
    [Mandatory: Collector] [6664/1] [2018-10-30 14:29:12]: Oracle server version: '11.1.0.6.0'.
    [Error: Tester] [6664/5] [2018-10-30 14:29:23]: Error occured during connection to Oracle server via SSMA Tester extensions.
    [Error: Tester] [6664/5] [2018-10-30 14:29:23]: Extension error 'Command extension execution failed' occured. 
     Error message: 'Error occurred during unidimensional query command execution extension operation.'
    [Error: Tester] [6664/5] [2018-10-30 14:29:23]: Exception: Unable to find specified provider.
    Can not find compatible Oracle libraries. If you have 32-bit Oracle connectivity components installed, please use 32-bit version of the SQL Server Migration Assistant.
     site: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbConnection Connect(Microsoft.SSMA.Framework.Oracle.Base.Connection.OracleConnectionParameters, System.Security.SecureString)
     source: Microsoft.SSMA.Framework.Oracle.Base
       場所 Microsoft.SSMA.Framework.Oracle.Base.Connection.OracleConnectionFactory.Connect(OracleConnectionParameters connectionParameters, SecureString password)
       場所 Microsoft.SSMA.Framework.Oracle.SqlServer.Tester.Extensions.O2SSExecuteCommandExtensions`1.CreateConnections(O2SSExecuteCommandBatch batch, IExecutionState executionState)
       場所 Microsoft.SSMA.Framework.Generic.Testers.Extensions.Default.DefaultTesterExtensions`2.PrepareExecution(TBatch batch, IExecutionState executionState)
       場所 Microsoft.SSMA.Framework.Generic.Testers.Extensions.Default.DefaultTesterExtensions`2.ExecuteBatch(String batchXml)

    Tuesday, October 30, 2018 7:58 AM

All replies

  • Hi Dinh Ha,

    >>[Error: Tester] [6664/5] [2018-10-30 14:29:23]: Exception: Unable to find specified provider. Can not find compatible Oracle libraries. If you have 32-bit Oracle connectivity components installed, please use 32-bit version of the SQL Server Migration Assistant.

    Have you had 32-bit ODAC installed on your machine? Oracle Data Access Components (ODAC) are required for applications to connect to the database. And please make sure SSMA’s current security context has permission to the files. Follow this blog to set proper permission on Oracle Client folder.

    Best Regards
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" 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 MSDNFSF@microsoft.com

    Wednesday, October 31, 2018 6:30 AM
  • Hi,

    Tester comes in two parts - one is client user interface which is integrated in the SSMA UI and another one is the back-end which is installed on the target SQL Server with SSMA Extension Pack. Most of the commands are actually executed from the back-end via stored procedures installed with Extension Pack. It appears to me that this error is generated on the back-end (target SQL Server), so you need to make sure you have right Oracle connectivity components installed on the target SQL Server machine.

    I see that you are using 32-bit version of SSMA client, which is fine, but Extension Pack only comes in 64-bit version (that's it, we only support 64-bit SQL Server), so you will need to install 64-bit Oracle's client components on the SQL Server machine, where Extension pack is installed. Error message is a little bit deceiving, because we don't have 32-bit version of Extension Pack. I'll see if we can improve it, it's just using shared code now with client UI tool.

    Regards,
    Alex.

    Monday, November 5, 2018 4:49 PM