Hello Mark, all 3 instances are listening on the same port.
Cheers Barry. -----Original Message----- Mark Leith Sent: 16 January 2004 11:14 To: Multiple recipients of list ORACLE-L Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an "12154 - Could not resolve service name" error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENER>ORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect "user/[EMAIL PROTECTED]" the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to "l1000" for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? Cheers! Mark =================================================== Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] =================================================== http://www.cool-tools.co.uk Maximising throughput & performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).