两个版本的oracle,怎么共存 我的机器上原来有oracle10的企业版,后来因为开发需要,在机器上装了oracle8的客户端,装了oracle8的客户端之后,oracle8的那些连接都可以用,但是oracle10配置的那些连接就连接不上了(通过PL/SQL工具可以连接,但是应用程序连接不上),请教一下,怎么我可以同时用这两个连接呢?或者改动哪些参数? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 将服务名配置统一到一个tnsnames.ora就可以了。 在客户端,把两个版本的tnsnames.ora配置信息放到一个里面 修改oracle_home环境变量,用控制面板->系统->高级->环境变量->新建变量名为ORACLE_HOME变量值为ORACLE10G对应的HOME然后再测试 我的两个tnsnames.ora文件分别在不同的目录下边,文件内容是这样的,请教一下怎么合并呢?oracle10的tnsnames.ora:# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.DAGWK20 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.193)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dagwk) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )oracle8的:# TNSNAMES.ORA Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLE8 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xq02)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = oracle8) ) )DAGWK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dagdb) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 把10中数据库名为DAGWK20的配置信息放到8中,要么把8中DAGWK的配置信息放到10中,你试试 你现在环境变量oracle_home应该是8的,将10的连接全部拷贝到8的文件中即可。 1、查看oracle_home2、将不在oracle_home下的oracle版本的tnsnames的内容添加到oracle_home指定的oracle版本的tnsnames中 pl/sql怎么显示泰文? plsql怎么导入dmp文件啊?我使用的是Oracle10 怎么样用一句SQL语句实现? 批量update ??急 关于ORACLE时间函数 agent启动不了? 装了微软补丁后,本机连本机的数据库就提示TNS错误 位图索引的问题 求助:我把一个表空间的数据文件给删了,就再也启动不了服务拉,详情请进行内 Help 急 求关于时间问题 SQL语句! 请问枫叶掌柜的,为什么这里的decode可以执行,不提示not a group by expression?谢谢
控制面板->系统->高级->环境变量->新建变量名为ORACLE_HOME
变量值为ORACLE10G对应的HOME然后再测试
oracle10的tnsnames.ora:
# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.DAGWK20 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.193)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dagwk)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
oracle8的:
# TNSNAMES.ORA Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORACLE8 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xq02)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle8)
)
)DAGWK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dagdb)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
2、将不在oracle_home下的oracle版本的tnsnames的内容添加到oracle_home指定的oracle版本的tnsnames中