No Listener Error In 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 Overflow the company Business Learn ora 12541 tns no listener but listener is running more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags
Tns-12541: Tns:no Listener Linux
Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like ora-12541 tns no listener 11g 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 Oracle database, but I have one issue, now ora 12541 tns no listener oracle 11g client 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 edited Sep 23 '14 at 9:26 subhashis 1,55672430 asked Nov 13 '12 at
Tns No Listener Error In Oracle 11g
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? –user75ponic Nov 13 '12 at 10:13 you've verified the listener is up on the "server1" box, verified its port number, and checked the TNSNames/c
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) NAMES.DI
Anil Kumar on June 26, 2013 All Posts, Database, Oracle DBA 18 Comments Resolved ORA-12541: TNS no listener error 4.57 (91.43%) 7 votes http://itbloggertips.com/2013/06/resolved-ora-12541-tns-no-listener-error/ N no. of articles you will find on the internet about "ORA-12541 TNS no listener error" but still finding an effective solution. Don't worry this solution helped me a lot http://www.toadworld.com/products/toad-for-oracle/f/10/t/22562 and I hope it will help you too. I got the same issue while working on Oracle 10g database then I decided to share my experience and steps to resolve no listener this issue. Error Message: ORA-12541 TNS no listener error Resolution: Now you have to follow below mentioned steps to resolve the ORA-12541 issue. Step-1: First check your listener status. C:\>lsnrctl status The above command will show the current status of your listener. Step-2: Start the listener, if listener is not running. C:\>lsnrctl start This command will start all your listener services. tns no listener Step-3: Stop the listener, if listener is running. C:\>lsnrctl stop This command will stop all your listener services. Step-4: Now restart the listener. C:\>lsnrctl reload This command will restart all your listener services. Note: If you want to see all the available listener commands. Type lsnrtcl help on command prompt and you will get all available options. C:\>lsnrctl help LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 02-JUL-2015 20:25:14 Copyright (c) 1991, 2010, Oracle. All rights reserved. The following operations are available An asterisk (*) denotes a modifier or extended command: start stop status services version reload save_config trace change_password quit exit set* show* Step-5: One last and very important thing which you have to do. Open sqlnet.ora file and make the changes as suggested. Change NTS to NONE SQLNET.AUTHENTICATION_SERVICES = (NONE) Now restart the listener services and your listener problem ORA-12541 will be resolved. If this is not working, do write in comment section. I will try to help you at the earliest.
NoSQL Oracle SQL Server PRODUCTSDiscussion & Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central Toad Data Modeler Toad Data Point Toad Extension for Eclipse Toad for Hadoop Toad for IBM DB2 Toad for Oracle Toad for MySQL Toad for SQL Server Toad for SAP Solutions Toad MAC Edition Home » Products » Toad for Oracle » Toad for Oracle Forum » ORA-12541: TNS:no listener ORA-12541: TNS:no listener Toad for Oracle Community Join Overview Forum Code Tester for Oracle Forum Spotlight on Oracle Forum SQL Optimizer for Oracle Forum Toad for Oracle Forum Blog Code Tester for Oracle Blog Spotlight on Oracle Blog SQL Optimizer for Oracle Blog Toad for Oracle Blog Idea Pond Connections Debug Editor General Grid Import/Export Monitor MyToad Other Schema Browser Team Coding Utilities Wiki Code Tester for Oracle Wiki Spotlight on Oracle Wiki SQL Optimizer for Oracle Wiki Toad for Oracle Wiki Media Code Tester for Oracle Videos Spotlight on Oracle Videos SQL Optimizer for Oracle Videos Toad Apps Toad for Oracle Videos Beta Beta Overview Beta Forum Members Forum Options RSS Feed Tweet Related Posts ORA-12541: TNS:no listener by Uday on 5 Jan 2015 LISTENER by ousseynousylla on 28 Aug 2015 Not Answered TNS-12541 ERR WITH Toad for oracle version 12.6 by BEREMY on 31 Dec 2014 View More This question is answered ORA-12541: TNS:no listener Follow cpeer / 14 Aug 2014 at 3:26pm I am getting the following when trying to establish a new connection to my Oracle Database. I know all the information is correct in here, it worked on my windows 7 machine with the same TNSNAMES, now on windows 8 I get this, any ideas? ORA-12541: TNS:no listener A connect descriptor for GOLD could not be located in the tnsnames.ora file Create an account to join the discussion. You have posted to a forum that requires a moderator to approve posts before they are publicly available. Replies All Replies Follow John Dorlon / 14 Aug 2014 at 4:22pm If GOLD is really in your tnsnames file, it sounds like the Oracle client is looking at the wrong tnsnames file. If you are not using the network\admin folder in your Oracle client, you’ll need to set up the TNS_ADMIN environment variable, which points to whateve