Listener

[dba_dada]

I have DB X and DB Y in same box. Only one listener for both DB 1521 port. I have to reconfigure DB Y to listen 1522. Do I have create another listener to do that? What would be best way doing it? Can you please point me any documentation or an example?

Any help would be a great help.

Thanks!

[dhar_kiran]

A listener can listen only at one port. u need to create one more listener for that.

create another listener at port 1522 by making entry of that listener in listener.ora file like .

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = DWH0P01))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodeA.ldn.eu.wm.ubs.com)(PORT = 1522))
)
)
)

and then make entry in TNSNAMES.ora file as

prod1.db.eu.wm.ubs.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodeA.ldn.eu.wm.ubs.com)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = prod1.db.eu.wm.ubs.com)
)
)

and then use this service to connect to dataabase Y.

[ebrian]

A listener can actually listen on multiple ports. You can try the following:

listener.ora

LISTENER =
  (DESCRIPTION_LIST =
   (DESCRIPTION =
    (ADDRESS_LIST =
	(ADDRESS = (PROTOCOL = TCP)(HOST = hosta)(PORT = 1522))
	(ADDRESS = (PROTOCOL = TCP)(HOST = hosta)(PORT = 1521))
    )
   )
  )

SID_LIST_LISTENER =
  (SID_LIST =
	(SID_DESC =
	  (GLOBAL_DBNAME = DBX)
	  (ORACLE_HOME = <oracle_home_path>)
	  (SID_NAME = dbx)
	)
	(SID_DESC =
	  (GLOBAL_DBNAME = DBY)
	  (ORACLE_HOME = <oracle_home_path>)
	  (SID_NAME = dby)
	)
  )

tnsnames.ora

dbx =
  (DESCRIPTION =
	(ADDRESS_LIST =
	  (ADDRESS = (PROTOCOL = TCP)(HOST = hosta)(PORT = 1521))
	)
	(CONNECT_DATA =
	  (SERVICE_NAME = dbx)
	)
  )

dby =
  (DESCRIPTION =
	(ADDRESS_LIST =
	  (ADDRESS = (PROTOCOL = TCP)(HOST = hosta)(PORT = 1522))
	)
	(CONNECT_DATA =
	  (SERVICE_NAME = dby)
	)
  )

[dba_dada]

Ebrian and Dhar_kiran

Thank you very much!!!