Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connection Problem

RE: Connection Problem

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 16 Jan 2004 07:04:33 -0800
Message-ID: <F001.005DD06C.20040116070433@fatcity.com> 





Mark,



I don't think that all three on the same port is a problem - heck - I do it
all the time.  I would comment out the GLOBAL_DBNAME entry.  It certainly is
not required.  And output from lsnrctl would be helpful.



Tom Mercadante


Oracle Certified Professional




-----Original Message-----


Sent: Friday, January 16, 2004 9:20 AM


To: Multiple recipients of list ORACLE-L




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).
-- 
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 - 09:04:33 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US