Error Ora 12154
Contents |
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 error ora 12514 Don Burleson Blog
error ora 12560 ORA-12154: TNS could not resolve service name tips Question: I need help with thisError Ora 12541
error: ORA-12154: 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
Connect Identifier
database name aliases. 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 oracle error ora-12154 can change the global_name 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
server but either failed to contact the server or did not find a matching service name on that server. TNS or 'Transparent Network Substrate' is a transport protocol that allows Oracle sessions to communicate across a network.
Oracle Connection Error Ora-12154
DB Server <=> Listener <=> Network connection <=> Client (SQL*Net) <=> Application. In the ora-12154 tns could not resolve service name path above, tnsping can be used to test the parts in bold and should be the first troubleshooting step. If tnsping fails, that ora 12154 tns no listener generally indicates a problem finding the server connection - if TNSNAMES specifies an IP address, is it correct?, if it's a DNS name, is that resolving correctly? (try switching for an IP address to find out.) http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm If tnsping succeeds, that can indicate a problem with the client configuration but could equally be that the connection is working as far as the listener but the database is down. Try comparing with another PC - if multiple machines are failing that usually points towards a server issue. Ora-12154 can be a tricky problem to nail down because there are many possible causes, try making a connection directly on the server or completely http://ss64.com/ora/syntax-ora-12154.html regenerate the TNSNAMES.ORA file on the client. ORA-12154 description: Cause: 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: Local naming (TNSNAMES.ORA file): - 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 can make it unusable. 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
Du 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 https://www.youtube.com/watch?v=tAFw9nhaASE verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... Wiedergabeliste Warteschlange __count__/__total__ How to Fix ORACLE 6i Error "ORA-12154: TNS:could not resolve the connect identifier specified". SYED AIZAD RAZA KAZMI AbonnierenAbonniertAbo beenden2222 Wird http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr error ora Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden Statistik 3.336 Aufrufe 8 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 9 1 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 2 Wird geladen... Wird geladen... Wird geladen... Die Bewertungsfunktion ist error ora 12154 nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Veröffentlicht am 25.02.2016 Kategorie Menschen & Blogs Lizenz Standard-YouTube-Lizenz Wird geladen... Anzeige Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video How to resolve the ora 12154 error - Dauer: 7:03 DBA Pro 49.006 Aufrufe 7:03 Oracle - Understanding the tnsnames.ora and listener.ora files - Dauer: 12:46 Chris Ostrowski 88.976 Aufrufe 12:46 解决 Oracle ora-12514错误 - Dauer: 33:45 Maclean Liu 1.025 Aufrufe 33:45 how to configure Listener, Database , Repository in Oracle 11g R2 - Dauer: 8:05 PRAVEEN DAS 6.642 Aufrufe 8:05 Best way to connect Oracle with Visual Studio .NET (no BadImageFormatException or mismatch error) - Dauer: 9:45 Samiul Al Hossaini 12.069 Aufrufe 9:45 Oracle listener configuration | listener.ora | listener configuration in oracle 11g - Dauer: 5:29 Wysheid Wysheid 10.553 Aufrufe 5:29 How to Create Menu in Oracle Forms..... - Dauer: 5:41 SYED AIZAD RAZA KAZMI 118 Aufrufe 5:41 009 How to Connect Forms Builder to Oracle Database 11g.mp4 - Dauer: 4:50 Goran Husamalddin 4.975 Aufrufe 4:50
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 Oracle ORA-12154: TNS: Could not resolve service name Error? up vote 11 down vote favorite 5 I am a SQL Server user . I am on a project that is using oracle (which I rarely use) I need to create an ODBC connection so I can access the some data via MS Access I have a application on my machine called oraHome90. It seems to allow a configuration of something called a listener in a “net configuration utility”, I think that a “Local Net Service Name Configuration” needs to also be done. The IT support gave me this information to set up the ODBC connection . I have tried every combination that I can think of. I can get past a test that successfully passes a test to “login“ to the oracle server database. When I try to create the ODBC connection I get the following error: ORA-12154: TNS: Could not resolve service name. Assuming that I want to start from scratch and the following information is supposed to allow for me to connect to the database….. Any suggestions or comment ? Note: ultimately the project will have a website .ASP page query the data, but I have to first prove that I can see the data using the ODBC connection via MS Access Service name: SERVICENAME HOST = HOST.XYZi.com User Id: MYUSERID Password: MYPASSWORD ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 'Oracle Connection Dim ocst Dim oconn ocst = "Provider=OraOLEDB.Oracle;" & _ "Data Source=DATASOURCE;" & _ "User ID=CHIJXL;" & _ "Password=password;" set oconn = CreateObject("ADODB.Connection") oracle odbc tns share|improve this question edited Oct 15 '08 at 19:26 David