From oracle-l-bounce@freelists.org Tue Mar 30 12:36:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2UIaZQ16392 for ; Tue, 30 Mar 2004 12:36:35 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2UIaYo16386 for ; Tue, 30 Mar 2004 12:36:35 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6DCEE6352BE; Tue, 30 Mar 2004 13:32:52 -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 30547-85; Tue, 30 Mar 2004 13:32:52 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B00F763441A; Tue, 30 Mar 2004 13:32:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 30 Mar 2004 13:31:41 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE15C6351DB for ; Tue, 30 Mar 2004 13:31:40 -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 30453-54 for ; Tue, 30 Mar 2004 13:31:40 -0500 (EST) Received: from FTWP03NS.br-inc.net (unknown [155.191.252.219]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BC97C635214 for ; Tue, 30 Mar 2004 13:31:36 -0500 (EST) Received: from Unknown [155.191.21.227] by FTWP03NS.br-inc.net - SurfControl E-mail Filter (4.7); Tue, 30 Mar 2004 12:39:48 -0600 Message-ID: <75DFF91B31A1284992092BDB70C9232401ABE116@ftwp45ns.br-inc.net> From: "Thomas Biju" To: Date: Tue, 30 Mar 2004 12:39:38 -0600 Subject: Disconnect from SQL*Plus takes more than 30 seconds MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 X-MS-Has-Attach: X-MS-TNEF-Correlator: content-class: urn:content-classes:message Thread-Topic: Disconnect from SQL*Plus takes more than 30 seconds Thread-Index: AcQWhmDi+XOidczORAWHrI2nUT1SDQ== X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2090 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: BThomas@br-inc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Server Sun Solaris 2.8 Oracle8i 8.1.7.4 I have about 12 databases installed on the Oracle8i oracle home. One of the database takes more than 30 seconds to disconnect from SQL*Plus, when connected using SQL*Net. Connections using ORACLE_SID work fine, no issues. Tried changing the host name to IP address in the listener.ora and tsnames.ora files, but did not help. Any insight would be highly appreciated. Please give me ideas to how to approach this issue.... Thanks, Biju Thomas Database Administrator _____________________________________________________________________________________________________________ This electronic transmission and any attached files are intended solely for the person or entity to which they are addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Any review, retransmission, dissemination or other use, including taking any action concerning this information by anyone other than the named recipient, is strictly prohibited. If you are not the intended recipient or have received this communication in error, please immediately notify the sender and destroy this communication. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------