OraFAQ Forum: Networking and Gateways » lsnrctl start hangs on Oracle 8.1.7 / Solaris 8

Home » RDBMS Server » Networking and Gateways » lsnrctl start hangs on Oracle 8.1.7 / Solaris 8

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

lsnrctl start hangs on Oracle 8.1.7 / Solaris 8 [message #66312]

Sat, 23 March 2002 08:11

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

Report message to a moderator

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

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.

Report message to a moderator

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

Jeff
Messages: 63
Registered: July 1999

Member

I have the same issue....was there ever a resolution????

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Listener issue
Next Topic:	Managing databases on multiple domains

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:06:52 CDT 2024