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

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 16 Aug 2004 07:26:58 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D60E9AE6D6@EXCHMN3>

Dear Unseen
Since nobody seems to have replied to your posting (perhaps they didn't see you), I'll provide a wild idea. You suspect the listener isn't starting because there aren't enough system resources. You could check that by shutting down any databases, then starting the listener.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive." -- C.S. Lewis

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of The UnSeen Sent: Sunday, August 15, 2004 2:43 PM
To: Oracle-L_at_freelists.org
Subject: Fist time poster... Q: 10g lsnrctl troubles...

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)(ARGUM ENTS=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
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 07:27:14 CDT