RE: Connecting 8.0 to 8.1

John,
thanks for the correction.  I must have read that(or thought I read that) somewhere.  I learn something new every day.  I do appreciate you correcting me though.
<SPAN
class=326024911-16112001> 
<SPAN
class=326024911-16112001>Thanks,
<SPAN
class=326024911-16112001> 
<SPAN
class=326024911-16112001>Dave

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Hallas John   [mailto:John.Hallas_at_btcellnet.net]Sent: Friday, November 16, 2001   3:11 AMTo: Multiple recipients of list ORACLE-LSubject:   RE: Connecting 8.0 to 8.1
  I am not sure you are correct Dave. We use 8.0.5 clients on NT   PC's to connect to 8.1.7 instances on various flavours of Unix and   VMS.
  John
  -----Original Message----- From:
  Farnsworth, Dave [<A
  href="mailto:DFarnsworth_at_Ashleyfurniture.com">mailto:DFarnsworth_at_Ashleyfurniture.com]   Sent: 15 November 2001 12:52 To:
  Multiple recipients of list ORACLE-L Subject: RE:   Connecting 8.0 to 8.1
  You might have install the 8.1 client.  I may be wrong   but I think with the 8.1 client you can connect to 8.1   and any version lower but with the 8.0 client you   cannot connect to a higher version.  If you don't have the 8.1   client CD you can download the client at Oracle's   site.
  Dave
  -----Original Message----- Sent:
  Thursday, November 15, 2001 5:25 AM To: Multiple   recipients of list ORACLE-L
  Forgive me if this is a RTFM question - I have not been able   to find the right bit of the FM.
  Can someone please tell me how to Net8 connect an 8.0 NT   client to an 8.1 Linux server.
  Everything was working fine until a second Oracle instance was   installed on the server.  I now get
  ERROR: ORA-12545: Connect failed
  because target host or object does not exist   My tnsnames.ora looks like this...
  ORANGE.WORLD =   (DESCRIPTION

•     (ADDRESS = (PROTOCOL = TCP)(HOST
• 123.456.798.101)(PORT = 1521))    
  (CONNECT_DATA = (SID = ORANGE))   )
  The server listener.ora looks like this # LISTENER.ORA Network Configuration File: <FONT size=2>/opt/oracle/product/8.1.7/network/admin/listener.ora <FONT size=2># Generated by Oracle configuration tools. LISTENER =   (DESCRIPTION_LIST
•     (DESCRIPTION = <FONT size=2>      (ADDRESS_LIST = <FONT size=2>        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))       )       (ADDRESS_LIST
•         (ADDRESS
• (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 1521)) <FONT size=2>      ) <FONT size=2>    )    
  (DESCRIPTION =      
  (PROTOCOL_STACK = <FONT
  size=2>        (PRESENTATION = GIOP)         (SESSION = RAW)       ) <FONT size=2>      (ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 2481))     )   ) SID_LIST_LISTENER =   (SID_LIST
•     (SID_DESC = <FONT size=2>      (SID_NAME = PLSExtProc) <FONT size=2>      (ORACLE_HOME = /opt/oracle/product/8.1.7) <FONT size=2>      (PROGRAM = extproc) <FONT size=2>    )    
  (SID_DESC =      
  (GLOBAL_DBNAME = TEST.abc123de) <FONT
  size=2>      (ORACLE_HOME = /opt/oracle/product/8.1.7) <FONT size=2>      (SID_NAME = TEST) <FONT size=2>    )    
  (SID_DESC =      
  (GLOBAL_DBNAME = ORANGE.acn032hq) <FONT
  size=2>      (ORACLE_HOME = /opt/oracle/product/8.1.7) <FONT size=2>      (SID_NAME = ORANGE) <FONT size=2>    )   ) I anonymised the data (obviously) Many thanks to anyone who understands this stuff. David Jones -- <FONT size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com -- Author: Jones, David   INET: David.Jones_at_acnielsen.co.uk Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists <FONT size=2>-------------------------------------------------------------------- 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: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com -- Author: Farnsworth, Dave <FONT size=2>  INET: DFarnsworth_at_Ashleyfurniture.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists <FONT size=2>-------------------------------------------------------------------- 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). <FONT size=3>**********************************************************************This email and any attachments may be confidential and the subject oflegal professional privilege. Any disclosure, use, storage or copyingof this email without the consent of the sender is strictly prohibited.Please notify the sender immediately if you are not the intendedrecipient and then delete the email from your inbox and do notdisclose the contents to another person, use, copy or store theinformation in any medium.**********************************************************************