Re: how can listener list on two ports for the same db?
Hi Helmut , I will try to clarify using an example. Tnsnames.ora ghi100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = your IP address of the server where database resides ) (Port = 1526) ) ) (CONNECT_DATA = (SID = ghi100) ) ) ghi101 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host =your IP address of the server where database resides ) (Port = 1521) ) ) (CONNECT_DATA = (SID = ghi100) ) ) In this example i have 2 connection strings (ghi100,ghi101) connecting through 2 different ports (1521,1526) to the same database . Also ensure that you add the ports(1521,1526) in /etc/services on the server (Unix based) . Listener.ora LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1526)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name%) (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3) (SID_NAME = ghi100) ) ) LISTENER0 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1521)) ) SID_LIST_LISTENER0 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name%) (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3) (SID_NAME = ghi100) ) ) There are two listener's LISTENER and LISTENER0 . You would have to start the listener's seperately. Especially check /etc/services for the entries and check if you have seperate listener names in listener.ora Hope this helps . shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: how can listener list on two ports for the same db?
Hi Helmut , I will try to clarify using an example. Tnsnames.ora ghi100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = your IP address of the server where database resides ) (Port = 1526) ) ) (CONNECT_DATA = (SID = ghi100) ) ) ghi101 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host =your IP address of the server where database resides ) (Port = 1521) ) ) (CONNECT_DATA = (SID = ghi100) ) ) In this example i have 2 connection strings (ghi100,ghi101) connecting through 2 different ports (1521,1526) to the same database . Also ensure that you add the ports(1521,1526) in /etc/services on the server (Unix based) . Listener.ora LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1526)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name%) (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3) (SID_NAME = ghi100) ) ) LISTENER0 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1521)) ) SID_LIST_LISTENER0 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name%) (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3) (SID_NAME = ghi100) ) ) There are two listener's LISTENER and LISTENER0 . You would have to start the listener's seperately. Especially check /etc/services for the entries and check if you have seperate listener names in listener.ora Hope this helps . shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: how can listener list on two ports for the same db?
Title: 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 movean applicationserver 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 AdarMehish - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 11:28 AM Subject: how can listener list on two ports for the same db? 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
how can listener list on two ports for the same db?
Title: how can listener list on two ports for the same db? 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
RE: how can listener list on two ports for the same db?
look db_name.WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = host_name)(Port = 1521)) (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = host_name)(Port = 1526)) (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = host_name)(Port = 1555)) ) (CONNECT_DATA = (SID = db_name)) ) -Message d'origine- De: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Date: mercredi 29 mai 2002 11:28 À: Multiple recipients of list ORACLE-L Objet: how can listener list on two ports for the same db? 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: Bernard, Gilbert INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: how can listener list on two ports for the same db?
If this is 8i, the SID_LIST isn't needed. Here's an example of two listeners (lsnr01 lsnr02) each listening on a diff port for logical names: LSNR01 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01)) (ADDRESS= (PROTOCOL= TCP)(Host= kfplcmdb)(Port= 1521)) (ADDRESS= (PROTOCOL= TCP)(Host= kfalcmdb)(Port= 1521)) ) STARTUP_WAIT_TIME_LSNR01 = 0 CONNECT_TIMEOUT_LSNR01 = 10 TRACE_LEVEL_LSNR01 = OFF LSNR02 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02)) (ADDRESS= (PROTOCOL= TCP)(Host= kfplcmdb)(Port= 1526)) (ADDRESS= (PROTOCOL= TCP)(Host= kfalcmdb)(Port= 1526)) ) STARTUP_WAIT_TIME_LSNR02 = 0 CONNECT_TIMEOUT_LSNR02 = 10 TRACE_LEVEL_LSNR02 = OFF Daiminger, Helmut wrote: 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: Suzy Vordos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).