# 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、執行下面這個命令：
TNSPING? DB165
執行結果：
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.
已使用的參數文件:
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毫秒）
已經可以正常的連接了。
2、如果ORACLE8下面的客戶端工具無法使用了，現在可以通過修改這個文件來實現從從本機來連接高版本數據庫的作用。
3、在不同版本的oracle之間導入導出數據主義一個原則，需要用oracle低版本的工具導入導出數據。
?
posted on 2006-12-21 15:59
壞男孩 閱讀(2095)
評論(2) 編輯 收藏 所屬分類:
ORACLE篇章