Ora 29260 Network Error No Listener
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ora-29260: network error: tns:operation timed out ORA-29260: network error: TNS: lost contact ExpertOra-29260 Network Error Not Connected
Oracle Database Tips by Burleson Consulting August 27, 2015 Question: I am getting the ORA-29260 error when attempting to connect to ora-29260: network error: tns:connection closed my Oracle instance: ORA-29260: network error: TNS:lost contact How do I resolve the ORA-29260 error? Answer: The ORA-29260 is a sporadic error, the code works fine when the traffic is slow and fails when
Ora-29260 Utl_tcp
network traffic is high. The ORA-29260 error is almost due to a firewall or a slow network where high packet rates cause high network latency. There are only a few options to fic a ORA-29260 error: - Tune your TNS network layer - Install a faster network like Dark Fiber - Check for blocked ports or firewalls - Consider trying the tcp.nodelay setting in your protocol.ora file. The documentation ora-29260 ftp notes this on the ORA-029260 error: ORA-29260: network error tips Cause: A network error occurred. Action: Fix the network error and retry the operation Get the Complete Oracle SQL Tuning Information The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remo
2008 06:57 shahnazurs Messages: 240Registered: June 2005 Location: India Senior Member Hi. I can able to send mail from the unix using mailx command but when I use the http://www.orafaq.com/forum/t/96062/ following snippet in sql*plus tool, it is showing network error. declare c utl_tcp.connection; a exception; pragma exception_init(a,-29260); begin c := utl_tcp.open_connection('127.0.0.1', 25); dbms_output.put_line('Opened Successfully'); utl_tcp.close_connection(c); exception when a then http://stackoverflow.com/questions/13358656/oracle-client-ora-12541-tnsno-listener dbms_output.put_line('Network Error'); when others then dbms_output.put_line('Other Error'||chr(10)||sqlerrm); end; Please let me know whether some service has to run in UNIX to use utl_tcp package? Thanks. Report message to a moderator network error Re: SMTP service [message #295473 is a reply to message #295466] Tue, 22 January 2008 07:14 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator In 9i, use utl_smpt. Search on AskTom there are several threads on this subject there. Regards Michel Report message to a moderator Re: SMTP service 29260 network error [message #295479 is a reply to message #295473] Tue, 22 January 2008 07:38 shahnazurs Messages: 240Registered: June 2005 Location: India Senior Member Thanks Michel for your reply. My production box is running with the same configuration like oracle 9i,SunOs but I can use this package with out any problem! Thanks. Report message to a moderator Re: SMTP service [message #295481 is a reply to message #295479] Tue, 22 January 2008 07:42 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator You didn't post the error, how are we supposed to know it? Regards Michel Report message to a moderator Re: SMTP service [message #295489 is a reply to message #295481] Tue, 22 January 2008 08:09 shahnazurs Messages: 240Registered: June 2005 Location: India Senior Member Hi Michel, Please have a look at the source and error. SQL> declare 2 c utl_tcp.connection; 3 begin 4 c := utl_tcp.open_connection('localhost', 25); 5 dbms_output.put_line('Opened Successfully'); 6 utl_tcp.close_connection(c); 7 end; 8 . SQL> / declare * ERROR at line 1: ORA-29260: network error
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 Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the 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] 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 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 Adapter could not es