Re: Fist time poster... Q: 10g lsnrctl troubles...

From: Scott <oraracdba_at_yahoo.com>
Date: Mon, 16 Aug 2004 07:46:03 -0700 (PDT)
Message-ID: <20040816144603.36761.qmail@web41505.mail.yahoo.com>

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 <ian_at_south-border.com> 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_at_south-border.com
>

> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>

> To unsubscribe send email to:
> oracle-l-request_at_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_at_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
-----------------------------------------------------------------

Received on Mon Aug 16 2004 - 09:42:00 CDT