Error Code Ora 12154
Contents |
TNS:received bad packet type from network layer Cause: Internal error. Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support. ora 12154 error in oracle 11g ORA-12152: TNS:unable to send break message Cause: Unable to send break message. Connection probably error while trying to retrieve text for error ora-12154 disconnected. Action: Reestablish connection. If the error is persistent, turn on tracing and reexecute the operation. ORA-12153: TNS:not connected Cause: ora 12154 tns could not resolve service name Not currently connected to a remote host. Action: Reestablish connection. ORA-12154: TNS:could not resolve the connect identifier specified Cause: A connection to a database or other service was requested using a connect identifier, and ora 12154 tns no listener 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: - If you are using local naming (TNSNAMES.ORA file): -
Ora 12154 Tns Could Not Resolve Service Name Oracle 9i
Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA) - Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible. - Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file. - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable. - If you are using directory naming: - Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA). - Verify that the LDAP directory server is up and that it is accessible. - Verify that the net service name or database name used as the connect identifier is configured in the directory. - Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier - If you are using easy connect naming: - Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.O
SQL 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
Ora 12154 Tns Could Not Resolve The Connect Identifier Specified Xe
Burleson Blog
ora 12154 ssis connection manager ORA-12154: TNS could not resolve service name tips Question: I need help with this error: ORA-12154: ora 12154 toad TNS: could not resolve service name.Answer: 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. https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm Make sure that your listener is listening 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 http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm with an ALTER DATABASE command, as follows: alter database rename global_name 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 localDu siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... https://www.youtube.com/watch?v=QVJ1xO2V7Dc Wiedergabeliste Warteschlange __count__/__total__ How to resolve the ora 12154 error DBA Pro AbonnierenAbonniertAbo beenden1.9571 Tsd. Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube http://stackoverflow.com/questions/20361325/this-is-error-ora-12154-tnscould-not-resolve-the-connect-identifier-specified angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden Statistik 49.379 Aufrufe 42 Dieses Video ora 12154 gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 43 17 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 18 Wird geladen... Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Veröffentlicht am 31.01.2014In this tutorial you will learn how to resolve ora 12154 tns the ora 12145 error. Kategorie Menschen & Blogs Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video Oracle - Understanding the tnsnames.ora and listener.ora files - Dauer: 12:46 Chris Ostrowski 88.976 Aufrufe 12:46 How to Fix ORACLE 6i Error "ORA-12154: TNS:could not resolve the connect identifier specified". - Dauer: 4:02 SYED AIZAD RAZA KAZMI 3.087 Aufrufe 4:02 ora - 12514 and ora - 12505 tns listener error fixed in 90 seconds - Dauer: 1:30 CBOT 1.346 Aufrufe 1:30 解决 Oracle ora-12514错误 - Dauer: 33:45 Maclean Liu 1.025 Aufrufe 33:45 Listener Basics For DBA - Dauer: 45:23 Satish Lodam 13.746 Aufrufe 45:23 Oracle listener configuration | listener.ora | listener configuration in oracle 11g - Dauer: 5:29 Wysheid Wysheid 10.553 Aufrufe 5:29 Oracle 10g Listener and Database Creation - Dauer: 6:05 Recouner 7.681 Aufrufe 6:05 Oracle - TNS : Protocol Adapter Error Working Solution - Dauer: 0:57 Srijit Banerjee 49.056 Aufrufe 0:57 Oracle Forms 10g TNS Configuration - Dauer: 3:39 Ravi shankar kumar 4.903 Aufrufe 3:39 How to install Oracle 10g on Windows 7 32bit 64bit (Watch FullScreen) - Dauer: 7:18 SuperKhan1212 242.237 Aufrufe 7:18 Easy gui
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up this is error ORA-12154: TNS:could not resolve the connect identifier specified? up vote 5 down vote favorite 5 I've this code : OracleConnection con = new OracleConnection("data source=localhost;user id=fastecit;password=fastecit"); con.Open(); string sql="Select userId from tblusers"; OracleCommand cmd = new OracleCommand(sql, con); OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { messageBox.Show(dr[0].Tostring()); } Same code in both projects, in project1 "WinForm" Is Working correctly in project2 "Excel 2007 addins" Following error appears: ORA-12154: TNS:could not resolve the connect identifier specified I'm using C#.net 2010 ,office 2007 , windows8, oracle 10g. When preparing a manual connection to the database, as shown in the picture Visual Studio, open View menu + Server Explorer. Right mouse click on Data Connection + Add Connection + Select Oracle Database server Name : localhost or name of my machine, set username & password and click on Test Connection, test is no succeeds. c# oracle excel-addins share|improve this question edited Jun 2 at 11:09 Alex Weitz 7232519 asked Dec 3 '13 at 20:46 محمد النعيمي 1711315 1 don't you have to specify the database name somewhere ? –Habib Dec 3 '13 at 20:47 Yes, I can not specify the database somewhere –محمد النعيمي Dec 3 '13 at 20:51 The same code works correctly in Project1 "winForms" and on the same machine, but it does not work in another project "Excel 2007 addins" –محمد النعيمي Dec 3 '13 at 20:54 Is either project1 or project2 64-bit? Do you have more than one Oracle Home in your PATH environment variable? –helrich Dec 3 '13 at 21:08 project1 "winForms" Platform =x86 , output type =WindoseApplaciton.Project2 Platform =active any cpu,output type "Class Library" –محمد النعيمي Dec 3 '13 at 21:30 | show 2 more comments 2 Answers 2 active oldest votes up vote 16 down vote accepted ORA-12154: TNS:could not resolve the connect identifier specified? In case the TNS is not defined you can also try this one: If you are using C#.net 2010 or other version of VS an