Re: Multiple Listener on multiple homes

Comments embedded.

On 30 Mar 2004 02:58:27 -0800, chris_kernaghan_at_hotmail.com (Chris) wrote:

>Hi,
>
>I have an two databases on the one server.
>
>A clean install of Oracle 9i called BW and an upgraded 9.2 (from
>8.1.7.4) called CRM
>

OK, two 9.2 databases. Your subject line says you also have two (or more) Oracle homes, but you don't need that to support two databases at the same level.

>When trying to start the BW system I got and NLS parameter error which
>was fixed by removing a system environment variable pointing to CRM
>home.
>
>Now I have an issue with the TNS listeners, I have two listeners
>listed in the Services directory. I can start the bw listener but I
>cannot start the CRM listener.

I'm assuming from your mention of "the Services directory" that this is on a Windows system.

Why do you want two listeners?

>
>I have tried adding the ports and tnsnames entries to the bw listener
>configuration, but when I try to start the CRM database it looks for
>the initcrm.ora file in the bw home directory.
>

How are you trying to start your db?

>I need to be able to have two listeners on two different ports.
Why?
>
>How can I accomplish this.
>

There is a lot of missing info here, but it sounds to me like you're trying to run two Oracle homes to support two databases, even though those databases are at the same level. If I'm right about that, I'd forget about the second Oracle home. One Oracle home will support mutliple databases. And even if the databases are (and need to be) at different levels -- neccisitating multiple Oracle homes, you can still service them all with a single listener.

If you are -- and need to -- run multiple homes, you have to make sure all of your environment variables and registry entries are correct for the one you are working with at any given moment.

>Chris aka BoobBoo
Received on Tue Mar 30 2004 - 08:16:05 CST