Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 29067 invoked from network); 8 Aug 2006 01:19:53 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 01:19:53 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 014163BC802; Tue, 8 Aug 2006 02:19:37 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13254-06; Tue, 8 Aug 2006 02:19:36 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 39A293BC159; Tue, 8 Aug 2006 02:19:36 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 02:18:48 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 181A63BAC63 for ; Tue, 8 Aug 2006 02:18:48 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13096-05 for ; Tue, 8 Aug 2006 02:18:48 -0400 (EDT) Received: from smtp-vbr12.xs4all.nl (smtp-vbr12.xs4all.nl [194.109.24.32]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AABE13BAC36 for ; Tue, 8 Aug 2006 02:18:47 -0400 (EDT) Received: from [10.2.192.199] (dbalert.xs4all.nl [213.84.185.230]) (authenticated bits=0) by smtp-vbr12.xs4all.nl (8.13.6/8.13.6) with ESMTP id k786IvIY084780 for ; Tue, 8 Aug 2006 08:19:02 +0200 (CEST) (envelope-from cjpengel.dbalert@xs4all.nl) Subject: Re: Newbie Q: Do sqlnet.ora changes require server reboot? From: Carel-Jan Engel To: oracle-l@freelists.org In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-gK8x0C8PWyvxaWYFCi0V" Organization: DBA!ert Date: Tue, 08 Aug 2006 08:18:56 +0200 Message-Id: <1155017936.13039.0.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 X-archive-position: 37852 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-to: cjpengel.dbalert@xs4all.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net --=-gK8x0C8PWyvxaWYFCi0V Content-Type: text/plain Content-Transfer-Encoding: 7bit On Mon, 2006-08-07 at 16:06 -0700, Jared Still wrote: > And no, sqlnet.ora changes do not normally require a restart. > At least, I've never encountered a situation where changing > sqlnet.ora required any kind of restart. Except from the listener (the 'listener bounce' the OP mentioned), or even the client process, e.g. if tracing at the client side is enabled. The listener restart may be avoided with the 'reload' option. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === --=-gK8x0C8PWyvxaWYFCi0V Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit On Mon, 2006-08-07 at 16:06 -0700, Jared Still wrote:
And no, sqlnet.ora changes do not normally require a restart.
At least, I've never encountered a situation where changing
sqlnet.ora required any kind of restart.
Except from the listener (the 'listener bounce' the OP mentioned), or even the client process, e.g. if tracing at the client side is enabled.
The listener restart may be avoided with the 'reload' option.


Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===
--=-gK8x0C8PWyvxaWYFCi0V-- -- http://www.freelists.org/webpage/oracle-l