ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hoho-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)请教个问题,DB在本机,tnsnames.ora中 HOST 这个参数,以下四种写法有啥区别?HOST = hoho-PC
HOST = localhost
HOST = 127.0.0.1
HOST = 192.x.x.x(内网IP)多谢!
四种写法没什么本质区别,listener.ora 和 tnsnames.ora 保持一致就可以了。
多谢哈 如果用net M 建立文件后, 默认的是PC name,那如果修改后 会出现问题么?
我不太确定是不是我的个案~~ 你试着修改一下 比如把HOST = hoho-PC
修改为 HOST = 127.0.0.1
会出现问题么?
我不太确定是不是我的个案~~
===> 我成过我电脑的内网IP,为了让别人能够连接,没问题。你试着修改一下 比如把HOST = hoho-PC
修改为 HOST = 127.0.0.1
====> 没问题,只要一致没什么问题。C:\Documents and Settings\Administrator>tnsping orclTNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-8月 -2011 11:08:28Copyright (c) 1997, 2005, Oracle. All rights reserved.已使用的参数文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (50 毫秒)
如果不一致,比如listener.ora中用pc name
tnsnames.ora中127.0.0.1 为啥会报错呢?
今天改来改去 又不会出问题了·~
可能是那天别的参数改错了·