RE: Could not Connect to 8.1.6

[Rajesh Dayal]

Possibly it has something to do with Connect Data string in tnsnames.ora 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)   >>>> OHIL.OHIT.COM =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = OHI-Y2K)(PORT = 1521))     )     (CONNECT_DATA =       (SID = OHIL)     )   )   OHIR1.OHIT.COM =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = RAJESH1)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = OHIR1)     )   ) <<<<<   HTH, Rajesh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of N J Neog Sent: Saturday, April 28, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Subject: Could not Connect to 8.1.6 Hi all,   We 3 Oracle server as follows.   A. Oracle8 Enterprise Edition 8.0.5 B. Oracle8i Enterprise Edition 8.1.5 C. 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 from Sqlplus to Oracle Server A and B not 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