Ora-12154 Ssis Error
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums
Ora 12154 Tns Could Not Resolve The Connect Identifier Specified 10g
Answered by: SSIS Can't connect to Oracle SQL Server ora-12154 tns could not resolve the connect identifier specified windows 7 > SQL Server Integration Services Question 0 Sign in to vote I have a 32-Vista
Ora-12154 Tns Could Not Resolve Service Name
machine. I am using SQL Server 2008 R2. I have created a SSIS project. Under the Connection Manager, I am trying to connect to ora-12154 tns could not resolve service name oracle 11g a remote Oracle 9 server Database(in the same office). The TNSNAMES.ORA is in a different server folder \\fg6ler\SDD-TNSadminand I am pointing to it in the Registry. Do I need to have a copy of it in my local machine Or has it to be only in the Oracle server? ora 12154 ssis connection manager The file TNSNAMES.ORA has: ora1.cpd.ca,ora1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = tfsoradbat01.cpd.ca)(PORT = 1529)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora1.cpd.ca) ) ) Also the Oracle DBA gave me these info: Schema_name: PHIT_TEST Passwd: tester Database_name: ora1 Server: tfsoradbat01 Port: 1529 Objects_owner: ORAPHA I tried with Oracle Provider OLEDB from SSIS and have the following error. Do I have to load anything from the Oracle? Error: ORA-12154:TNS:could not resolve the connect identifier specified. I have in Connection Manager(SSIS): Provider=NAtive OLEDB\Oracle Provider for OLEDB Server or file name=ora1(also tried with tfsoradbat01 server name--same error) User name=PHIT_TEST Password=tester ----------- Under registry, I have: Computer-->HKEY_LOCAL_MACHINE-->SOFTWARE-->Oracle--> -KEY_OraClient11g_home1,ODP.NET Now KEY_OraClient11g_home1-->TNS_ADMIN , REG_SZ, \\fg6ler\SDD-TNSadmin What am I doing wrong.Thanks in advance. I also tried: Server Or file name=ora1.cpd.statcan.ca,ora1 (Just to match the TNSNAMES.ORA)--Same error
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Tns Could Not Resolve The Connect Identifier Specified Visual Studio
and policies of this site About Us Learn more about Stack Overflow ora-06413 the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags
Tns Could Not Resolve The Connect Identifier Specified Oracle 10g
Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c2a0868f-8909-4a0c-840f-cb122cfec011/ssis-cant-connect-to-oracle?forum=sqlintegrationservices takes a minute: Sign up How to fix error 'Ora-12154 TNS could not resolve service name' in SSIS? up vote 1 down vote favorite When MS-SQL Server 2000 dtsx job tries to run, gets error Ora-12154 TNS could not resolve service name Tnsping to the oracle service to connect replies OK. The Windows 2003 x64 Server that runs the dtsx http://stackoverflow.com/questions/1058500/how-to-fix-error-ora-12154-tns-could-not-resolve-service-name-in-ssis jobs has 32 bit Oracle Server, ODAC 32 bit and Oracle Client 32 bit installed. sql-server oracle ssis share|improve this question edited Aug 6 '11 at 2:30 asked Jun 29 '09 at 14:03 Kayhan YUKSEL Please clarify whether you mean SQL 2000 or 2005. DTSX is the file format for SSIS in SQL 2005/8 - SQL 2000 had DTS. –Ed Harper Jun 29 '09 at 14:30 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote The TNSNames setting on a machine may be user specific. i.e. The connection might work logged in as you, but fail when it runs under the SQLAgent user. At our location, we use a networked TNS Names file, and set a system environment variable on the server. This forces it to use the same TNS names file for all users: TNS ADMIN = \\server\path\ORACLE share|improve this answer answered Jun 29 '09 at 14:19 Bill 3,19121319 do we have to add TNS ADMIN like ORACLE_HOME (TNS_ADMIN, using underscore) to the env. variables? BTW, no ORACLE_HOME is define
Read Quick Links Today's Posts View Site Leaders Who's Online Advanced Search Forum Microsoft SSIS Connectors and Change Data Capture by Attunity Microsoft SSIS Connectors by Attunity Microsoft http://forums.attunity.com/forums/microsoft-ssis-oracle-connector/ora-12154-tns-could-not-resolve-1612.html SSIS Oracle Connector ORA-12154: TNS:could not resolve the connect identifier specified Results 1 to 4 of 4 Thread: ORA-12154: TNS:could not resolve the connect identifier specified LinkBack LinkBack URL About LinkBacks Bookmark https://community.oracle.com/thread/2166618 & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Email this Page… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode tns could Switch to Threaded Mode 02-08-2011,03:32 PM #1 ckaushik Junior Member Join Date Feb 2011 Posts 2 Rep Power 0 ORA-12154: TNS:could not resolve the connect identifier specified Hi, I am trying to build oracle connection from SSIS on my Win 7 machine. I have Oracle 11g 32 bit Client installed and able to connect using SQL Plus. I also have VS 2008 and SQL tns could not 2008 installed. I get the follwoing error when I am trying to test the connection from SSIS connection manager. OCI error encouneterd. ORA-12154: TNS:could not resolve the connect identifier specified I would appreciate if someone can help me with this. Thanks KC Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote 02-08-2011,03:51 PM #2 ckaushik Junior Member Join Date Feb 2011 Posts 2 Rep Power 0 Resolved the issue by changing the TNS service name with host:port/service_name Its working. Thanks KC Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote 06-30-2011,06:06 PM #3 learnssis Junior Member Join Date Jun 2011 Posts 1 Rep Power 0 ORA-12154: TNS:could not resolve the connect identifier specified hi Kaushik, can you please give an exmaple or better yet a screen shot of the connection manager I am having the same issue and its driving me nuts thanks in advance Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote 09-27-2011,08:14 PM #4 bairdn Junior Member Join Date Sep 2011 Posts 4 Rep Power 0 Need the oracle SDK to fix this Its been answered on numerous other sit
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Oracle Provider for OLE DB All PlacesDatabaseDatabase Application DevelopmentWindows and .NETOracle Provider for OLE DB This discussion is archived 7 Replies Latest reply on Nov 20, 2012 5:22 PM by 947793 ORA-12154: TNS:could not resolve the connect identifier specified 807089 Jan 26, 2011 9:14 PM Hi all, I need your help. I have this error in the oracle connection with OLEDB: ORA-12154: TNS:could not resolve the connect identifier specified Connection string: cn.Open "Provider=OraOLEDB.Oracle;Data Source=C800FSI1_2;UserId=DIP;Password=XXXXXX;"Listener.ora # listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_2) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = C800FSI1)(PORT = 1521)) ) ) ADR_BASE_LISTENER = C:\app\Administratorsqlnet.ora # sqlnet.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\sqlnet.ora # Generated by Oracle configuration tools. # This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT. NAMES.DEFAULT_DOMAIN = C800FSI1 SQLNET.AUTHENTICATION_SERVICES = (none) SQLNET.AUTHENTICATION = (none) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)TnsNames.ora # tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\tnsnames.ora # Generated by Oracle configuration tools. C800FSI1_2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = C800FSI1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = C800FSI1_2) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))