topic Re: connect to instance with memory windows in Operating System - HP-UX

connect to instance with memory windows

Marcin_Chmielewski — Thu, 25 Apr 2002 07:51:52 GMT

Hi,
I have some oracle instances
(oracle 8.1.6 on hp-ux 11.0)
using memory windows, and there is the problem:
if I startup instance in memory window I can't connect to it from remote client (ora-01034 Oracle not available).
But if I startup the same instance without memory windows everything is ok and I can attach to this from any remote station.

What is wrong ?

Re: connect to instance with memory windows

Wodisch — Thu, 25 Apr 2002 10:14:45 GMT

Hi,

you have to start your "listener" with the same window-id, i.e.
setmemwindow -i XXX tnsctrl start

where XXX would be your memory window id (you may use getmemwindow to retrieve it).

HTH,
Wodisch

Re: connect to instance with memory windows

Marcin_Chmielewski — Thu, 25 Apr 2002 12:10:21 GMT

Hi

But I get message
that listener is already running (TNS-01106).
I understand that I have to
make separate listener for
any instances but how to do it ?
(Now I have all of them in one listener.ora)

Re: connect to instance with memory windows

Wodisch — Thu, 25 Apr 2002 15:16:09 GMT

Hello again,

yes, you'll need different listeners - one for each memory window!
All listenere defitions are in your one and only one "listener.ora", they just use different names, AND they have to use different ports!

HTH,
Wodisch

Re: connect to instance with memory windows

Wodisch — Thu, 25 Apr 2002 15:18:19 GMT

Hello again,

...which make the command look like:

setmemwindow tnsctrl start listener1
setmemwindow tnsctrl start listener2
setmemwindow tnsctrl start jack
setmemwindow tnsctrl start jill

assuming that you have four listeners named
- listener1
- listener2
- jack
- jill

So, don't use the default name "LISTENER" any more!

HTH,
Wodisch

Re: connect to instance with memory windows

T. M. Louah — Fri, 26 Apr 2002 01:27:40 GMT

here some discussions :
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xd6fec6af36b7d5118ff10090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xfa6bfd3f91d3d5118ff40090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xdbed5f260cafd4118fef0090279cd0f9,00.html

Re: connect to instance with memory windows

Marcin_Chmielewski — Fri, 26 Apr 2002 11:04:53 GMT

Hi, it's me again

can smbd show me 'listener.ora' file with multiply listeners configured ?