Error Encountered While Creating Oci Environment
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Connectivity issue SQL Server > SQL Server Integration oci error encountered ora 12154 Services Question 0 Sign in to vote Hi All, I am oci error encountered for source database unable to connect Oracle Database usingOracle Attunity connecter in SSIS 2012. It is working previously. Below is the
Oci Error Encountered Ssis
error message: TITLE: Microsoft Visual Studio ------------------------------ Error at Package [Connection manager "Oracle Connector 1"]: OCI error encountered. Error encountered while creating OCI environment ------------------------------ ADDITIONAL INFORMATION: Test connection
Create Oci Environment Failed With Rc=-1
failed ------------------------------ OCI error encountered. Error encountered while creating OCI environment (Package) ------------------------------ OCI error encountered. Error encountered while creating OCI environment (Package) ------------------------------ BUTTONS: OK ------------------------------ Thanks in Advance... Tuesday, January 20, 2015 2:44 PM Reply | Quote Answers 0 Sign in to vote Hi BHVS, At design time, when working with the SQL Server Business Intelligence Development Studio, the Oracle Connector is running in 32-bit mode and therefore it loads the 32-bit Oracle client. Most likely, we are getting the error because the connector is loading the wrong Oracle client (oci.dll), where the TNS service is not defined. To solve the problem, please refer to the following two options: Specify the Oracle connection string, instead of the TNS service name in the Oracle Connection Manager Editor, for example, in the following format: host:port/service_name Define a dummy registry entry (Z_SSIS) as follows: 1.Open the regedit utility. 2.Locate the following Key: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE. 3.Right-Click on ORACLE node and click on New -> Key. 4.Call the new key Z_SSIS (to make sure it's the last entry). 5.Right-Click on the Z_SSIS node and click on New -> String. 6.Name the property ORACLE_HOME. 7.Double-Click on the ORACLE_HOME and set it to the location of the Oracle 32Bit installation home directory you whant to use. Reference: http://ora-12154.ora-code.com/ Regards, Katherine Xiong Katherine Xiong TechNet Community Support Edited by Katherine XiongMicrosoft contingent staff, Moderator Wednesday, January 21, 2015 9:59
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Error encountered while creating OCI environment - NEED SOME HELP PLEASE !!! SQL Server > SQL Server Integration Services Question 0 Sign in to vote Hello, I have posted the below problem to Attunity Forum already. I thought I would post it here as well since, at this point, I https://social.msdn.microsoft.com/Forums/sqlserver/en-US/860e3aa1-46b1-42ba-81b8-9673a8f4e86b/connectivity-issue?forum=sqlintegrationservices am sure if this is an SSIS, MSSQL or the Microsoft Oracle Connector (by Attunity). If anyone has experience with resolving my error, PLEASE HELP!! Any kind of ideas/suggestios is appreciated because I am running out of ideas. Thank you ----------------- http://forums.attunity.com/forums/microsoft-ssis-oracle-connector/error-encountered-while-creating-oci-environment-3196.html Hello, Some background info: - Windows 2012 https://social.technet.microsoft.com/Forums/office/en-US/d6806f35-6431-4614-835d-db04e8f3dd22/error-encountered-while-creating-oci-environment-need-some-help-please-?forum=sqlintegrationservices 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 WH
rights reserved. Are you the publisher? Claim or contact us about this channel Embed this content in your HTML Search confirm cancel Report adult content: click to rate: http://starkville4.rssing.com/chan-3875931/all_p556.html Account: (login) More Channels Showcase RSS Channel Showcase 5500250 RSS Channel Showcase 7246453 RSS Channel Showcase 4972274 RSS Channel Showcase 9398269 Channel Catalog Subsection Catalog Articles on this Page http://www.techyv.com/questions/oci-error-encountered-oracle (showing articles 11101 to 11120 of 17784) 01/19/15--07:48: _SSIS -2012 Dynamic ... 03/01/13--08:17: _The package failed ... 01/19/15--13:44: _Is SSIS a good way ... 01/19/15--07:53: _SSIS Package fails error encountered ... 01/19/15--11:19: _Sql Server 2012 Int... 01/19/15--13:27: _Failed to locate pr... 01/19/15--03:16: _Getting error while... 01/19/15--07:16: _Accessing Project p... 01/06/15--17:37: _any way to re-try t... 01/18/15--15:17: _problem with import... 01/19/15--03:37: _SQL Server jobs fai... 01/20/15--07:06: _Reconnect database ... 01/20/15--06:44: _Connectivity issue 01/20/15--23:13: _[Forum FAQ] How do ... 01/20/15--22:48: _SSRS Report Issue 12/17/14--08:04: _SSISDB Verbose Logg... 01/21/15--02:46: _Checking OLAP oci error encountered Cube ... 01/21/15--02:22: _ExcelDestination Fo... 01/21/15--02:50: _Use SSIS SQLServer ... 01/21/15--03:07: _Use Parent Package ... (showing articles 11101 to 11120 of 17784) Browse the Latest Snapshot Browsing All Articles (17784 Articles) Live Browser Channel Description: All questions related to SSIS, transforms/data flow, control flow, and other related topics. older | 1 | .... | 553 | 554 | 555 | (Page 556) | 557 | 558 | 559 | .... | 890 | newer 0 0 01/19/15--07:48: SSIS -2012 Dynamic unpivot Contact us about this article HI EXPERT , I am working on SSIS 2012 . Excel as a Source . I have a data in excel file which contain revenue generated by Employee for client Client Emp1 Emp2 ClientA 10 20 ClientB 30 40 But number of "Emp" coming in Excel file is not fix , next month I could get revenue for EMP1, EMP2, EMP3 This is the case of Dynamic unpivot in SSIS . How to achieve this ? 0 0 03/
not accepted Solved answers TipsView Tips Recent PostsArticles Blogs Questions Tips Member ListView All Administrators & Moderators All Activities Archive Active Directory Apple Cloud Computing Database Developer Exchange Server Hardware Internet Microsoft Networking Programming Security Software Storage Virus OS Others Submitting... Title: * Questions: * Email id: Math question: * 14 + 6 = Solve this simple math problem and enter the result. E.g. for 1+3, enter 4. Show Search Box Search: * Quick Links Links My posts Test your skills Recent posts Create content Article Blog entry Questions Tips Top Posts Latest postMost read To Learn About Laptop Hard Drive To Learn About Language Pack For To Know About The Laptop For World To Learn About Laptop Screen Won’t To Have A Knowledge Of LAN Cable Help about websites powered by How to solve Windows Activation Give me example of application Error appears when tries to login How to create php press release Home > Solution Categories > Software Others > Development Software > OCI Error Encountered - Oracle OCI Error Encountered - Oracle No of visitors who read this post: 2119 Category: Development Software Type: Question Author: Fern bonnie Your rating: Select ratingCancel ratingPoorOkayGoodGreatAwesome No votes yet Hello TechyV buddies! I am having some issue using Oracle. I was using BIDS(Visual Studio) 2008 R2 with Attunity Oracle Provider 1.1 (source SSIS component) against Oracle, Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. My dev. box is a 32bit machine, running WinXP Pro. Using TNSNames.ora on my dev. Box allows me to connect to this Oracle database using SQL DEVELOPER smoothly and with no issues. DWTQ.NA.SMURFIT.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCP.na.smurfit.com)(PROTOCOL = TCP)(Host = mchir008)(Port = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = DWTZ.NA.SMURFIT.COM) ) ) The Attunity provider have no issues or any errors at the beginning. However, an error suddenly appeared to show this: "OCI Error Encountered" message. This is a Visual Studio message and states only, "OCI Error Encountered". Can anyone help me solve this issue? I don’t know what went wrong with my provider. I will really appreciate the effort in solving this. Thank you! Asked Fern bonnie on Thu, 2012-08-16 22:15 Fern bonnie's question Fern bonnie's question Login or Signup Now to post comments Tweet Comment viewing options Flat list - collapsedFlat list - expandedThreaded list - collapsedThreaded list - expanded Date - newest firstDate - oldest first 10 comments per page30 comments per page50 c