Multiple IP in TNS Listener

[adewri]

You can use three different listeners with three different port for each of them.

something like...

listener.ora

LISTENER1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = first_ip_address)(PORT = 1540))
      )
    )
  )

SID_LIST_LISTENER1 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = DB1.WORLD)
      (ORACLE_HOME = D:\Oracle\Ora92)
      (SID_NAME = DB1)
    )
  )

LISTENER2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = second_ip_address)(PORT = 1541))
      )
    )
  )

SID_LIST_LISTENER2 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = DB2.WORLD)
      (ORACLE_HOME = D:\Oracle\Ora92)
      (SID_NAME = DB2)
    )
  )

LISTENER3 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = third_ip_address)(PORT = 1542))
      )
    )
  )

SID_LIST_LISTENER3 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = DB3.WORLD)
      (ORACLE_HOME = D:\Oracle\Ora92)
      (SID_NAME = DB3)
    )
  )

But remember you need to take care with your tnsnames.ora


For more on how to setup listener and tnsnames refer to the Oracle network administrators Guide at tahiti.oracle.com

HTH