From oracle-l-bounce@freelists.org Mon Jun 28 14:07:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5SJ7SS13826 for ; Mon, 28 Jun 2004 14:07:38 -0500 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 i5SJ7I613808 for ; Mon, 28 Jun 2004 14:07:28 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 32C4272C635; Mon, 28 Jun 2004 13:50:02 -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 23775-84; Mon, 28 Jun 2004 13:50:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 829E772C61F; Mon, 28 Jun 2004 13:50:01 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 28 Jun 2004 13:48:39 -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 557A372C090 for ; Mon, 28 Jun 2004 13:48:39 -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 23643-87 for ; Mon, 28 Jun 2004 13:48:39 -0500 (EST) Received: from web13421.mail.yahoo.com (web13421.mail.yahoo.com [216.136.175.125]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id C0A4672C082 for ; Mon, 28 Jun 2004 13:48:38 -0500 (EST) Message-ID: <20040628191102.95460.qmail@web13421.mail.yahoo.com> Received: from [199.79.222.119] by web13421.mail.yahoo.com via HTTP; Mon, 28 Jun 2004 12:11:02 PDT Date: Mon, 28 Jun 2004 12:11:02 -0700 (PDT) From: Peter Barnett Subject: RE: spfile/listener question To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3859 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: regdba@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org If you specify the database in a listener.ora file the status becomes UNKNOWN when you stat the listener. If you let discovery takes its course the status becomes OK. This is documented on MetaLink. But, there is no explanation as to why this is true. Just gotta trust the 'Oracle Gods'. --- Scott.Shafer@dcpds.cpms.osd.mil wrote: > Already tried it both ways, with the same result. > Metalink is no help so > far. I appreciate the responses - keep 'em coming. > Scott Shafer > > > -----Original Message----- > From: Tanel Põder [mailto:tanel.poder.003@mail.ee] > > Try to set the LOCAL_LISTENER to "DESCRIPTION= > (ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1421))" > instead of tns alias. > > Tanel. > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ===== Pete Barnett Lead Database Administrator The Regence Group pnbarne@regence.com __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- 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 -----------------------------------------------------------------