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

From: The UnSeen <ian_at_south-border.com>
Date: Sun, 15 Aug 2004 15:42:34 -0400 (EDT)
Message-ID: <Pine.GSO.4.60.0408151532070.12595@sandbox.south-border.com>

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

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

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
-----------------------------------------------------------------

Received on Sun Aug 15 2004 - 14:38:49 CDT