Odbc 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 of this site About Us Learn more about Stack Overflow the company ora-12541 but listener is running Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Ora-12541 Tns No Listener 11g
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million ora 12541 tns no listener toad 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 Oracle database, but I ora-12541: tns:no listener linux 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 edited Sep 23 '14 at 9:26 subhashis
Ora 12541 Tns No Listener Oracle 11g Client
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? –user75ponic Nov 13 '12 at 10:13 you've verified the listener is
causes this error?[edit] An ORA-12541 error occurs when the listener for the destination server is down or unreachable when you try to connect. This can tns no listener error in oracle 11g be due to the listener not being started or being incorrectly configured, or tns-12560: tns:protocol adapter error it can be due to a network connection problem. How to fix it[edit] Make sure that the listener is
Ora-12541 Tns No Listener Windows
up and listening on the address[edit] For example if you want to connect to the instance with SID=ORCL on a computer named TAMIN_NT using TCP protocol on PORT=1521 then it means that http://stackoverflow.com/questions/13358656/oracle-client-ora-12541-tnsno-listener a listener has to be associated with SID = ORCL on machine TAMIN_NT and be listening for TCP protocol on port 1521. The listener must be up and running when one requests a connection. To check that the listener is up and running use operating system facilities (like Start -> Settings -> Control Panel -> Services under NT) or LSNRCTL (Listener Control Program.) The http://www.orafaq.com/wiki/ORA-12541 STATUS command of LSNRCTL shows the current state of the listener. If the listener is up and running then it may not have been associated with correct instance or not listening for the specified protocol. This information is the Listener Parameter File ( a text file) usually located under ORACLE_HOME\Network|Admin with the name of listener.ora. The STATUS command of LSNRCTL also shows the current location of this file. However, in my personal experience a STOP and START command in LSNRCTL is required for the STATUS command to show latest changes, especially when there are multiple Oracle homes on the same computer. The listener parameter file consists of two parts. The first part is the specification of the protocols for which this listener is listening, and the second part specifies the instances to which this listener is attached. Check and make sure that they are correct. You may edit listener.ora file either by an ordinary text editor or by using the Oracle Net8 Assistant utility. Just keep in mind that a restart of the listener is required for the changes to be effective. Here is an example listener.ora file: # F
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login https://www.experts-exchange.com/questions/21336666/Oracle-ODBC-Ora-ORA-12541-TNS-No-Listener.html Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > [Oracle][ODBC][Ora]ORA=12541: TNS No Listener Want to Advertise Here? Solved [Oracle][ODBC][Ora]ORA=12541: TNS No Listener Posted on 2005-03-03 Oracle Database 3 Verified Solutions 11 Comments 13,243 Views Last Modified: 2012-06-21 SQLSTATE=S1000 [Oracle][ODBC][Ora]ORA=12541: TNS No Listener I have problem connecting to my Oracle 9i Server using oracle ODBC driver Everything was working fine until I installed vodafone's mobile connect software for no listener my UMTS Wreless-LAN PC Card. I searched thru expert site for a solution, but I ma lost. I tried following commands sqlplus /nolog SQL> sys/change_on_install as sysdba I get protocol adapter error My tnsnames.ora file: .. .. ORAGLOB.companyname.net = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xpps09)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oraglob) tns no listener ) ) -- My memory is full and cannot start any applications. From my task manager I see many proccesses have been started twice (ex: apache.exe ). I have no clue whats happening with my oracle installation. Please help. Thank you 0 Question by:veshan Facebook Twitter LinkedIn Google LVL 76 Active today Best Solution byslightwv (䄆 Netminder) Just for grins. Bind a specific ip address to a NIC and change ALL oracle configs to use ipaddress instead of hostname (even if it's the loopback ip). So: in all tnsname.ora/listener.ora change: Go to Solution 11 Comments Message Author Comment by:veshan2005-03-03 # LISTENER.ORA Network Configuration File: C:\Installations\oracle\ora92\network\admin\listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xpps09)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\Installations\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = oraglob) (ORACLE_HOME = C:\Installations\oracle\ora92) (SID_NAME = oraglob) ) ) ---- C:>lsnrctl status say