RE: Connection Problem

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 16 Jan 2004 05:29:34 -0800
Message-ID: <F001.005DD05C.20040116052934@fatcity.com>

Mark,

The (GLOBAL_DBNAME= l1000.)
entry looks strange. Should there be a '.' in there? I've never seen this entry in this file. What does : lsnrctl status & lsnrctl services show?

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Friday, January 16, 2004 6:14 AM
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/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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: thomas.mercadante_at_labor.state.ny.us

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

Received on Fri Jan 16 2004 - 07:29:34 CST