oracle与developer 连接的问题?

[nyliuhaiyang]

我的DB是ORACLE 9I,DEVELOPER是6.

要实现它们的连接,听说有两种方法.
一种是用net8 easy configue配置;
一种是修改文件:TNSNAMES.ORA

我试了多次,都没有实现.
我在开始菜单里找不到net8 easy configue.
所以也没办法配置.文件:TNSNAMES.ORA如下:
请高手指点:ORACLE下的TNSNAMES.ORA文件:

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

MYSWDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = swdb)
)
)


INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lhy)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)



DEVELOPER下的# TNSNAMES.ORA 如下:


Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
NmpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION=(address_list=
(ADDRESS=
(PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
(ADDRESS=
(PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
(CONNECT_DATA=(SID=ORCL))
(SOURCE_ROUTE=yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC0)
)
(CONNECT_DATA = (SID = extproc)
)
)

请高手指点,将不胜感激?怎么修改.

[nyliuhaiyang]

谁能给我说为什么??

我都晕了.

[kerisyml]

用net8 easy configue配置或者修改TNSNAMES.ORA的目的无非都是创建一个服务名。
在Oracle9i中菜单中不是net8 easy configue，好像是Net Configuration Assistant。

另外你只要在TNSNAMES.ORA多添加一个服务名即可
Name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = swdb)
)
)

[nyliuhaiyang]

谢谢你的回贴:

[nyliuhaiyang]

谢谢你的回贴:
我想让ORACLE DB 与 DEVELOPER下面的FORM BUILDER 和 REPORT BUILDER相接.
上面的方去应该是新加一个数据库的名称,不会使这两都相连.
我的ORCLE没有问题,用TOAD能够连上,FORM BUILDER怎么就连不上呢?

[snowy_howe]

用TOAD连接时在最上面那个database（数据库）参数你输入的什么，
那么在用form builder时在连接字符串中用什么！
另外提示你：
kerisyml(魂之利刃) 的修改不是新建数据库
而是建立到数据库的映射，以便developer能够根据这个名称
去找到数据库服务器的地址和oracle服务。

[xinpingf]

首先：请说明你的db和form是否在同一机器上~

需要配置的net8或者tnsnames.ora都是form里的，不要去管db的~

[xinpingf]

另外：是form和report去连接db,而不是db去连接form

[nyliuhaiyang]

我的DB和FORM,REPORT是在一台机器上.
我在TOAD的参数:
数据库名称: MYSWDB
用户名: AP01
密码: QWEASD
只在DEVELOPER下面加上这个映谢就够了吗？

[nyliuhaiyang]

错误:TNS:could not resolve service name

[snowy_howe]

你在你的form,report的安装目录下，找到/net8/admin/tnsnames.ora
按照kerisyml(魂之利刃)的格式配置一个
Name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = swdb)
)
)

name 填一个自己想要的，host填ip，service_name填数据库SID，试试看。