We had this problem recently- running 8.1.7 (64-bit) and 9.0.1.3 (32-bit) on Sun Solaris 2.8. Both databases were registered in the same version 9.0.1.3.0 Listener. Oracle Support eventually told me that Listener versions below 9iR2 do not support mixed bit versions (64- and 32-bit). You would have to run a separate listener for each bit version. I upgraded the 9.0.1.3.0 to 9.2.0.2.0 and registered both on the new 9iR2 Listener (this week) and haven't seen a listener crash...yet (fingers crossed).
See text below, copied from my TAR. David B. Wagoner Database Administrator Arsenal Digital Solutions Phone: 919-466-6723 Cell: 919-412-8462 Fax: 919-466-6783 E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web: http://www.arsenaldigital.com <http://www.arsenaldigital.com/> === ANALYSIS === This is most likely the known issues with registration taking place accross bit versons and from a higher version of a database to a lower version of the listener. Cross Registration for 2 oracle instances with different BIT versions will not work until listener 9.2.0.2.0. The other possibility is that the 9.2.0 regular instance is registering using the default settings to the listener 8.1.7. This is not a supported functions. The supported method would be using the listener version that matches the highest version of the database you plan on using. Ill tell you the methods that you can use to determine if this is in fact your issue and how to resolve it. Some facts about the known issue. 1. Your running 32 and 64 bit software 2. The listener that is crashing is using port 1521. 3. Your listener shows a service handler twice for the instances. 4. Your not completely familiar with Automatic instance registration functionality. === ACTION PLAN === 1. Go to Oracle_home/bin and perform file oracle that should return Elf and some other text. if the return Text Says "64" then its running 64 bit oracle. 2. Perform the same in the other oracle home. 3. perform lsnrctl status and you will see that there is the two instances in the service list. 4. Go to metalink and read Article-ID: <Note:76636.1> Circulation: PUBLISHED (EXTERNAL) Folder: network.TNSListener Topic: Service Registration Title: Service Registration in Net 8i So you understand the instance registration process. === SOLUTION/ANSWER === You have a few options. 1. Change the listener port to something other than 1521. That way registration to the default port wont take place which is why the issue is taking place. 2. Use a 9.2.0.2.0 listener...see bug 2187760 for full details. Cross Registration between BIT versions doesnt work until listener 9.2.0.2.0 3. Force Registration to fail by setting the LOCAL_LISTENER parameter to a value other than the current listener address. Again avoiding Registration by forcing it not to work properly. > -----Original Message----- > From: Post, Ethan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 5:00 PM > To: Multiple recipients of list ORACLE-L > Subject: Listener Hanging 64 Bit Solaris 8 Oracle 9.2 > > > Anyone had this issue? Oracle support has been helpless so > far, even with > mega trace files. > > - Ethan > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Post, Ethan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
