Home » RDBMS Server » Networking and Gateways » lsnrctl start hangs on Oracle 8.1.7 / Solaris 8
lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #66312] Sat, 23 March 2002 08:11 Go to next message
Iwao Hatanaka
Messages: 1
Registered: March 2002
Junior Member
I am running Oracle 8.1.7 on Solaris 8.
"lsnrctl start" hangs following the "Connecting to ... " message and does not display the status
of the listener:
=====================================================
bash-2.03$ lsnrctl start

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 23-MAR-2002 12:55:39

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Starting /opt/oracle/product/8.1.7/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
System parameter file is /opt/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /opt/oracle/product/8.1.7/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.124.250)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cambridge)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
=====================================================

If I run truss on the lsnrctl start, it appears
to be "sleeping" on the "read" call below:
=====================================================
LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 23-MAR-2002 12:22:27write(1, "n L S N R C T L f o r".., 76) = 76

(c) Copyright 1998 Oracle Corporation. All rights reserved.

write(1, "nn ( c ) C o p y r i".., 64) = 64
getrlimit(RLIMIT_NOFILE, 0xFFBEE7B0) = 0
setrlimit(RLIMIT_NOFILE, 0xFFBEE7B0) = 0
brk(0x0007F2F0) = 0
brk(0x0008F2F0) = 0
brk(0x0008F2F0) = 0
brk(0x0009F2F0) = 0
brk(0x0009F2F0) = 0
brk(0x000AF2F0) = 0
brk(0x000AF2F0) = 0
brk(0x000BF2F0) = 0
brk(0x000BF2F0) = 0
brk(0x000FF2F0) = 0
brk(0x000FF2F0) = 0
brk(0x001072F0) = 0
getuid() = 400 [[400]]
open64("/etc/.name_service_door", O_RDONLY) = 3
fcntl(3, F_SETFD, 0x00000001) = 0
door_info(3, 0xFEABE7A0) = 0
close(3) = 0
open("/etc/nsswitch.conf", O_RDONLY) = 3
fstat64(3, 0xFFBEA0D8) = 0
brk(0x001072F0) = 0
brk(0x001092F0) = 0
ioctl(3, TCGETA, 0xFFBEA064) Err#25 ENOTTY
read(3, " #n # / e t c / n s s".., 8192) = 1639
read(3, 0x001063CC, 8192) = 0
llseek(3, 0, SEEK_CUR) = 1639
close(3) = 0
open("/usrlib/nss_files.so.1", O_RDONLY) Err#2 ENOENT
open("/usr/dt/lib/nss_files.so.1", O_RDONLY) Err#2 ENOENT
open("/usr/openwin/lib/nss_files.so.1", O_RDONLY) Err#2 ENOENT
open("/opt/oracle/product/8.1.7/lib/nss_files.so.1", O_RDONLY) Err#2 ENOENT
open("/usr/lib/nss_files.so.1", O_RDONLY) = 3
fstat(3, 0xFFBE9BA4) = 0
mmap(0x00000000, 8192, PROT_READ&#124PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF320000
mmap(0x00000000, 98304, PROT_READ&#124PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFE9E0000
mmap(0xFE9F6000, 1770, PROT_READ&#124PROT_WRITE&#124PROT_EXEC, MAP_PRIVATE&#124MAP_FIXED, 3, 24576) = 0xFE9F6000
munmap(0xFE9E6000, 65536) = 0
memcntl(0xFE9E0000, 6936, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3) = 0
munmap(0xFF320000, 8192) = 0
open("/etc/passwd", O_RDONLY) = 3
fstat64(3, 0xFFBEA008) = 0
brk(0x001092F0) = 0
brk(0x0010B2F0) = 0
ioctl(3, TCGETA, 0xFFBE9F94) Err#25 ENOTTY
read(3, " r o o t : x : 0 : 0 : S".., 8192) = 527
llseek(3, 0xFFFFFFFFFFFFFFC5, SEEK_CUR) = 468
close(3) = 0
uname(0xFF2AED68) = 1
access("/var/tmp/.oracle", 0) = 0
so_socket(1, 2, 0, "", 1) = 3
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
poll(0x00000000, 0, 0) = 0
close(3) = 0
so_socket(1, 2, 0, "", 1) = 3
connect(3, 0xFFBE9888, 110, 1) Err#146 ECONNREFUSED
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
close(3) = 0
access("/opt/oracle/product/8.1.7/network/admin/protocol.ora", 0) Err#2 ENOENT
access("/opt/oracle/product/8.1.7/network/admin/protocol.ora", 0) Err#2 ENOENT
so_socket(2, 2, 0, "", 1) = 3
connect(3, 0xFFBE9774, 16, 1) Err#146 ECONNREFUSED
close(3) = 0
open("/opt/oracle/product/8.1.7/network/mesg/tnsus.msb", O_RDONLY) = 3
fcntl(3, F_SETFD, 0x00000001) = 0
lseek(3, 0, SEEK_SET) = 0
read(3, "1513 "011303tt".., 256) = 256
lseek(3, 512, SEEK_SET) = 512
read(3, " 19B".., 512) = 512
lseek(3, 1024, SEEK_SET) = 1024
read(3, "t121A & - F".., 166) = 166
lseek(3, 19456, SEEK_SET) = 19456
read(3, "1004 & h04 '".., 512) = 512
Starting /opt/oracle/product/8.1.7/bin/tnslsnr: please wait...

write(1, " S t a r t i n g / o p".., 64) = 64
pipe() = 4 [[5]]
pipe() = 6 [[7]]
fork1() = 26031
sigfillset(0xFEABE928) = 0
sigprocmask(SIG_BLOCK, 0xFFBEBEE4, 0x00000000) = 0
sigaction(SIGPIPE, 0xFFBEBCE8, 0xFFBEBE34) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBEBEDC, 0x00000000) = 0
waitid(P_PID, 26031, 0xFFBEBE98, WEXITED&#124WTRAPPED) = 0
close(4) = 0
close(7) = 0
read(6, " N T P 0 2 6 0 3 2n", 64) = 11
getpid() = 26030 [[26029]]
fcntl(6, F_SETFD, 0x00000001) = 0
getpid() = 26030 [[26029]]
write(5, "B60101 601 ,".., 182) = 182
brk(0x0010B2F0) = 0
brk(0x0010D2F0) = 0
read(6, " 0201 6".., 2064) = 528
TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
System parameter file is /opt/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /opt/oracle/product/8.1.7/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.124.250)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cambridge)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
write(1, " T N S L S N R f o r ".., 486) = 486

write(1, "n", 1) = 1
close(5) = 0
close(6) = 0
getuid() = 400 [[400]]
open64("/etc/.name_service_door", O_RDONLY) = 4
fcntl(4, F_SETFD, 0x00000001) = 0
door_info(4, 0xFEABE7A0) = 0
close(4) = 0
open("/etc/passwd", O_RDONLY) = 4
fstat64(4, 0xFFBEA008) = 0
brk(0x0010D2F0) = 0
brk(0x0010F2F0) = 0
ioctl(4, TCGETA, 0xFFBE9F94) Err#25 ENOTTY
read(4, " r o o t : x : 0 : 0 : S".., 8192) = 527
llseek(4, 0xFFFFFFFFFFFFFFC5, SEEK_CUR) = 468
close(4) = 0
lseek(3, 18944, SEEK_SET) = 18944
read(3, "0F0415 b0416".., 512) = 512
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
write(1, " C o n n e c t i n g t".., 66) = 66
so_socket(1, 2, 0, "", 1) = 4
access("/var/tmp/.oracle/sEXTPROC", 0) = 0
connect(4, 0xFFBE9888, 110, 1) = 0
fcntl(4, F_SETFD, 0x00000001) = 0
sigaction(SIGPIPE, 0xFFBE9C58, 0xFFBE9DA4) = 0
getpid() = 26030 [[26029]]
write(4, "C70101 601 ,".., 199) = 199
read(4, 0x00109E8E, 2064) (sleeping...)
=====================================================

Can anyone tell me what lsnrctl is trying to read
and why it can't finish the read?

NOTE that TNS_ADMIN env var is correctly set to
$ORACLE_HOME/network/admin and changes to listener.ora
to use just the IP address yields the same hang.

Thanx in advance for any help!

Regards,
Iwao
Re: lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #66397 is a reply to message #66312] Fri, 17 May 2002 03:28 Go to previous messageGo to next message
upadhya
Messages: 2
Registered: February 2002
Junior Member
If Some one has the Answer of the same query,Pl^z
mail me at the above email-id.
Thanking so much.
Re: lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #66535 is a reply to message #66312] Thu, 25 July 2002 08:22 Go to previous messageGo to next message
Jeff
Messages: 63
Registered: July 1999
Member
I have the same issue....was there ever a resolution????
Re: lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #66566 is a reply to message #66312] Thu, 01 August 2002 09:02 Go to previous messageGo to next message
birgit
Messages: 1
Registered: August 2002
Junior Member
Hallo,

I have the same Problem.
And I have installed Oracle 8.1.7 on Solaris 8 on several machines without any problems. And on this server the listener hangs. We have an Netscape Directory Server(ldap) on the same machine. When we stop the Directory Server the listener works fine. We don't find a solution yet. It has nothing to do with the ports.

Regards,
Birgit
Re: lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #66616 is a reply to message #66312] Mon, 02 September 2002 13:30 Go to previous messageGo to next message
Vander Carvalho Moura e S
Messages: 1
Registered: September 2002
Junior Member
I solve this problem removing the Q files on $ORACLE_HOME/network/agent and restarting the Agent.
Re: lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #66805 is a reply to message #66535] Mon, 20 January 2003 04:17 Go to previous messageGo to next message
Gaurab
Messages: 1
Registered: January 2003
Junior Member
The simplest approach is:

1. Kill the hanging listener
2. rm -rf "/var/tmp/.oracle"
3. Restart the listener

I cannot explain the why part here.
Re: lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #67364 is a reply to message #66805] Thu, 03 June 2004 12:08 Go to previous messageGo to next message
Shawn Leard
Messages: 1
Registered: June 2004
Junior Member
The reason for this problem is the files created in /var/tmp/.oracle are sockets. When the listener is killed unexpectedly these files are not cleared, the next time the listener starts and checks this directory, it finds sockets already present, and than aborts because it thinks it is already running.

Best Regards
Shawn Leard
SLeard at acm.org
Re: lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #232738 is a reply to message #67364] Mon, 23 April 2007 02:40 Go to previous message
rsaluja
Messages: 1
Registered: April 2007
Junior Member
Hello,

My truss ( with option -d) is as follows while starting the listener on 8174. Solaris 5.8 box.

If you see it took almost 3.5 minutes to complete [ connect(3, 0xFFFFFFFF7FFF91AC, 16, 1) (sleeping...) ] operation. Anyone have any idea about the root cause . No connections were trying the connect to the database while listener was coming up . All the files in /var/tmp/.oracle were removed .

Any help will be appreciated

Thanks
Rajesh


0.1215 brk(0x100280C70) = 0
0.1221 brk(0x100284C70) = 0
0.1229 so_socket(1, 2, 0, "", 1) = 3
0.1246 access("/var/tmp/.oracle/sTEST", 0) Err#2 ENOENT
0.1249 access("/var/tmp/o/sTEST", 0) Err#2 ENOENT
0.1261 close(3) = 0
0.1284 access("/oracle/MISC01/home/product/8.1.7.4/network/admin/protocol.ora", 0) Err#2 ENOENT
0.1290 0.0006 so_socket(2, 2, 0, "", 1) = 3
connect(3, 0xFFFFFFFF7FFF91AC, 16, 1) (sleeping...)
224.7477 224.6187 connect(3, 0xFFFFFFFF7FFF91AC, 16, 1) Err#145 ETIMEDOUT
224.7490 0.0013 close(3) = 0
224.7500 0.0010 open("/oracle/MISC01/home/product/8.1.7.4/ocommon/nls/admin/data/lx20001.nlb", O_RDONLY) = 3
224.7513 0.0013 read(3, " Z Z\0\00210\0\0\002\0\0".., 100) = 100
224.7520 0.0007 read(3, "\001\01F\0\t\0\0\0\0 ?\0".., 5596) = 5593
224.7527 0.0007 close(3) = 0
224.7535 0.0008 open("/oracle/MISC01/home/product/8.1.7.4/network/mesg/tnsus.msb", O_RDONLY) = 3
224.7543 0.0008 fcntl(3, F_SETFD, 0x00000001) = 0
224.7549 0.0006 lseek(3, 0, SEEK_SET) = 0
Previous Topic: Listener issue
Next Topic: Managing databases on multiple domains
Goto Forum:
  


Current Time: Sun Dec 04 12:42:41 CST 2016

Total time taken to generate the page: 0.05243 seconds