# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
DEV =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVER = DEDICATED)
????? (SERVICE_NAME = dev)
??? )
? )
DBZH =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.157)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVICE_NAME = dbzh)
??? )
? )
INST1_HTTP =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(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)
??? )
? )
DB165 =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.165)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVICE_NAME = db165)
??? )
? )
1、執(zhí)行下面這個命令：
TNSPING? DB165
執(zhí)行結(jié)果：
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 21-12月-2
006 15:53:23
Copyright (c) 1997 Oracle Corporation.? All rights reserved.
已使用的參數(shù)文件:
E:\oracle\ora92\network\admin\sqlnet.ora
已使用 TNSNAMES 適配器來解析別名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.8.165)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = db165)))
OK（20毫秒）
已經(jīng)可以正常的連接了。
2、如果ORACLE8下面的客戶端工具無法使用了，現(xiàn)在可以通過修改這個文件來實現(xiàn)從從本機來連接高版本數(shù)據(jù)庫的作用。
3、在不同版本的oracle之間導(dǎo)入導(dǎo)出數(shù)據(jù)主義一個原則，需要用oracle低版本的工具導(dǎo)入導(dǎo)出數(shù)據(jù)。
?
posted on 2006-12-21 15:59
壞男孩 閱讀(2097)
評論(2) 編輯 收藏 所屬分類:
ORACLE篇章