Database Error 12541
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 oracle error 12541 of this site About Us Learn more about Stack Overflow the company sql error 12541 Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges ora 12541 tns no listener but listener is running Ask Question 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 ora-12541 tns no listener 11g 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 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
Tns No Listener Error In Oracle 11g
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 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 mea
NetWeaver AdministratorWhere is this place located?All Places SAP NetWeaver Administrator 8 Replies Latest reply: Oct 13, 2015 7:46 AM by Hardeep Singh Tweet *** error => connect failed
Ora 12541 Tns No Listener Toad
with sql error '12541' Basis T Apr 28, 2010 2:22 PM ora-12541: tns:no listener linux Currently Being Moderated Hi All, I have two SAP AS installed on same host.1. Netweaver 7.0 with tns-12560: tns:protocol adapter error oracle as DB.2. ECC IDES with oracle as DB.both dont share oracle home and their port numbers are also different.1527 for NW AS and 1528 for ECC IDES.Yesterday, http://stackoverflow.com/questions/13358656/oracle-client-ora-12541-tnsno-listener after installation of IDES both were running fine and today NW is running fine but IDES is not starting up.The logs are posted in next port.Please help me in resolving this.Regards, Sharib 9502Views Re: *** error => connect failed with sql error '12541' Basis T Apr 28, 2010 2:26 PM (in response to Basis T) Currently https://scn.sap.com/thread/1672432 Being Moderated dev_w0 log is :......-trc file: "dev_w0", trc level: 1, release: "701"-* ACTIVE TRACE LEVEL 1 ACTIVE TRACE COMPONENTS all, MJ*B B Wed Apr 28 17:13:41 2010B create_con (con_name=R/3)B Loading DB library 'E:\usr\sap\U2E\DVEBMGS02\exe\dboraslib.dll' ...B Library 'E:\usr\sap\U2E\DVEBMGS02\exe\dboraslib.dll' loadedB Version of 'E:\usr\sap\U2E\DVEBMGS02\exe\dboraslib.dll' is "700.08", patchlevel (0.25)B New connection 0 createdM sysno 02M sid U2EM systemid 562 (PC with Windows NT)M relno 7010M patchlevel 0M patchno 32M intno 20020600M make: multithreaded, Unicode, 64 bit, optimizedM pid 2212M M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)M length of sys_adm_ext is 576 bytesM ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2212) [dpxxdisp.c 1348]I MtxInit: 30000 0 0M DpSysAdmExtCreate: ABAP is activeM DpSysAdmExtCreate: VMC (JAVA VM in WP) is not activeM DpShMCreate: sizeof(wp_adm)29792(1752)M DpShMCreate: sizeof(tm_adm)5912704(29416)M DpShMCreate: sizeof(wp_ca_adm)24064(80)M DpShMCreate: sizeof(appc_ca_adm)8000(80)M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080M DpShMCreate: sizeof(comm_adm)552080(1088)M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0M DpShMCreate: sizeof(slock_adm)0(104)M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0M DpShMCreate: sizeof(file_adm)0(72)M DpShMCreate: sizeof(vmc_adm)0(1864)M DpShMCreate: sizeof(wall_adm)(41664/36752/64/192)M DpShMCreate: sizeof(gw_adm)48M DpShMCreate: SHM_DP_ADM_KEY(addr: 000000000B2B0050, size: 6614144)M DpShMCreate: allocated sys_adm at 000000000B2B0050M DpShMCreate: allocated wp_adm at 000000000B2B2270M DpShMCreate: allocated tm_adm_list at 000000000B2B96D0M DpShMCreate: allocated tm_adm at 000000000B2B973
log in tour help Tour Start here for a quick overview of the http://dba.stackexchange.com/questions/73944/ora-12541-tnsno-listener site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://www.forumtopics.com/busobj/viewtopic.php?p=323318 more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges no listener 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 from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can tns no listener 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 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
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. ORA-12541: TNS:no listener. Goto page 1, 2Next Search this topic...|Search WebIntelligence XI...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Building Reports -> WebIntelligence XI Author Message browncowPrincipal MemberJoined: 05 Sep 2002Posts: 190Location: Bakersfield, CA Posted: Sat Sep 23, 2006 2:15 amPost subject: ORA-12541: TNS:no listener. Database error: ORA-12541: TNS:no listener . Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901) I get this error and I am logged on as administrator into infoview/webi. If I log onto the server and write an adhoc query from DeskI, I do not get any errors. I am only getting the errors from Infoview/WebI. From the server, I can tnsping the instance with no problems and I can log onto the database server via SQL*PLUS without any issues, so its hard for me to believe its a middleware issue. Oracle 9.2.0.5 repository Oracle 9.2.0.5 data warehouse Oracle 9.2.0.1 client middleware Windows 2003 Server for WebI servers. HPUX for oracle rdbms I did a forum search first, and found some hits on ORA-1541 and WIS10901, but nothing seemed to match my case. any suggestions? thanks. Hao._________________Hao Ngo Aera Energy LLC Bakersfield, CA www.aeraenergy.com =============== BusObj 6.51 Hotfixes: 411, 640, 675, 838, 863 Win2ksp3, Oracle 9.2, Apache/Tomcat/NTLM Back to top BO_ChiefForum FanaticJoined: 06 Jun 2004Posts: 5585Location: Somewhere on God's Land. Posted: Sun Sep 24, 2006 12:16 amPost subject: Re: ORA-12541: TNS:no listener. Bounce the server and try....._________________help us help you! make sure your post has the following elements: • Does it include BO version, Database, an error, a problem, a SQL for object or Condition ? • Does it include some sample data what you have? • Does it include any code you already tried ? (working or not..) • Did you explain what you want for results? If any of those elements are missing,chances are you didn't post enough information for us to help you! Back to top browncowPrincipal MemberJoined: 05 Sep 2002Posts: 190Location: Bakersfield, CA Posted: Sun Sep 24, 2006 10:41 amPost subject: Re: ORA-12541: TNS:no listener. BO_Chief wrote: Bounce the server and try..... thanks for the suggestion, but that is usually the first thing i tr