Error 12541 Encountered
Contents |
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 ora-12541 tns no listener error Freelance Project Hire for a Full Time Job Ways to Get Help
Ora-12541 Tns No Listener 11g
Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing
Tns No Listener Error In Oracle 11g
Store Headlines Experts Exchange > Questions > ORACLE error 12541 encountered Want to Advertise Here? Solved ORACLE error 12541 encountered Posted on 2009-06-04 Oracle Database Linux Distributions 3 Verified Solutions
Tns-12560: Tns:protocol Adapter Error
19 Comments 2,413 Views Last Modified: 2013-12-18 I've done a full search on the site and this site and others and think I might have a unique problem. I'm running Oracle 10g on a RHEL5 machine. The TNS:no listener error was encountered when trying to import a .dmp file. I have double checked my tnsnames.ora and listener.ora files to make sure ora 12541 tns no listener toad that the fully qualified domain name is correctly entered. Also, it is not a problem with the /etc/hosts file. When I type hostname at the command prompt it gives me a valid FQDN. When I log in to the enterprise management web page on the server, it shows localhost.localdomain for Host and LISTENER localhost.localdomain for Listener. On all my other RHEL5 Oracle 10g boxes this has never been an issue. Is there another place where I need to enter the FQDN? lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-JUN-2009 10:26:57 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 04-JUN-2009 10:25:16 Uptime 0 days 0 hr. 1 min. 40 sec Trace Level off Security ON: Local OS Authentication SNMP ON Listener Parameter File /oracle/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /oracle/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1522))) Services Summary... Servic
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data ora-12541: tns:no listener linux Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ora 12541 tns no listener oracle 11g client ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum tns-12541: tns:no listener linux All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats https://www.experts-exchange.com/questions/24464582/ORACLE-error-12541-encountered.html | Start a new thread | All threads | Best last month | No question at this time DBA Top 10 1 M. Cadot 37400 2 F. Diaz 33800 3 J. Schnackenberg 18400 4 B. Vroman 16350 5 A. Kavsek 15950 6 P. Wisse 14750 7 T. Boles 14400 8 M. Hidayathullah ... 11500 9 A. Hudspith http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=13499 8600 10 A. Khan 4400 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47779Total active users2112Act. users last 24h3Act. users last hour2Registered user hits last week561Registered user hits last month6457 Go up Dump file import error. Next thread: Ref Cursor For a Cursor Prev thread: index - nologging Message Score Author Date Hello DBA's i am trying to import a dump file from...... Saud Ansari Jul 20, 2005, 13:09 Hi The problem has nothing to do with import un...... Nick Havard Jul 20, 2005, 13:22 Hi I think that the syntax of imp command if...... Demetrios Gogos Jul 21, 2005, 14:49 Follow up by mail Click here Subject: Dump file import error. Author: Saud Ansari, Oman Date: Jul 20, 2005, 13:09, 4099 days ago Os info: Windows Xp Oracle info: Oracle 9i Error info: Import error. Message: Hello DBA's i am trying to import a dump file from oracle 9i, but
Anil Kumar on June 26, 2013 All Posts, Database, Oracle DBA 17 Comments Resolved ORA-12541: TNS no listener error 4.57 http://itbloggertips.com/2013/06/resolved-ora-12541-tns-no-listener-error/ (91.43%) 7 votes N no. of articles you will find http://www.verycomputer.com/159_2550333ba0057b18_1.htm 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 while working on Oracle 10g database then I no listener 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 show the current status of your listener. Step-2: Start the listener, tns no 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 thing which you have to do. Open sqlnet.ora file and make the changes as suggested. Change NTS to NONE SQLNET.AUTHENTICATION_SER
all setup, and I can connect to all the databases on my server fine using SQL Plus, Enterprise Manager, SQL Plus Worksheet and by "testing" the connection inside of Net Manager. However, once i try doing an import or export (using exp/imp commands) I get a EXP-00056: ORACLE error 12541 encountered ORA-12541: TNS:no listener EXP-00000: Export terminated unsuccessfully It even gets stranger.. Using an application developed in Powerbuilder.... When running off of source code, it can connect to the database fine. However, if I compile the code into exe and run off of there, i get the No Listener error. They both connect using the Oracle native driver and read how to connect off of the same ini file. No-one else in my office has this problem. What could be wrong with my setup? Any help appreciated -- Luciano Belotto replace spam with traxsoftware for e-mail Top error 12541 - strange error on TNS: no listener by Daniel Morga » Wed, 19 Jun 2002 04:31:43 > been getting a strange error here, > I have my Tnsnames.ora file all setup, and I can connect to all the > databases on my server fine using SQL Plus, Enterprise Manager, SQL Plus > Worksheet and by "testing" the connection inside of Net Manager. However, > once i try doing an import or export (using exp/imp commands) I get a > EXP-00056: ORACLE error 12541 encountered > ORA-12541: TNS:no listener > EXP-00000: Export terminated unsuccessfully > It even gets stranger.. Using an application developed in Powerbuilder.... > When running off of source code, it can connect to the database fine. > However, if I compile the code into exe and run off of there, i get the No > Listener error. They both connect using the Oracle native driver and read > how to connect off of the same ini file. > No-one else in my office has this problem. What could be wrong with my > setup? Any help appreciated > -- > Luciano Belotto > replace spam with traxsoftware for e-mail My suspicion is that you are on UNIX platform and that the .profiles are different. The one you are using for EXP does not have oracle_sid, etc. Daniel Morgan Top error 12541 - strange error on TNS: no listener by Luciano Belott » Wed, 19 Jun 2002 05:38:24 sorry forgot to mention. I'm on Oracle 9i client, servers are both 9i and 8.0.5. Platform is only Win NT 4 and Win 2000. -- Luciano Belotto replace spam with traxsoftware f