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.
>
>
>
>
>
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message
> news:6is6uvom1fq81mh5dfbf8tic7o807gsl1j_at_4ax.com...
>

>>On Fri, 19 Dec 2003 16:33:24 -0500, "Sean Chang" <sean_at_cnfei.com>
>>wrote:
>>
>>
>>>Hi, Everyone,
>>>(posted on metalink, suggested to apply patch 15, still the same error)
>>>
>>>Forms 6i connection to Oracle 9.2.0.4, error: 3106
>>>
>>>Forms 6i ( downloaded from otn:6i-rel2-xp.zip ) running on
>>>windows (2k professional , 98, xp etc).
>>>Database server: oracle 9.2.0.4 EE on Solaris 9  (64-bit if that helps)
>>>Problem: when I try connect Forms 6i to Database 9.2, I got
>>>error: ora-3106---fatal two-task communication error
>>>Diagnosis: look far and wide, most posts suggested Language
>>>incompatibilites: Forms 6i uses English, DB use UTF-8.
>>>However Forms 6i can connect 8.1.7 DB (on the same host as DB 9.2.0.4)
>>>without any problem.
>>>
>>>Any suggestions are greatly appreciated.
>>>
>>
>>
>>According to your post the database is on Solaris. According to the
>>network log you are connecting from a PC. The connection string shows
>>you are using the BEQ protocol. The BEQ protocol is a non-routable
>>protocol which works on the server only. Thus the error 12203 (shown
>>in the log) is obvious.
>>There are situations where Oracle falls back on using the BEQ
>>protocol. Maybe this is such a case. The problem might also be the
>>huge version difference.
>>To allow further troubleshooting you definitely need to post
>>listener.ora, sqlnet.ora and tnsnames.ora
>>The tnsping utility only guarantees there is a listener running.
>>
>>
>>--
>>Sybrand Bakker, Senior Oracle DBA

[Quoted] I know that a V9.2 DB does not inter-operate with V7.3.4.5 I know that a V9.2 DB does inter-operate with 8i DBs. I'm not sure into which camp
TNS for 32-bit Windows: Version 8.0.6.3.0 - Production falls. Received on Sat Dec 20 2003 - 02:32:44 CET