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).