Re: One listener but two listener binaries in multihomed environment

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:hvudiv47e8hhbing27ng8qth2h50omdun7_at_4ax.com...
> Hello
>
> I have two Oracle versions installed (8.1.70 and 9.2.0.1)under Linux
> Advanced Server 2.1 (Red Hat),and there are two environments around
> different ORACLE_HOMEs. Almost everything works nice, we have several
> DB running different Oracle versions. But I am having trouble starting
> the OMS and/or connecting to it. I found out, that as the user oracle8
> I can check the listener status using the binary from $ORACLE_HOME/bin
> and then I get a response coming from the version 9! When I check the
> listener status using the binary of version 9.2.0.1, the output is
> similar. Only the listener from version 9 was really started.
>

I have the impression that both listeners are configured on port 1521 and 9i is registering automatically the 8i instance(s). So, first off, check if both listeners are configured on that port. If you disable the 8i listener, then you can rely on the 9i listener but this implies that if you stop it, as many DBAs do to prevent users from connecting temporarily, then you're actually stopping users of both environments, not just 9i's.
For this reason I'd prefer to configure the listeners on two different addresses, so that each environment relies on its own listener. In case you opt for the latter solution, remember that if the listener is configured for shared mode access, then you'll need to create an alias in the tnsnames.ora located on the server, of its corresponding environment, possibly ! :-)

On the contrary, from OMS standpoint, it's advisable to keep running only 9i Intelligent Agent because it can manage both oracle homes succesfully.

Bye,
Flavio Received on Wed Jul 30 2003 - 02:43:41 CDT