Yes, it is possible to run more than one instance on a Windows server and to have one listener configured for all the instances on that server. To set up your listener, you'll need to modify your LISTENER.ORA file to contain information similar to the following:
LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=IPC) (KEY= sid1) ) (ADDRESS= (PROTOCOL=IPC) (KEY= sid2) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = sid1) (ORACLE_HOME = d:oracleora9i) ) (SID_DESC = (SID_NAME = sid2) (ORACLE_HOME = d:oracleora9i) ) )
But all of this may be unnecessary if you set
USE_PLUG_AND_PLAY_LISTENER = ON so that each instance
dynamically registers itself with the listener.
This was first published in October 2003