Error 12541 Tns Listener
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation ora 12541 tns no listener dbd error ociserverattach Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts
Ora 12541 Tns No Listener But Listener Is Running
Ion Excel-DB Don Burleson Blog
ora 12541 tns no listener windows 7 Oracle Windows TNS error: No Listener found Oracle Database Tips by Burleson Consulting May 9, 2015 Question: I'm getting a TNSOra 12541 Tns No Listener Visual Studio
"no listener" error on my Windows Oracle database when trying to connect: LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=
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
Ora 12541 Tns No Listener Oracle Instant Client
site About Us Learn more about Stack Overflow the company Business Learn
Ora 12541 Tns No Listener Oracle 11g Client
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question ora-12541 tns no listener 11g x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle http://www.dba-oracle.com/t_windows_tns_no_listener_error.htm 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 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 http://stackoverflow.com/questions/13358656/oracle-client-ora-12541-tnsno-listener 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 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 s
log in tour help Tour Start here for a quick overview of the site Help Center Detailed http://dba.stackexchange.com/questions/73944/ora-12541-tnsno-listener 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 https://community.oracle.com/thread/2188674 Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange 12541 tns is a question and answer site for database professionals who wish to 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 12541 tns no and rise to the top ORA-12541: TNS:no listener up vote 3 down vote favorite 1 I've been working 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
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. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 14 Replies Latest reply on Mar 7, 2011 6:41 PM by 839770 ORA-12541- TNS:No Listener Error 839770 Mar 7, 2011 7:59 AM Dear All, I am new to oracle and this forum. I installed Oracle 11g and Oracle forms in my system. When i Try to connect to database thru SQL* Plus, am getting error as "ORA-12541- TNS:No Listener". Same issue when i try to connect thru Forms Builder. This is how my tnsnames.ora looks # tnsnames.ora Network Configuration File: C:\DevSuiteHome_2\network\admin\tnsnames.ora # Generated by Oracle configuration tools. EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Pradeep-PC)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = PLSExtProc) ) ) ORACLE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle) ) ) LISTENER_ORACLE = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) Kindly guide me I have the same question Show 0 Likes(0) 19655Views Tags: none (add) ora-12541Content tagged with ora-12541 This content has been marked as final. Show 14 replies 1. Re: ORA-12541- TNS:No Listener Error Kamran Agayev A. Mar 7, 2011 8:22 AM (in response to 839770) Please post the output of the following command from db server : lsnrctl statusIf it's down, then run lsnrctl star