No Listener Error Sqlplus
Contents |
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 ora 12541 tns no listener but listener is running Overflow the company Business Learn more about hiring developers or posting ads with us Stack
Tns-12541: Tns:no Listener Linux
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community
Ora-12541 Tns No Listener 11g
of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle client ORA-12541: TNS:no listener [closed] up vote 20 down vote favorite 1 I am new on
Tns No Listener Error In Oracle 11g
Oracle database, but I have one issue, now on my Database server (server1) listener and database instance is run correctly and I can use sqlplus to connect to this DB, But when I connect to database by using other server, I check the TNS configuration is correct but system said ERROR: ORA-12541: TNS:no listener My database is Oracle 10gR2 So how can I solve this issue? oracle listener share|improve this question ora 12541 tns no listener oracle 11g client edited Sep 23 '14 at 9:26 subhashis 1,55672430 asked Nov 13 '12 at 9:58 aliasosx 1332212 closed as off-topic by Jens Erat, Annjawn, Eric Brown, g00glen00b, showdev Feb 21 '14 at 23:30 This question appears to be off-topic. The users who voted to close gave this specific reason:"Questions on professional server- or networking-related infrastructure administration are off-topic for Stack Overflow unless they directly involve programming or programming tools. You may be able to get help on Server Fault." – Jens Erat, Annjawn, Eric Brown, g00glen00b, showdevIf this question can be reworded to fit the rules in the help center, please edit the question. 3 should be a serverfault.com / dba.stackexchange.com question –Raptor Nov 13 '12 at 10:01 But when I connect to database by using other server You mean to say that when you try to connect the same database from server? –user75ponic Nov 13 '12 at 10:01 I mean I connect to Database server by client by sqlplus or sql developer on Sqldeveloper Error "An error was encountered performing the requested operation: The Network Adapter could not establish the connection Vendor code 20" –aliasosx Nov 13 '12 at 10:04 So you are able to connect to database using sqlplus but not from SQL Developer? –us
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss ora-12514 tns no listener the workings and policies of this site About Us Learn more about ora-12541: tns:no listener linux Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions ora 12541 tns no listener toad Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn http://stackoverflow.com/questions/13358656/oracle-client-ora-12541-tnsno-listener from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Oracle client throwing ORA-12541: TNS:no listener up vote 3 down vote favorite when i was trying to connect my remote server as- sqlplus http://dba.stackexchange.com/questions/53380/oracle-client-throwing-ora-12541-tnsno-listener SYSTEM/oracle@192.168.0.171:1521/kannel it shows me this error- SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 15 15:36:52 2013 copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-12541: TNS:no listener I have checked my listener, it is running [root@roracle bin]# ./lsnrctl status LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 15-NOV-2013 15:42:24 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused tnsnames.ora file contain - KANNEL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = kannel) ) ) listener.ora file contain SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = kannel) (ORACLE_HOME = /opt/u01/app/product/11.2.0/dbhome_1) (SID_NAME = kannel) ) ) LISTENER= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) ) ) sqlnet.ora file contain- SQLNET.AUTHENTICATION_SERVICES= (ALL) N
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora12541tns-no-listener-error-while-connecting-to-database-using-sqlplus-in-oracle-9i-4870364 Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE http://www.dbforums.com/showthread.php?1660244-oracle-11g-sql-*-plus-login-error-TNS-12541-TNS-no-listener A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX VoIP_News Inside-ERP I_am_the_dragon Inside-CRM maxwellarnold Michael Meyers-Jouan no listener TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus Craig Borysowich Dennis Stevenson mircea_luca Richard DukeGanote iudithm Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk jakarman Adrian_Grigoriu knowscognosdoi COMPANIES GeoTrust Juniper Networks Silver Peak Sophos View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle tns no listener Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-12541:TNS: No Listener Error While Connecting to Database Using SQL*Plus in Oracle 9i Amit Thorat asked Jul 27, 2012 | Replies (9) ORA-12541:TNS: no listener error whil
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: oracle 11g sql * plus login error :: TNS-12541: TNS:no listener Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-13-10,11:43 #1 subhotech View Profile View Forum Posts Registered User Join Date Jan 2010 Posts 64 Unanswered: oracle 11g sql * plus login error :: TNS-12541: TNS:no listener Hi, I am getting the error : TNS-12541: TNS:no listener when logging to sql plus in oracle 11g. PFA the entry for tnsping orcl and ping