在OEM或SQL Plus中登陆成功,但在Form Builder中用数据库向导创建表或视图时连接数据库总是不成功? 找到d2k下面的tnsnames.ora (.../net80/admin)找到9i下面的tnsnames.ora (.../network/admin/)從9i下的把你的sid找出來copy 到 d2k的tnsnames.ora中就可以了呀!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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 文件中还是不行呀! 我在登陆时要求连接数据库填写的是NEW1.AUTO或new1都不行! 用ORACLE中的ODBC TEST 连接一下。 用ORACLE中的ODBC TEST 测试成功! 在测试的时候可以看到Oracle测试到的TNS Server Name有三项:Extproc_Connection_DataInst1_HTTPNEW1 我的OracleOraFormClientCache80服务启动不了!是不是跟它有关?每次都提示的错误是:在本地计算机无法启动OracleOraFormClientCache80服务!服务并未返回值,这可能是Windows的一个内部错误或服务内部错误!如果问题继续存在,请与你的系统管理员联系!另问:OracleOraFormClientCache80的功能是什么? 在关联两张表的时候,从数据库运行效率方面考虑,建主外键效率高还是建中间表效率高? 请问游标取数据的顺序? 国内外数据同步 所有类别中最大的为排序基准 如何实现? 关于ERP销售模块的开发思路!请高手指点下! 重求一个sql写法 请教一语句 oracle9i存储过程的问题 给大家几个下载书籍的网址 字符转化成日期用to_date()? pl/sql中插入记录的问题。 如何在sql plus中查看对象(table、index)的存储参数pctfree、pctUsed等?
# 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 文件中还是不行呀!
Extproc_Connection_Data
Inst1_HTTP
NEW1
服务并未返回值,这可能是Windows的一个内部错误或服务内部错误!
如果问题继续存在,请与你的系统管理员联系!另问:OracleOraFormClientCache80的功能是什么?