Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Question re listener

Question re listener

From: Bill Wagman <>
Date: Wed, 02 May 2001 18:21:03 -0700
Message-ID: <>

On system A I am running oracle 8.1.7 on Solaris 5.7. I have a listener.ora file which specifies port 1521. I start the listener. After about 1 to 2 minutes the PMON process registers the second listener and things look like this...

LSNRCTL> services
Connecting to (ADDRESS=(PROTOCOL=IPC)( Services Summary...
dbis2 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0 LOCAL SERVER
dbis2 has 2 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 <machine: regulus, pid: 19474>
DEDICATED SERVER established:0 refused:0 LOCAL SERVER
The command completed successfully
LSNRCTL> The tnsnames file on system B running 8.1.6 on solaris 7 specifies port 1521 on system A. From system B in sqlplus connect scott_at_dbis2 (dbis2 is on system a) will allow a connection immediately after the listener on system A is started. After the listener on system A has been running for a minute or two and the second listener has been started I receive the following...

SQL > connect scott_at_dbis2

   Enter password:
   ORA-12451: TNS:nolistener
   Warning: You are no longer connected to ORACLE.

If however I now change the specified port in the tnsnames on system B to 46895 I am able to connect.

I don't understand why the services are starting as they are and why, once the second service is started I am unable to connect via sqlplus. On other systems I look at each listener only has one service handler. The 2 service handlers on the second listener seems to be the problem.

I don't understand what is going on here and any help would be greatly appreciated.


Bill Wagman
Univ. of California at Davis
Information Resources
(530) 754-6208

I like to pick up hitchhikers. When they get in the car I say, 'Put on your seat belt. I want to try something. I saw it once in a cartoon, but I think I can do it.'
- Steven Wright
Please see the official ORACLE-L FAQ:
Author: Bill Wagman

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed May 02 2001 - 20:21:03 CDT

Original text of this message