在OEM或SQL Plus中登陆成功，但在Form Builder中用数据库向导创建表或视图时连接数据库总是不成功？

jhyu119 2003-02-19 10:31:49

在OEM或SQL Plus中登陆成功，但在Form Builder中用数据库向导创建表或视图时连接数据库总是不成功？总是提示：ORA－12154：TNS：无法处理服务名。

...全文

66 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

jhyu119 2003-02-19

打赏
举报

我的OracleOraFormClientCache80服务启动不了！是不是跟它有关？每次都提示的错误是：

在本地计算机无法启动OracleOraFormClientCache80服务！
服务并未返回值，这可能是Windows的一个内部错误或服务内部错误！
如果问题继续存在，请与你的系统管理员联系！

另问：OracleOraFormClientCache80的功能是什么？

jhyu119 2003-02-19

打赏
举报

在测试的时候可以看到Oracle测试到的TNS Server Name有三项：
Extproc_Connection_Data
Inst1_HTTP
NEW1

jhyu119 2003-02-19

打赏
举报

用ORACLE中的ODBC TEST 测试成功！

benxie 2003-02-19

打赏
举报

用ORACLE中的ODBC TEST 连接一下。

jhyu119 2003-02-19

打赏
举报

我在登陆时要求连接数据库填写的是NEW1.AUTO或new1都不行！

jhyu119 2003-02-19

打赏
举报

9i下面的tnsnames.ora 的文件如下：
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

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

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

NEW1.AUTO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jhyu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = new1)
)
)

d2k下面的tnsnames.ora　的文件如下：
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)

我将9i下面的tnsnames.ora文件中的
NEW1.AUTO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jhyu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = new1)
)
)
拷贝到d2k下面的tnsnames.ora　文件中还是不行呀！

vongates968 2003-02-19