Ora 12154 Error In Oracle 10g
Contents |
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. ora 12154 could not resolve the connect identifier specified Please enter a title. You can not post a blank message. Please
Ora-12154 Sqlplus
type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion ora-12154 tns could not resolve the connect identifier specified windows 7 is archived 1 2 Previous Next 20 Replies Latest reply on Feb 12, 2012 8:43 AM by 916945 Oracle 10g XE: ORA 12154 - TNS could not not resolve connect error while trying to retrieve text for error ora-12154 identifier 872952 Jul 3, 2011 5:02 PM Hello all, I'm a newbie to the database world. I've downloaded Oracle 10g XE and this is working fine. I've also downloaded Microsoft SQL Server 2008 R2 Trial Version and I wish to connect it to this. I've installed Oracle Instant Client and unzipped it in ORACLE_HOME. When I add the ODBC
Ora-12154 Tns Listener Does Not Currently Know Of Service Requested In Connect Descriptor
in Data Sources and test this I get an error:
ORA 15154 - TNS could not resolve connect identifier
I've amended the listener.ora and tnsnames.ora files and also the environment varialbe TNS_ADMIN to point to /ORACLE_HOME/Network/Admin. I've also added ORACLE_HOME to the PATH variable. I've done a tnsping and lsnrctl status in the Command Line and all looks to be fine. TNS_ADMIN:C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
PATH:C:\oraclexe\instantclient_11_2;C:\oraclexe\app\oracle\product\10.2.0\server\bin
My listener.ora and tnsnames.ora files are as follows: ----- tnsnames.ora -----h1.OracleXE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.66)(PORT = 1521)) (CONNECT_DATA = (SERVER = 192.168.1.66) (SERVICE_NAME = XE) (HS = OK) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) XE1= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP) (HOST=192.168.1.66) (PORT=1521)) (CONNECT_DATA = (SERVICE_NAME = XE) ) (HS = OK))
----- listener.ora -----SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_N
Google. Het beschrijft hoe wij gegevens gebruiken en welke opties je hebt. Je moet dit vandaag nog doen. Navigatie overslaan NLUploadenInloggenZoeken Laden... Kies je taal. Sluiten Meer informatie View this tns could not resolve the connect identifier specified oracle 10g message in English Je gebruikt YouTube in het Nederlands. Je kunt deze voorkeur hieronder ora-12154 tns could not resolve service name oracle 11g wijzigen. Learn more You're viewing YouTube in Dutch. You can change this preference below. Sluiten Ja, nieuwe versie behouden Ongedaan maken
Tns Could Not Resolve The Connect Identifier Specified Sqlplus
Sluiten Deze video is niet beschikbaar. WeergavewachtrijWachtrijWeergavewachtrijWachtrij Alles verwijderenOntkoppelen Laden... Weergavewachtrij Wachtrij __count__/__total__ How to resolve the ora 12154 error DBA Pro AbonnerenGeabonneerdAfmelden1.9751K Laden... Laden... Bezig... Toevoegen aan Wil je hier later nog een https://community.oracle.com/thread/2249443 keer naar kijken? Log in om deze video toe te voegen aan een afspeellijst. Inloggen Delen Meer Rapporteren Wil je een melding indienen over de video? Log in om ongepaste content te melden. Inloggen Statistieken 50.612 weergaven 42 Vind je dit een leuke video? Log in om je mening te geven. Inloggen 43 17 Vind je dit geen leuke video? Log in om je mening te geven. Inloggen https://www.youtube.com/watch?v=QVJ1xO2V7Dc 18 Laden... Laden... Laden... Beoordelingen zijn beschikbaar wanneer de video is verhuurd. Deze functie is momenteel niet beschikbaar. Probeer het later opnieuw. Gepubliceerd op 31 jan. 2014In this tutorial you will learn how to resolve the ora 12145 error. Categorie Mensen & blogs Licentie Standaard YouTube-licentie Meer weergeven Minder weergeven Laden... Autoplay Wanneer autoplay is ingeschakeld, wordt een aanbevolen video automatisch als volgende afgespeeld. Volgende Oracle - Understanding the tnsnames.ora and listener.ora files - Duur: 12:46. Chris Ostrowski 91.272 weergaven 12:46 How to Fix ORACLE 6i Error "ORA-12154: TNS:could not resolve the connect identifier specified". - Duur: 4:02. SYED AIZAD RAZA KAZMI 3.522 weergaven 4:02 ora - 12514 and ora - 12505 tns listener error fixed in 90 seconds ✅ - Duur: 1:30. CBOT 1.746 weergaven 1:30 解决 Oracle ora-12514错误 - Duur: 33:45. Maclean Liu 1.025 weergaven 33:45 Listener Basics For DBA - Duur: 45:23. Satish Lodam 14.492 weergaven 45:23 Oracle 10g Listener and Database Creation - Duur: 6:05. Recouner 7.681 weergaven 6:05 Easy guidelines to fix Error 12514 - Duur: 1:24. rhina disouza 2.023 weergaven 1:24 Best way to connect Oracle with Visual Studio .NET (no BadImageFormatException or mismatch error) - Duur: 9:45. Samiul Al Hossaini 12.779 weergaven 9:45 Oracle - TNS
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 http://stackoverflow.com/questions/18278157/oracle-forms-just-another-ora-12154-error 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 http://www.bluegecko.com/ora-12154-tnscould-not-resolve-the-connect-identifier-specified/ the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle Forms - Just could not another ORA-12154 error up vote 0 down vote favorite ---The problem is solved, the Oracle Forms has its own otnsnames.ora file, located in NET80\ADMIN--- I have Oracle and Oracle Forms Runbtime installed on mi PC (windows). THe whole stuff connects to another machine where the database is set. At Oracle Forms Runtime lauching, I have an ORA-12154 error. Here are the things I checked (and I could not resolve really don't know what to check more, that's why I'm asking here) -Checking my Oracles configuration files : #tnsnames.ora BOL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sajama)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = BOL) ) ) #sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) The host "sajama" is declared in hosts file. -Checking the connexion with the database. I'm able to connect with tnsping to BOL, and i can connect to the database via Sqlplus with the same identifiers and SID that I enter in Oracle Forms. I didn't found any information about a specific Oracle Forms configuration file, nor information about this specific problem on the net... I actually already have another machine connecting to the same database, and their tnsmanes.ora and sqlnet.ora are exactly the sames. Moreover, the Oracle Forms scripts are installed on the Oracle database machine, it's then the same file that is lauched from the two computers. And, it works on the secund one. Does someone have a clue? Thanks for your help! oracle oracle10g tnsnames share|improve this question edited Aug 6 '14 at 16:22 Mat 136k21235274 asked Aug 16 '13 at 16:35 user2
Blog Oracle MySQL News & Events Oracle Applications Amazon Web Services Jeremiah Wilton's Oradeblog OurSQL Community Podcast Remote DBA Team viewer Whitepapers About Us Philosophy The Blue Gecko Teams Employment Opportunities Partners News Press Contact Us March 4, 2009 by jwilton ORA-12154: TNS:could not resolve the connect identifier specified The error also appears in some versions as: "ORA-12154: TNS:could not resolve service name." When a program needs to connect to an Oracle service via Oracle Networking (SQL*Net), it must look up the connect data for that service somewhere. When the lookup fails, the Oracle client code raises ORA-12154. Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link. Note that this error is generated by the Oracle client code on the local host where the program is running, not by the remote Oracle service to which you are attempting to connect. There are a few ways that the Oracle client code can look up connect data: A flat file named tnsnames.ora Oracle Names service LDAP If you see the whole ORA-12154 error with the text, then your program is finding a working Oracle client install, but that the Oracle service as specified is not listed in tnsnames.ora, Oracle Names or LDAP. The most common causes of ORA-12154 are: The entry is missing from tnsnames.ora The entry in tnsnames.ora is malformed The program is using tnsnames.ora from the wrong ORACLE_HOME The program is not using a fully-qualified service name, but no default domain is enabled in sqlnet.ora Most sites use tnsnames.ora, but enough use Oracle Names and LDAP that the first step should be to determine which name resolution method is deployed at your site. If you are not the database administrator, you should get in touch with the people who manage your Oracle systems and find out which method you should be using. Often they will be able to provide guidance for reso