Re: Connection Problem

I don't believe a 12154 error has anything to do with the listener. The request never leaves the client. It has all to do with the fact that sqlnet on the client can not find the service name in the tnsnames.ora. What is names.default.domain set to in sqlnet.ora. If there is no sqlnet.ora try appending .world to the servicenames in the tnsnames.ora (e.f. LIVE.WORLD = .)

At 04:14 AM 1/16/2004, you wrote:
>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/pass_at_LIVE" 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: mark_at_cool-tools.co.uk
>===================================================
> 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: mark_at_cool-tools.co.uk
>
>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: 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).

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

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