Question re listener

From: Bill Wagman <wjwagman_at_ucdavis.edu>
Date: Wed, 02 May 2001 18:21:03 -0700
Message-ID: <F001.002F7EA2.20010502182024@fatcity.com>

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)(KEY=dbis2.ucdavis.edu)) 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>
(ADDRESS=(PROTOCOL=tcp)(HOST=regulus)(PORT=46895))
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:
   ERROR:
   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.

Thanks.

Bill Wagman
Univ. of California at Davis
Information Resources
wjwagman_at_ucdavis.edu
(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: http://www.orafaq.com
-- 
Author: Bill Wagman
  INET: wjwagman_at_ucdavis.edu

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: ListGuru_at_fatcity.com (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