Oci Error 12154
Contents |
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 SSIS Oracle Connector ORA-12154: TNS:could not resolve the connect identifier specified Results 1 to 4 ora 12154 tns could not resolve the connect identifier specified 10g of 4 Thread: ORA-12154: TNS:could not resolve the connect identifier specified LinkBack LinkBack URL About ora 12154 ssis connection manager LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Email this Page… Search ora-12154 tns could not resolve the connect identifier specified windows 7 Thread Advanced Search Display Linear Mode Switch to Hybrid Mode 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, ora-12154 tns could not resolve service name 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 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
Test Connection Failed Because Of An Error In Initializing Provider. Ora-06413:
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 sites, but you need to download the Oracle SDK and install it for it to find the TNSNames. The file is ODTwithODAC112021.zip and its easily locatable on the Oracle website. Free download. As soon as I installed it, everything worked fine. Surprising, but true! Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « SQL Job package fails, works in VS2008 | Issues with installation - and slowness of BIDS » Posting Permissions You may not post new threads You may not post rep
while creating a linked server to Oracle ★★★★★★★★★★★★★★★ SnehadeepJune 30, 201028 Share 0 0 This is one of the most common errors while creating linked server
Ora-12154 Sqlplus
to Oracle database. Today I will discuss the reason for this error ora-12154 tns could not resolve service name oracle 11g and possible resolutions.
Full error message: OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned message tns could not resolve the connect identifier specified sqlplus "ORA-12154: TNS:could not resolve the connect identifier specified". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDAORA" http://forums.attunity.com/forums/microsoft-ssis-oracle-connector/ora-12154-tns-could-not-resolve-1612.html for linked server "LINKED_ORA". First of all make sure you have reviewed the following Microsoft KB article that has a lot of good information on troubleshooting Oracle linked server issues. How to set up and troubleshoot a linked server to an Oracle database in SQL Server http://support.microsoft.com/kb/280106 Also make sure you have installed Oracle Client on the https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/06/30/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle/ SQL server. If the SQL server is 64 bit then we need to install 64 bit Oracle provider. You can also create linked server using Oracle ODBC driver together with Microsoft OLE DB provider for ODBC. Once again on a 64 bit SQL server you need to install the 64-Bit OLEDB Provider for ODBC (MSDASQL) and 64 bit Oracle ODBC drivers. However 64-Bit OLEDB Provider for ODBC (MSDASQL) is already there in Windows Vista/Windows Server 2008 and later OS. This particular error message is a very general error message and can happen for quite a number of reasons. For general understanding of the error, you can review oracle documentation like this http://ora-12154.ora-code.com/ In SQL Server Linked Server, it could indicate a few things (not limited to)– 1. SQL Server (and oracle net libraries) is not able to get the TNS alias from tnsnames.ora file. 2. Something is wrong with the way the alias is created in the tnsnames.ora file (incorrect syntax) 3. TNS alias could not be resolved into a connSQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm
ORA-12154: TNS could not resolve service name tips Question: I need help with this error: ORA-12154: TNS: could not resolve service name.Answer: http://www.forumtopics.com/busobj/viewtopic.php?p=885290 The ORA-12154 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases. Make sure that your listener is listening tns could for the same service name that you are using. Your service name might have an alias, so check for global (world) entries and local entries. Check: $ORACLE_HOME/network/admin/tnsnames.ora Check your global_name setting with this SQL: select * from global_name; The query value should match your init.ora parms for db_name and db_domain, You can change the global_name with an ALTER DATABASE command, as follows: alter database rename global_name tns could not to xxx; Also see these notes on configuring your tnsnames.ora file and troubleshooting network errors. Rampant author Steve Callan notes this on the ORA-12154 error: "One of the most common errors related to improper configuration is the "ORA-12154: TNS: could not resolve service name" error. It is not uncommon for new users of Oracle to spend hours upon hours trying to figure out what their mistake is when ORA-12154 appears." The oerr utility notes this on the ORA-12154 error:: $oerr ora 12154 ORA-12154: TNS:could not resolve the connect identifier specifiedCause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached. Action: The following actions may be appropriate: If you are using local naming (tnsnames.ora file): Make sure that TNSNAMES is listed as one of the values of the names.directory_path parameter in the sqlnet.ora OBI, Melbourne: Oct 23, FLBOUG, Clearwater: Oct 28, ASUG Northern California: Nov 2, ASUG Arizona Chapter: Nov 3, ASUG All Texas Chapter Meeting: Nov 11. ORA-12154: TNS:could not resolve the connect identifier Search this topic...|Search DI: Designer and Job Design...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Data Integrator -> DI: Designer and Job Design Author Message alokkarnPrincipal MemberJoined: 09 Oct 2009Posts: 192 Posted: Tue Apr 24, 2012 3:31 amPost subject: ORA-12154: TNS:could not resolve the connect identifier Hi, I have BODS 3.2 installed on windows and job server configured on AIX unix machine for oracle 11g. However, I have oracle 10 client installed on my designer machine. I have tnsnames.ora and other points taken care as you would normally check in oracle forum posts. I am able to connect repository using sqlplus and the job server responds well. When I execute the job, it fails with the error. 1028268 1 CON-120404 24/04/2012 09:26:27 Initialization 1028268 1 CON-120404 24/04/2012 09:26:27 OCI call