我测试的环境是：
后端
WINDOWS 2000 SERVER，ORACLE 8.1.7
前端
WINDOWS 98
DEVELOPER 2000 (V1.3.2)
(FORMS 4.5.7.1.6
ORACLE TCP/IP ADAPTER 2.3.2.1.4
SQL*NET CLIENT 2.3.2.1.6A
SQL*PLUS 3.3.2.0.2)
安装配置后用SQLPLUS测试连接时出现ORA-03106错误:
SQL*Plus: Release 3.3.2.0.2 - Production on Sun Mar 24 11:35:55 2002
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
ERROR: ORA-03106: fatal two-task communication protocol error
Enter user-name:
相关配置如下,请高手帮我分析原因(是不是包含FORMS 4.5的DEVELOPER 2000还有其他版本?):
# LISTENER.ORA Network Configuration File: E:\ORANT\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.6)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.6)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\ORANT)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = E:\ORANT)
(SID_NAME = ORCL)
)
)
-----------------------------------------------------------------
# TNSNAMES.ORA Network Configuration File: E:\ORANT\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ORCL)
(PRESENTATION =
http://admin)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
===================================================================
#C:\Orawin95\NETWORK\CFG\sqlnetv2.cfg
#This is a SQL*Net Configuration file generated by SQL*Net Easy Configuration.
#Attention: Do not modify this file yourself.
#If you do, your SQL*Net Easy Configuration may not function properly.
next_addendum=7
tns_filesize=2427
ALIAS_6=TEST.world
TEST.world_PROTOCOL=TCP
TEST.world_COMMUNITY=tcp.world
TEST.world_HOST=192.168.0.6
TEST.world_SID=ORCL
--------------------------------------------------------------------
#C:\Orawin95\NETWORK\ADMIN\Tnsnames.ora
#This is a SQL*Net Configuration file generated by SQL*Net Easy Configuration.
#Attention: Do not modify this file yourself.
#If you do, your SQL*Net Easy Configuration may not function properly.
TEST.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.6)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.6)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
======================================================
谢谢!
