RE: Connection Problem

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 16 Jan 2004 06:19:34 -0800
Message-ID: <F001.005DD066.20040116061934@fatcity.com>

I've asked for the out put on a lsnrctl status already, but haven't heard back from him as yet..

The "." does look strange.. Also, what would the impact be to have the GLOBAL_DBNAME set to the same value for all three instances? Would it not be better to set it to the same name as the instance name for each?

The same goes for port too.. I thought that all three on the same port would be OK?

Cheers

Mark

-----Original Message-----
Mercadante, Thomas F
Sent: 16 January 2004 13:30
To: Multiple recipients of list ORACLE-L

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

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

Received on Fri Jan 16 2004 - 08:19:34 CST