RE: Could not Connect to 8.1.6

<SPAN
class=494271905-28042001>Possibly it has something to do with Connect Data string in tnsnames.ora
<SPAN
class=494271905-28042001>For 8i databases, SID has to be replaced with SERVICE_NAME. As can be seen in following example(OHIL is Oracle 8.0.5 database, and OHIR1 is 8.1.6 database)
<SPAN
class=494271905-28042001> 
<SPAN
class=494271905-28042001>>>>>
<SPAN
class=494271905-28042001>OHIL.OHIT.COM =  (DESCRIPTION =    (ADDRESS_LIST =     
(ADDRESS = (PROTOCOL = TCP)(HOST = OHI-Y2K)(PORT = 1521))    )    (CONNECT_DATA =      (SID =
OHIL)    )  )
 
<SPAN
class=494271905-28042001>OHIR1.OHIT.COM =  (DESCRIPTION =    (ADDRESS_LIST =     
(ADDRESS = (PROTOCOL = TCP)(HOST = RAJESH1)(PORT = 1521))    )    (CONNECT_DATA =     
(SERVICE_NAME = OHIR1)    )  )
<SPAN
class=494271905-28042001><<<<<
<SPAN
class=494271905-28042001> 
<SPAN
class=494271905-28042001>HTH,
<SPAN
class=494271905-28042001>Rajesh

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of N J NeogSent:   Saturday, April 28, 2001 9:40 AMTo: Multiple recipients of list   ORACLE-LSubject: Could not Connect to 8.1.6   Hi all,
 

  We 3 Oracle server as follows.
 

1. Oracle8 Enterprise Edition 8.0.5
2. Oracle8i Enterprise Edition 8.1.5
3. Oracle8i Enterprise Edition 8.1.6 was Installed Recently.
    
   All are in Digital Unix
    
   The problem is 
    
   From a Unix user if my ORACLE_HOME is pointing to database A(8.0.5) or B(8.1.5), we can connect <FONT face=Verdana size=2>from Sqlplus to Oracle Server A and B not <FONT face=Verdana size=2>to C (8.1.6.) But If ORACLE_HOME is pointing to C(8.1.6), Sql Plus can connect to all database.
    
    
   Is there a problem with 8.1.6 ? or had we Installed 8.1.6 wrongly ? Any suggestion how to rectify it assuming my ORACLE_HOME always points to 8.1.5 or 8.0.5.
    
   Thanks in advance
    
   Regards.
    
   Naba J Neog