Leave a Reply Cancel reply Enter your comment here... asked 3 years ago viewed 64785 times active 1 year ago Linked 10 How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora? 0 How can I launch SQL Developer? It does not actually check whether the listener handles the service name or a database is up and running tnsping orcl.dadbm.com:1521/orclor tnsping orcl 1) If it works, you will get a Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... http://tawish.org/could-not/windows-7-cannot-connect-to-telnet.php
you connect with 10.10.151.15:1521/orcl to service orcl which is not there in your "lsnrctl status". Your database doesn't register with the default listener for some reason. I have a windows server with an Oracle 10gR2 version DB. C:\app\oracle\product\11.2.0\client_1\network\admin share|improve this answer edited Apr 8 '15 at 20:28 Community♦ 11 answered Nov 14 '13 at 1:28 DCookie 29.2k84966 Excellent, that did the job, thank you. –glaucon Nov
Ora-12154 Tnsping Works Sqlplus Fails
Covered by US Patent. However I was able to fix this and wanted to share this if that helps someone getting the same error. 1) I have installed Oracle 9i and trying to connect using For further details, turn on tracing and reexecute the // operation.
The windows file tnsnames.ora had contrl characters that messed up SQLPLUS!! All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Services Summary... Ora 12154 Tns Could Not Resolve The Connect Identifier Specified 10g Action: 1.
I was also greeted with another error while troubleshooting this ORA-12560: TNS:protocol adapter error I am not sure what fixed this. Sqlplus Ora-12514 Tnsping Ok This document explains the different types of consol… Hardware IT Administration Server Hardware Unix OS Networking Hardware-Other Using SQL Scripts in Oracle Application Express Article by: Swadhin Using SQL Scripts we All rights reserved. http://www.dbforums.com/showthread.php?1642264-Cannot-connect-to-DB-using-sqlplus-but-can-tnsping-the-database Does anybody from Oracle ever read these posts?
Promoted by Experts Exchange Engage with tech pros in our community with native advertising, as a Vendor Expert, and more. Sqlplus Ora-12154 Re: ORA-12154: TNS:could not resolve the connect identifier specified 509395 Aug 4, 2006 2:33 PM (in response to orafad) That's an answer, but not a good one. The lister just stopped working... Oracle Database ARCHIVELOG mode Kill an Oracle process (OS level) Managing Data Security Manage Oracle Jobs Index usage in Oracle Manage an Oracle Tablespace Oracle Restart Oracle PFILE, SPFILE Oracle SQL*Loader
If this is the case open firewall port or establish firewall tunnel.
Reply With Quote 05-08-09,03:03 #4 dadorador View Profile View Forum Posts Registered User Join Date May 2009 Location Manila, Philippines Posts 16 For example I have a database on the server
Test Oracle Net connectivity - tnsping The Oracle Net Listener is the gateway to the Oracle instance for all nonlocal user connections.
Like Show 0 Likes(0) Actions 49.
So I took the advice from that answer SQL> alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' scope=both; SQL> alter system register; and it now works, presumably because it can resolve the localhost reference, where
Sqlplus Ora-12514 Tnsping Ok
The corresponding Datapump Import utility is also discussed and demonstrated. Related 3Oracle 11g Listener not working1Oracle server connection reset by peer socket write error1check listener status other than 15211Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant1Unable to create a Ora-12154 Tnsping Works Sqlplus Fails Both described in one of my presentations on SlideShare and in Demos on DaDBm YouTube channel. Sqlplus Could Not Resolve The Connect Identifier Specified Verify that the database listener is configured properly using the following commands: tnslsnr status tnslsnr status tnslsnr services … tnsnames.ora file example ORCL1 = (DESCRIPTION = (ADDRESS
All rights reserved. All rights reserved. To start with, you should check which Oracle home you are using really (registry, PATH etc.), then check that sqlnet.ora and tnsnames.ora "matches". All rights reserved. Tns Could Not Resolve Service Name Sqlplus
The average person thinks he's above average! Symmetric group action on Young Tableaux Is there an actual army in 1984? Oracle NET Client Server configuration An Oracle database is represented to clients as a service; that is, the database performs work on behalf of clients. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified TNSPING: bash-2.05b$ tnsping test TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28 Copyright (c) 1997, 2003, Oracle.
Handler(s): "D000" established:0 refused:0 current:0 max:1022 state:ready DISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=mariel)(PORT=1045)) The command completed successfully And this C:\Documents and Settings\user1>lsnrctl status LSNRCTL for 64-bit Windows: Version 22.214.171.124.0 - Production Tnsping Not Working All rights reserved. Turn off tracing when the operation is complete.
IPs) then the connection way should be similar to any remote DB connection -- Kirill Kirill Loifman says: January 29, 2016 at 15:41 My another article about can explain partly this
Used parameter files: C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = machine.domain.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME e.g. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Ora-12154 Tns Could Not Resolve Service Name Oracle 11g Exiting SQL*Plus Similarly, if I connect via SqlDeveloper I get an error (albeit ORA-12505, TNS:listener does not currently know of SID given in connect descriptor).
C:\oracle\10g\instantclient>echo %TNS_ADMIN% C:\oracle\10g\instantclient\TNS_ADMIN C:\oracle\10g\instantclient>dir %TNS_ADMIN% Volume in drive C is AP02 System Volume Serial Number is 1CE6-B98B Directory of C:\oracle\10g\instantclient\TNS_ADMIN 13.07.2006 09:45
. 13.07.2006 09:45 .. 12.07.2006 17:25 1.283 Windows example 1) First enable telnet on Windows 7 if it’s not there: pkgmgr /iu:"TelnetClient" 2) Check the database port telnet orcl1.dadbm.com 1523 => no output in case of a it's not the database server. Can anyone suggest why ?