Operating System - HP-UX
1748076 Members
5389 Online
108758 Solutions
New Discussion юеВ

connect to instance with memory windows

 
Marcin_Chmielewski
Occasional Advisor

connect to instance with memory windows

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 ?
6 REPLIES 6
Wodisch
Honored Contributor

Re: connect to instance with memory windows

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
Marcin_Chmielewski
Occasional Advisor

Re: connect to instance with memory windows

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)

Wodisch
Honored Contributor

Re: connect to instance with memory windows

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
Wodisch
Honored Contributor

Re: connect to instance with memory windows

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
Marcin_Chmielewski
Occasional Advisor

Re: connect to instance with memory windows

Hi, it's me again

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