• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1438
  • Last Modified:

Connect to Oracle 8i Server from Oracle 10.2g Client

I am trying to connect to Oracle 8i Server using Oracle 10.2g Client

But I get error message that this version(10.2 client) no longer supports oracle 8i.

Is this true? I have never heard that oracle 10.2 client cannot connect to older version servers!!!
Pl help
0
at999
Asked:
at999
  • 3
  • 2
1 Solution
 
DLyallCommented:
Accodring to Oracle Metalink site, 10.2g Client will work with 8.1.7 server but only if you have an Extended Maintenance Support agreement with Oracle.  It is not compatible with any other 8i server version.  An ORA-3134 error is correctly reported when attempting to connect to any non compatible version.
0
 
paquicubaCommented:
Somehow then I can connect to 8i using 10g and vice versa...

Using 10g to connect to 8i:

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 9 09:42:39 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

TEST@PROD > conn xxxxxxxx/xxxxxx@xxxxxx
Connected.
> select * from v$version
/

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
PL/SQL Release 8.1.7.4.0 - Production
CORE    8.1.7.0.0       Production
TNS for Solaris: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production



==============================================
From 8i to 10g:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
PL/SQL Release 8.1.7.4.0 - Production
CORE    8.1.7.0.0       Production
TNS for Solaris: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

Elapsed: 00:00:00.00
SQL> conn alex/xxxxxxxx@prod
Connected.
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Elapsed: 00:00:00.00
SQL>



Add this entry to the TNSNAMES.ora file

<SID> =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <Host Name>)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = <SID>)
    )
  )

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
schwertnerCommented:
It depends from the character set used in 10g.
8i software will not connect to 10g if 10g uses the
unknown for 8i AL32UTF character set.
If not - the connection will be possible.

From 10g to 8i:
I couldn't connect also.  8i was a nice version and I can not forget it,
but ... it is not supported and not compatible with the new Oracle products.

Seems the workaround is to install 8i client in another Oracle home
and to use it alternativelly.
0
 
DLyallCommented:
:pacuicuba

Your right.  Connection to 8.1.7 should work,  pre 8.1.7 should give an error.
Oracle will only support issues arising when connecting 10.2g to 8.1.7 if you have an extended maintenance contract.
0
 
paquicubaCommented:
Go it!
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now