Multiple listeners for multiple ORACLE homes?
I have two different databases on the same server. One database version is Oracle 10.2 (HOME: E:\ ) and the other database version is 11.2 and its home is E:\oracle\app\product\11.2.0.4\dbhome_1). We need to connect both these database from one client by using service name.
Do I need to create one listerner for Oracle 10.2 database and one more for Oracle 11.2 database?? How about the port number for each of them? Can they be different ???