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@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@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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
