主机名问题 先修改tnsname.ora,listener.ora看看不需要重新安装的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不用急,就两三步可以搞定. :)在 Oracle 里修改相关的文件,把名字改回来就可以了~解决方法: 1. 修改监听器的文件. ...Oracle目录 \Ora10\network\admin\listener.ora 把里头的 Host = ... 改你现在的计算机名就可以啦~ 2. 修改服务名文件. ...Oracle目录\Ora10\network\admin\tnsnames.ora 同样方法,把对应的 Host = ... 修改. 3. 重启机子就可以啦~ 另: 如果在配置 本地服务名 的时候,在 主机名 里输入IP地址的话,就没有这种情况. 但 IP 地址改变的话,还是要重配置. 需要修改listener.ora和tnsnames.ora里面的host名字,重新启动服务即可 我用的oracle8.0.5listeners.ora文件如下:################# Filename......: listener.ora# Node..........: local.world# Date..........: 24-MAY-94 13:23:20################LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= oracle.world) ) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL) ) (ADDRESS= (COMMUNITY= TCP.world) (PROTOCOL= TCP) (Host= hostname) (Port= 1521) ) )STARTUP_WAIT_TIME_LISTENER = 0CONNECT_TIMEOUT_LISTENER = 10TRACE_LEVEL_LISTENER = OFFSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = tftp) (PROGRAM = tftpd) ) (SID_DESC = (SID_NAME = sfinger) (PROGRAM = sfingerd) ) )PASSWORDS_LISTENER = (oracle)TNSNAMES.ORA文件如下:Beq-local.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = beq.world) (PROTOCOL = BEQ) (PROGRAM = oracle80) (ARGV0 = oracle80ORCL) (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) ) )tftp.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = hostname) (Port = 1521) ) ) (CONNECT_DATA = (SID = tftp) ) )sfinger.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = hostname) (Port = 1521) ) ) (CONNECT_DATA = (SID = sfinger) ) )这个要如何修改! Oracle 两表根据关联字段筛选数据 求一sql语句 oracle中建立唯一约束与唯一索引的区别 怎样在存储过程中让变量以结果集的方式显示出来? exp导出问题,很是郁闷! 一个触发器的问题,我想建一个触发器捕获用户建表的信息 ora-00600 oracle致命错误。 如何利用数据词典获得用户被授予的角色信息 急!!!!!!求SQL语句!!!!!!!! 急急急急急急急急急急,Oracle 9i的日志文件被我删除了,数据库启不来了,我该怎么办。 查询 怎样屏蔽查询DB_LINKS
在 Oracle 里修改相关的文件,把名字改回来就可以了~解决方法:
1. 修改监听器的文件.
...Oracle目录 \Ora10\network\admin\listener.ora
把里头的 Host = ... 改你现在的计算机名就可以啦~
2. 修改服务名文件.
...Oracle目录\Ora10\network\admin\tnsnames.ora
同样方法,把对应的 Host = ... 修改.
3. 重启机子就可以啦~ 另: 如果在配置 本地服务名 的时候,在 主机名 里输入IP地址的话,就没有这种情况.
但 IP 地址改变的话,还是要重配置.
listeners.ora文件如下:
################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= oracle.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= hostname)
(Port= 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = tftp)
(PROGRAM = tftpd)
)
(SID_DESC =
(SID_NAME = sfinger)
(PROGRAM = sfingerd)
)
)
PASSWORDS_LISTENER = (oracle)
TNSNAMES.ORA文件如下:
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(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)
)
)
tftp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = tftp)
)
)
sfinger.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = sfinger)
)
)这个要如何修改!