Oracle-L: RE: Listener Hanging 64 Bit Solaris 8 Oracle 9.2

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Fri, 14 Feb 2003 07:29:30 -0800
Message-ID: <F001.0054D9AE.20030214072930@fatcity.com>

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: dwagoner_at_arsenaldigital.com <mailto:dwagoner_at_arsenaldigital.com> 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:Ethan.Post_at_ps.net]
> 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: Ethan.Post_at_ps.net
>
> 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: 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Wagoner
  INET: dwagoner_at_arsenaldigital.com

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: 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 Fri Feb 14 2003 - 09:29:30 CST