Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how can listener list on two ports for the same db?
how can listener list on two ports for the same db?Hello Helmut
You need to configure the listener to listen on ONE host with 2 ports.
The machine name is the same.
You separate the connections via tnsnames.ora on the client side.
I got a call today that one of our application server
can not connect to a database
after tech people move an application server to another place.
Connected to the database from my PC - OK.
I activated tnsping from the server itself and could not get response. I changed the tnsnames, on the application server, to access a second network card and all is well.
I accessed the database via another NIC without any change to the database server.
Yechiel Adar
Mehish
Hi!
We have a db server (in a cluster) with two NICs and two IP-Adresses (i.e. logical names in the cluster). How do I configure the listener so that it listenes for both logical names of the machine?
LISTCMDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kfplcmdb)(PORT = 1522)) )
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kfalcmdb)(PORT = 1522)) )
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_CMDB)) ) )
SID_LIST_LISTCMDB =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc_CMDB)
(ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7)
(PROGRAM = extproc)
) (SID_DESC =
(GLOBAL_DBNAME = CMDB)
(ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7)
(SID_NAME = CMDB)
)
Sitting on our RMAN database machine, pinging kfplcmdb does not work but pinging kfalcmdb works fine.
On th emachine to be backed up: why can't I use kfalcmdb in the listener.ora file? The listener works fine when using kfplcmdb.
This is 8.1.7 on Solaris 8.
Thanks,
Helmut
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: adar76_at_inter.net.il Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu May 30 2002 - 09:53:29 CDT
![]() |
![]() |