Re: Forms6i connection problem with DB 9.2.0.4, error-3106

Sean Chang wrote:

> Oracle DB 9.2.0.4 doesn't use listener.ora, it auto-discovers 3 DB:
> 2 of 8.1.7, one 9.2.0.4.
>
> Oracle client 8.1.7 on solaris can connect to 9.2.0.4, as Oracle
> client 9.2 on win 2K also can connect to 9.2 DB. The problem is
> Forms 6i: configuration files in C:\orant\net80\admin
> sqlnet.ora only one line(other lines are insignificant :, like trace, log)
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> TNSNAMES: 2 db configuation
> # oracle 8.1.7 DB EE
> CNF.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.5)(PORT = 1521))
> (CONNECT_DATA = (SID = cnf)(GLOBAL_DBNAME = cnf.cnfei.com))
> )
> # oracle 9.2.0.4 EE
> ORA9.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.5)(PORT = 1521))
> (CONNECT_DATA = (SID = ora9)(GLOBAL_DBNAME = ora9.cnfei.com))
> )
>
> tnsping80 both cnf.world and ora9.world OK.
>
> CNF connection has no problem at all.
> ora9 connections always fails.
>
>
>
>
[SNIP!]
I'd give the following a try:
  ORA9.WORLD =
    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.5)(PORT = 1521))
      (CONNECT_DATA = (SERVICE_NAME = ora9.cnfei.com))

You may have to check whether the service name is correct

-- 
Merry Christmas and a Happy New Year,
Frank van Bortel