cancel
Showing results for 
Search instead for 
Did you mean: 

Memory windows & Oracle

SOLVED
Go to solution
Jaris Detroye
Frequent Advisor

Memory windows & Oracle

I understand most of the ideas around memory windows and how I can place different Oracel Instances in different memory windows. Here is my question:
Does this impact the listener? Can it still communicate with all the databases in which are running in different memory windows?
9 REPLIES
John Poff
Honored Contributor

Re: Memory windows & Oracle

Hi,

Your listener should be fine. We used to run Oracle 7 in 32 bit with multiple windows, and I don't remember having any issues with the listener.

JP
Jaris Detroye
Frequent Advisor

Re: Memory windows & Oracle

We are running a mix of Oracle 7 & ORacle 8 databases. And we are using a single Oracle 8 listener for all (Currently).
Any red flags here???
Dietmar Konermann
Honored Contributor

Re: Memory windows & Oracle

The listener needs to be 32bit... otherwise you will get problems.
"Logic is the beginning of wisdom; not the end." -- Spock (Star Trek VI: The Undiscovered Country)
Jaris Detroye
Frequent Advisor

Re: Memory windows & Oracle

Our listener is Oracle 8 - 64bit.

Will this be a show stopper?

Re: Memory windows & Oracle

If you look at the same issue in this forum, it seems that you need one listener by memory windows.
Wodisch
Honored Contributor

Re: Memory windows & Oracle

Hi,

well, AFAIK, yes this will not work!
The listener must be started using the same memory window id as the instance itself, which excludes a 64bit listener automatically...
You'll even have to use individual listeners for each and every instance running in a memory window of its own (the same as the instance, of course).

HTH,
Wodisch
Jaris Detroye
Frequent Advisor

Re: Memory windows & Oracle

I am told that Oracle told us we can not run multiple listeners.
Am I getting bad information?
Also, one of the previous responses indicated that 'he' was using multiple windows with a single listener.
Who's right???
Victor BERRIDGE
Honored Contributor
Solution

Re: Memory windows & Oracle

Hi,
Woodish is right, you will need 1 listener per instance running in the same memory window:
$ ps -ef|grep tns
dbaddv1 28840 1 2 07:20:02 ? 0:02 /n1/mnt2/DDV1/ora/8.1.7/bin/tnslsnr DDV1 -inherit
dbarcf1 28402 1 0 Sep 18 ? 0:48 /opt/oracle/product/8.1.7.64/bin/tnslsnr RCF1 -inherit
dbatpa1 18383 1 0 16:24:09 ? 0:00 /n1/mnt6/TPA1/ora/8.0.6/bin/tnslsnr APPS_TPA1 -inherit
dbadcs0 26263 1 0 07:01:04 ? 0:00 /n1/mnt7/DCS0/ora/8.0.6/bin/tnslsnr APPS_DCS0 -inherit
dbaddv1 16825 1 0 09:25:37 ? 0:00 /n1/mnt2/DDV1/ora/8.0.6/bin/tnslsnr APPS_DDV1 -inherit
dbatpa1 14288 1 0 Oct 7 ? 0:21 /n1/mnt6/TPA1/ora/8.1.7/bin/tnslsnr TPA1 -inherit
vbe 2036 6799 1 19:39:02 ttyp2 0:00 grep tns
dbatin1 28017 1 0 07:16:19 ? 0:00 /n1/mnt8/TIN1/ora/8.0.6/bin/tnslsnr APPS_TIN1 -inherit
dbadcs0 26178 1 0 07:00:02 ? 0:01 /n1/mnt7/DCS0/ora/8.1.7/bin/tnslsnr DCS0 -inherit
dbatin1 27875 1 2 07:15:02 ? 0:02 /n1/mnt8/TIN1/ora/8.1.7/bin/tnslsnr TIN1 -inherit
dbatev1 4111 1 0 18:10:26 ? 0:00 /n1/mnt3/TEV1/ora/8.1.7/bin/tnslsnr TEV1 -inherit
$

Good luck
Victor
A. Clay Stephenson
Acclaimed Contributor

Re: Memory windows & Oracle

There is no problem running multiple listeners as long as there are no port conflicts.

In MC/SG, I always have a dedicated listener that moves with the package so that if multiple packages are running on the same node, multiple listeners are running.
If it ain't broke, I can fix that.