Ora 12541 Error Oracle
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
Ora-12541 Tns No Listener 11g
Us Learn more about Stack Overflow the company Business Learn more about hiring ora-12541 tns no listener toad developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the ora-12541: tns:no listener linux 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 client ORA-12541: TNS:no listener [closed]
Tns No Listener Error In Oracle 11g
up vote 20 down vote favorite 1 I am new on 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
Ora 12541 Tns No Listener Oracle 11g Client
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 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 Adapt
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might tns-12560: tns:protocol adapter error have Meta Discuss the workings and policies of this site About
Ora-12514 Tns No Listener
Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads ora-12541 tns no listener windows with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to http://stackoverflow.com/questions/13358656/oracle-client-ora-12541-tnsno-listener improve their database skills and learn 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 ORA-12541: TNS:no listener up vote 3 down vote favorite 1 I've been working http://dba.stackexchange.com/questions/73944/ora-12541-tnsno-listener this issue all day, reading posts here and other locations. I'm just not able to get past this error. I can connect just fine locally on my server (CentOS), but continue to get the TNS:no listener error when trying to connect via my Mac (OSX Mavericks) which is on the same subnet. Below are some notes I've captured based on what information I see that has been requested for this type of issue: -------------------------------------------------------------------------------- MISC NETWORK CONFIG: -------------------------------------------------------------------------------- [root@rubyrailssvr ~]# more /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.1.14 rubyrailssvr.homenet.com [root@rubyrailssvr ~]# [root@rubyrailssvr ~]# more /etc/sysconfig/network NETWORKING=yes HOSTNAME=rubyrailssvr.homenet.com [root@rubyrailssvr ~]# -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- LISTENER.ORA File: -------------------------------------------------------------------------------- [oracle@rubyrailssvr ~]$ more /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora # listener.ora Network Configuration File: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1521)) ) ) DEFAULT_SERVICE_LISTENER = (XE) [oracle@rubyrailssvr ~]$ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- TNSNAMES.OR
Anil Kumar on June 26, 2013 All Posts, Database, Oracle DBA 18 Comments Resolved http://itbloggertips.com/2013/06/resolved-ora-12541-tns-no-listener-error/ ORA-12541: TNS no listener error 4.57 (91.43%) 7 votes 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 and I hope it will help you too. I got the same issue no listener while working on Oracle 10g database then I decided to share my experience and steps to resolve 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 tns no listener 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. 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 thi