Results 1 to 2 of 2

Thread: Error encountered while creating OCI environment - NEED SOME HELP PLEASE !!!

  1. #1
    sidneylu is offline Junior Member
    Join Date
    Dec 2015
    Rep Power

    Error encountered while creating OCI environment - NEED SOME HELP PLEASE !!!


    Some background info:

    - Windows 2012 Server R2
    - Oracle client x32 11gR2
    - Running SSIS x32 DTExec utility
    - Microsoft Oracle Connector x32 2.0

    The package I have connects to Oracle 11gR2, pulls data and loads them into MSSQL 2012. The package runs
    perfectly in SSDT (aka BIDS) as well as executing it from the command line calling Microsoft x32 DTExec.exe. However, when the job
    is invoked from the SQLAgent as a scheduled job, it keeps failing with the following error:

    Error: 2016-04-03 10:34:52.99
    Code: 0x000002C0
    Source: Load_Expense_to_SQL Connection manager "WHSE"
    Description: OCI error encountered. Error encountered while creating OCI environment
    End Error
    Error: 2016-04-03 10:34:52.99
    Code: 0x0000020F
    Source: Execute the Oracle SQL Oracle Source [74]
    Description: The AcquireConnection method call to the connection manager WHSE failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
    End Error

    WHSE is my Attunity Oracle connector connection name just as an FYI. It's also the name of my TNS. The SQL Server Agent runs under a domain\sqlagent account. I even logged on to the server as "domain\sqlagent" and executed the x32 DTExec commaind line, it worked perfectly. So this service account clearly has enough permissions to run the job. I also see my Oracle x32 oracle home (C:\app\oracle\product\11.2.0\client_1\bin) as part of the PATH. I have read a lot of posts about ensuring the Oracle Home is part of the PATH. Well it's there.

    Again, I have successfully executed this SSIS using various methods BUT SQL Agent. I created a BAT file and ran it as Windows Scheduled Task. But I
    can't get this to work in SQL Agent job running this same BAT file.

    Can someone please help?

    Thank you.

  2. #2
    Richard is offline US Technical Sales Manager
    Join Date
    Aug 2006
    Rep Power

    Error encountered while creating OCI environment running with SQLAgent

    Hi Sidney,
    I was researching your problem and was going to confirm you had the full Oracle client both 32 and 64 bit. And found you figured out your problem on the MS TechNet as a permission related. I will include the URL should other face this issue. Thank you.


    To Find Out more About Attunity Technology:
    Contact Us

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts