Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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