Can we start HSODBC listener and Oracle Listener using two separate Shells
629591Mar 20 2008 — edited Mar 20 2008I have a oracle 10 g database running on AIX machine. I have a Sybase ACE 12.5 database running on solaris. I want to configure HSODBC (Generic connectivity) to connect from Oracle to Sybase. For this I will need two listeners. One for the oracle database and one for the HSODBC. Can we have the two listeners as separate. Or Is it mandatory that both listeners should be combined?
The reason is this. We have LIBPATH variable set in oracle users .profile . Our oracle database needs that. We want to use a different LIBBATH for HSODBC and we want to override it only for HSODBC. So I want to try starting HSODBC listener from a separate shell script. Within that shell script I would like to unset the original LIBPATH variable which was previously defined in .profile then set it to the one I want to. I am trying to do this in AIX. Can you please if this is possible?