RE: 8.1.6 Listener Weirdness RESOLVED!

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 15 Aug 2000 15:59:53 -0300
Message-Id: <10590.114646@fatcity.com>

Yes, the listeners can give you grief.

The "sample files" don't help much either.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

	-----Original Message-----
	From:	Koivu, Lisa [SMTP:lkoivu_at_qode.com]
	Sent:	Tuesday, August 15, 2000 4:44 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	FW: 8.1.6 Listener Weirdness RESOLVED!

	My IPC entries were the same for both listeners.  Not good. Once I

renamed my IPC key name the 8.1.6 listener started up just fine... Woo Hoo!

	Thanks everyone
	Lisa
	The 'networkingly challenged' DBA
	Ft. Lauderdale, FL, USA
	
	-----Original Message-----
	From: Koivu, Lisa 
	Sent: Tuesday, August 15, 2000 2:24 PM
	To: 'Joseph S. Testa'
	Cc: Oracle-L (E-mail)
	Subject: RE: 8.1.6 Listener Weirdness
	
	
	Thanks for your reply Joe. 
	 
	Nope. I took out the reference to the 8.1.5 database in the 8.1.6

listener.ora... same old crap. It still thinks it's starting a listener named LISTENER pointing at 1521.

I also tried changing the name of the 8.1.5 listener to LSNR815. Still, when I go to start the 8.1.6 listener I get the same error:

qodt bar:/oracle/dbserver/8.1.5/network/admin>cd $TNS_ADMIN

qodt bar:/oracle/dbserver/8.1.6/network/admin>lsnrctl

LSNRCTL for HPUX: Version 8.1.6.0.0 - Production on 15-AUG-2000 14:13:29

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start LSNR816

TNS-01106: Listener using listener name LSNR815 has already been started

LSNRCTL>

		-----Original Message-----
		From: Joseph S. Testa [mailto:teci_at_oracle-dba.com]
		Sent: Tuesday, August 15, 2000 2:07 PM
		To: ORACLE-L_at_fatcity.com; Koivu, Lisa
		Subject: Re: 8.1.6 Listener Weirdness
		
		
		8.1.6 listener dont play nice with 8.1.5 and vice versa. 

		isnt this the problem? 
		(SID_DESC = 


		      (GLOBAL_DBNAME = qodd) 

		      (ORACLE_HOME = /oracle/dbserver/8.1.5) 

		      (SID_NAME = qodd) 

		    ) 
		  
		  

		joe 
		  

		"Koivu, Lisa" wrote: 

			  

			I am at my wits' end here.  I have a TAR logged with
support. 
			I have installed 8.1.6 on our HP/UX 11.0 host.

Upgrade of database was smooth, no errors, database is behaving normally (so far). We have DBMS_UTILITY back.

However I CAN NOT START an 8.1.6 listener!! The 8.1.5 listener can't listen for the 8.1.6 database (I tried that too) so I tried to start a second listener on a different port. No dice. lsnrctl thinks I am trying to start a listener with the same attributes as the 8.1.5 listener.

My environment variables are all set to 8.1.6, there is no 8.1.5 anywhere.

I have un-set SHLIB_PATH and LD_LIBRARY_PATH as suggested in description of bug 1355618.

I have also tried having the 8.1.6 listener listen for both the 8.1.6 db and 8.1.5 db. Doesn't work either.

Out of ideas and waiting on an iTar response (and taking bets on how long it will be.) In the meantime our development team will grind to a standstill eventually - I know it's not a production outage, but it's darn near that. It's my neck if 30 people can't do any work.

Here's my listener.ora. It does not recognize the name I have given it (won't accept start LSNR816).

ANY suggestions are appreciated. Thanks in advance.

			LSNR816 = 
			  (DESCRIPTION_LIST = 
			    (DESCRIPTION = 
			      (ADDRESS_LIST = 
			        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

			      ) 
			      (ADDRESS_LIST = 
			        (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.6.13)(PORT = 1526)) 
			      ) 
			    ) 
			    (DESCRIPTION = 
			      (PROTOCOL_STACK = 
			        (PRESENTATION = GIOP) 
			        (SESSION = RAW) 
			      ) 
			        (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.6.13)(PORT = 2486)) 
			    ) 
			  ) 

			SID_LIST_LSNR816 = 
			  (SID_LIST = 
			    (SID_DESC = 
			      (SID_NAME = PLSExtProc) 
			      (ORACLE_HOME = /oracle/dbserver/8.1.6) 
			      (PROGRAM = extproc) 
			    ) 
			    (SID_DESC = 
			      (GLOBAL_DBNAME = qodd) 
			      (ORACLE_HOME = /oracle/dbserver/8.1.5) 
			      (SID_NAME = qodd) 
			    ) 
			    (SID_DESC = 
			      (GLOBAL_DBNAME = qodt) 
			      (ORACLE_HOME = /oracle/dbserver/8.1.6) 
			      (SID_NAME = qodt) 
			    ) 
			    (SID_DESC = 
			      (GLOBAL_DBNAME = viking) 
			      (ORACLE_HOME = /oracle/dbserver/8.1.6) 
			      (SID_NAME = viking) 
			    ) 
			  ) 
			  

			Lisa Rutland Koivu 
			Oracle Database Administrator 
			Qode.com 
			4850 North State Road 7 
			Suite G104 
			Fort Lauderdale, FL  33319 

			V: 954.484.3191, x174 
			F: 954.484.2933 
			C: 954.658.5849 
			http://www.qode.com <http://www.qode.com>

Received on Tue Aug 15 2000 - 13:59:53 CDT