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

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

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Received on Fri Dec 19 2003 - 17:07:14 CST