本人机子是Winxp SP2 ie7.0
先安装的是oracle 10g(10.2.0.1.0) 后安装的是Oracle Developer Suite 10.1.2.0.0
问题就出在这~~sql/plus 连接数据库没有任何问题,但是forms builder里面运行的时候 提示TNS:12560错误 奇怪的是在froms builder 里面建立数据块的时候登陆数据库也没有问题,为什么在运行例子的时候就报错呢?
小弟也在网上看了不少帖子,无奈基础太差。对于环境变量,tnsnames.ora的配置都不甚了解
环境变量path:
C:\oracle\product\10.2.0\db_1\bin;C:\DevSuiteHome_3\jdk\jre\bin\classic;C:\DevSuiteHome_3\jdk\jre\bin;C:\DevSuiteHome_3\jdk\jre\bin\client;C:\DevSuiteHome_3\jlib;C:\DevSuiteHome_3\bin;C:\DevSuiteHome_3\jre\1.4.2\bin\client;C:\DevSuiteHome_3\jre\1.4.2\bin;C:\Program Files\ThinkPad\Utilities;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Intel\Wireless\Bin\;C:\Program Files\ThinkPad\ConnectUtilitiessqlnet.log里面的错误信息是这样的:
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\DevSuiteHome_3\bin\frmweb.exe)(HOST=THINKPAD-T60)(USER=ThinkPad)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 - Production
Time: 23-1月 -2008 23:02:24
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS: 协议适配器错误
ns secondary err code: 0
nt main err code: 530
TNS-00530: 协议适配器错误
nt secondary err code: 126
nt OS err code: 0
如果还需要提供什么东西 请跟帖说明下~~~初学者~~惨呼~~~
先安装的是oracle 10g(10.2.0.1.0) 后安装的是Oracle Developer Suite 10.1.2.0.0
问题就出在这~~sql/plus 连接数据库没有任何问题,但是forms builder里面运行的时候 提示TNS:12560错误 奇怪的是在froms builder 里面建立数据块的时候登陆数据库也没有问题,为什么在运行例子的时候就报错呢?
小弟也在网上看了不少帖子,无奈基础太差。对于环境变量,tnsnames.ora的配置都不甚了解
环境变量path:
C:\oracle\product\10.2.0\db_1\bin;C:\DevSuiteHome_3\jdk\jre\bin\classic;C:\DevSuiteHome_3\jdk\jre\bin;C:\DevSuiteHome_3\jdk\jre\bin\client;C:\DevSuiteHome_3\jlib;C:\DevSuiteHome_3\bin;C:\DevSuiteHome_3\jre\1.4.2\bin\client;C:\DevSuiteHome_3\jre\1.4.2\bin;C:\Program Files\ThinkPad\Utilities;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Intel\Wireless\Bin\;C:\Program Files\ThinkPad\ConnectUtilitiessqlnet.log里面的错误信息是这样的:
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\DevSuiteHome_3\bin\frmweb.exe)(HOST=THINKPAD-T60)(USER=ThinkPad)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 - Production
Time: 23-1月 -2008 23:02:24
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS: 协议适配器错误
ns secondary err code: 0
nt main err code: 530
TNS-00530: 协议适配器错误
nt secondary err code: 126
nt OS err code: 0
如果还需要提供什么东西 请跟帖说明下~~~初学者~~惨呼~~~
安装Forms 6i 测试貌似一切正常~~真是迷惑~~
1 3 9 1 5 1 [email protected]
下面把几个配置文件贴出来:
**************************************************************************************
# sqlnet.ora Network Configuration File: C:\DevSuiteHome_3\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
**************************************************************************************
# tnsnames.ora Network Configuration File: C:\DevSuiteHome_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = THINKPAD-T60)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
**************************************************************************************
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
**************************************************************************************
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = THINKPAD-T60)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
**************************************************************************************
就是Forms Builder 运行的时候不行 建立数据块的时候都行
另外就是 Forms Builder连接数据库的时候 但输入用户名 密码没事 scott/tiger
但是要是加上数据库的名称就不行了 比如scott/tiger@orcl就提示解析错误
你Forms Builder的安装目录应该也有一个ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = THINKPAD-T60)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
) 把这句占过去试验一下
ORCL=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS =
(PROTOCOL=TCP)
(HOST=THINKPAD-T60)
(PORT=1521)
)
)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=orcl)
)
)
把上面的加进去,不要动原来里面的内容。