topic Re: Memory windows & Oracle in Operating System - HP-UX

Memory windows & Oracle

Jaris Detroye — Thu, 10 Oct 2002 13:25:53 GMT

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?

Re: Memory windows & Oracle

John Poff — Thu, 10 Oct 2002 13:41:00 GMT

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

Re: Memory windows & Oracle

Jaris Detroye — Thu, 10 Oct 2002 13:50:14 GMT

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???

Re: Memory windows & Oracle

Dietmar Konermann — Thu, 10 Oct 2002 13:53:03 GMT

The listener needs to be 32bit... otherwise you will get problems.

Re: Memory windows & Oracle

Jaris Detroye — Thu, 10 Oct 2002 13:56:55 GMT

Our listener is Oracle 8 - 64bit.

Will this be a show stopper?

Re: Memory windows & Oracle

Philippe Cussigh — Thu, 10 Oct 2002 14:19:18 GMT

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

Re: Memory windows & Oracle

Wodisch — Thu, 10 Oct 2002 14:37:25 GMT

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

Re: Memory windows & Oracle

Jaris Detroye — Thu, 10 Oct 2002 14:48:32 GMT

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???

Re: Memory windows & Oracle

Victor BERRIDGE — Thu, 10 Oct 2002 16:35:43 GMT

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

Re: Memory windows & Oracle

A. Clay Stephenson — Thu, 10 Oct 2002 17:32:01 GMT

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.