From oracle-l-bounce@freelists.org Wed Oct 26 09:20:38 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9QEKcDP014524 for ; Wed, 26 Oct 2005 09:20:38 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9QEKMvX014464 for ; Wed, 26 Oct 2005 09:20:22 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E8AB420D928; Wed, 26 Oct 2005 09:20:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12177-07; Wed, 26 Oct 2005 09:20:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 689B420F2A3; Wed, 26 Oct 2005 09:20:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 26 Oct 2005 09:18:20 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 141A420EF87 for ; Wed, 26 Oct 2005 09:18:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11735-06 for ; Wed, 26 Oct 2005 09:18:19 -0500 (EST) Received: from webmailv3.ispgateway.de (webmailv3.ispgateway.de [80.67.16.113]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4439F20EC3A for ; Wed, 26 Oct 2005 09:18:19 -0500 (EST) Received: from localhost (webmailv3.ispgateway.de [127.0.0.1]) by webmailv3.ispgateway.de (8.12.8/8.12.8) with ESMTP id j9QEII0Z026474 for ; Wed, 26 Oct 2005 16:18:18 +0200 Received: from p54AFEBD8.dip.t-dialin.net (p54AFEBD8.dip.t-dialin.net [84.175.235.216]) by domainfactory-webmail.de (IMP) with HTTP for <515854@localhost>; Wed, 26 Oct 2005 16:18:18 +0200 Message-ID: <1130336298.435f902a5f295@www.domainfactory-webmail.de> Date: Wed, 26 Oct 2005 16:18:18 +0200 From: Stephan Eichenlaub To: oracle-l@freelists.org Subject: 8.1.7 connection problems MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 User-Agent: Internet Messaging Program (IMP) 3.2.8 X-Originating-IP: 84.175.235.216 X-archive-position: 27603 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: stephan@eichenlaub.net Precedence: normal Reply-To: stephan@eichenlaub.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.9 required=5.0 tests=BAYES_00 autolearn=ham version=2.63 Hi, every once in a while (maybe once in two months) a customer has connection problems to his production database. Version is 8.1.7. Setup is a database server (linux) and a windows server that runs the application (and several clients connecting to the application but that's of no importance here). The connection failure only seems to occur at night. After maintenance the database is started up again, then has about 30 minutes of idle time, gets a tnsping 10 to wake up the connection - and right after the tnsping sqlplus gets an error. In the batch these commands are issued right after another: ------------- start here ------------ tnsping mySID 10 >> mylog sqlplus -s system/password@mySID @switch_logfile.sql >> mylog ------------- end here ------------- The result usually is that things work like intended but sometimes it doesn't. The logfile mylog shows: ------------- start here ------------ TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 25-OKT-2005 22:00:00 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.211)(PORT=1521)) OK (40 msec) OK (40 msec) OK (0 msec) OK (0 msec) OK (0 msec) OK (0 msec) OK (0 msec) OK (0 msec) OK (0 msec) OK (0 msec) ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory ------------------ end here ------------- The tnsping seems to have helped making the connection error happen less often - but apparently it's not the solution to the problem as in the example above it reports 10 fine pings - and right after that the connection can't be established. What could be the reason, where would you start looking? In the oracle logfiles on the database server nothing shows up, not even a connection attempt. Strangely enough, I haven't found a recent sqlnet.log on the machine that runs the script. Stephan Eichenlaub -- ----------------------------------------------------------------------- Stephan Eichenlaub xx49-261-9141500 St.-Josef-Platz 10 xx49-162-9068888 D-56068 Koblenz http://www.eichenlaub.net ----------------------------------------------------------------------- -- http://www.freelists.org/webpage/oracle-l