From oracle-l-bounce@freelists.org Mon Aug 16 09:42:00 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i7GEg0x17853 for ; Mon, 16 Aug 2004 09:42:00 -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 i7GEfxI17845 for ; Mon, 16 Aug 2004 09:41:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6C14172C8CD; Mon, 16 Aug 2004 09:47:06 -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 28069-67; Mon, 16 Aug 2004 09:47:06 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ADEA872C03F; Mon, 16 Aug 2004 09:47:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 16 Aug 2004 09:45: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 F2C9D72C01C for ; Mon, 16 Aug 2004 09:45:38 -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 27976-46 for ; Mon, 16 Aug 2004 09:45:38 -0500 (EST) Received: from web41505.mail.yahoo.com (web41505.mail.yahoo.com [66.218.93.88]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 7303B72C042 for ; Mon, 16 Aug 2004 09:45:34 -0500 (EST) Message-ID: <20040816144603.36761.qmail@web41505.mail.yahoo.com> Received: from [24.8.4.219] by web41505.mail.yahoo.com via HTTP; Mon, 16 Aug 2004 07:46:03 PDT Date: Mon, 16 Aug 2004 07:46:03 -0700 (PDT) From: Scott Subject: Re: Fist time poster... Q: 10g lsnrctl troubles... To: oracle-l@freelists.org Cc: ian@south-border.com 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: 7625 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: oraracdba@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Please check the /etc/system on the machine and verify that shmsys:shminfo_shmmin *is not* set to a value greater than 1. There is a bug in 10g and listener will give you those errors if shmsys:shminfo_shmmin is > 1 and your is set to > 1. I had the same problem once I changed shmsys:shminfo_shmmin the problem went away. Scott --- The UnSeen wrote: > > I recently upgraded some databases from 9i to 10g. > In an attempt to punt > on the 9i listener - I attempted to start the 10g > version of the listener > which is producing the following error: > > -----paste > > lsnrctl start > > LSNRCTL for Solaris: Version 10.1.0.2.0 - Production > on 15-AUG-2004 > 15:13:03 > > Copyright (c) 1991, 2004, Oracle. All rights > reserved. > > Starting > /data/oracle/app/oracle/product/10g/bin/tnslsnr: > please wait... > > TNSLSNR for Solaris: Version 10.1.0.2.0 - Production > Log messages written to > /data/oracle/app/oracle/product/10g/network/log/listener.log > Listening on: > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host.place.com)(PORT=1521))) > > Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)) > TNS-01114: LSNRCTL could not perform local OS > authentication with the > listener > > -----/paste > > Looking into the logs I see: > > -----paste > TNSLSNR for Solaris: Version 10.1.0.2.0 - Production > on 15-AUG-2004 > 15:13:03 > > Copyright (c) 1991, 2004, Oracle. All rights > reserved. > > Log messages written to > /data/oracle/app/oracle/product/10g/network/log/listener.log > Trace information written to > /data/oracle/app/oracle/product/10g/network/trace/listener.trc > Trace level is currently 0 > > Started with pid=524 > Listening on: > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host.place.com)(PORT=1521))) > > TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT > [* SID] * RETURN CODE > 15-AUG-2004 15:13:03 * > (CONNECT_DATA=(CID=(PROGRAM=)(HOST=host)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=168821248)) > > * status * 1189 > TNS-01189: The listener could not authenticate the > user > TNS-12537: TNS:connection closed > TNS-12560: TNS:protocol adapter error > TNS-00507: Connection closed > -----/paste > > I've read on this list that it might be a > shared_memory_pool problem, So I > think I've maxed out the mount of shared memory. > This is a Sun Fire V240 > with 8G RAM, so /etc/system has: > > *set shmsys:shminfo_shmmax=268435456 > *set shmsys:shminfo_shmmax=4294967295 > set shmsys:shminfo_shmmax=8254455808 > set shmsys:shminfo_shmmin=200 > *set shmsys:shminfo_shmmni=200 > set shmsys:shminfo_shmmni=1024 > set shmsys:shminfo_shmseg=1024 > set semsys:seminfo_semmap=250 > set semsys:seminfo_semmni=500 > set semsys:seminfo_semmsl=500 > set semsys:seminfo_semmns=2000 > set semsys:seminfo_semmnu=500 > set semsys:seminfo_semume=100 > set semsys:seminfo_semvmx=32767 > set semsys:seminfo_semopm=100 > set noexec_user_stack = 1 > > I am totally at a loss as to what the issue might be > save some new tags > needed in listener.ora... Any pointers/help more > than welcome... > > Ian > ian@south-border.com > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! 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 -----------------------------------------------------------------