请问修改IP地址后Oracle9i就不能用了,为什么? 连接时,提示错误:ORA-12535:TNS:超时连接. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 需要重新设置listener中的相应参数LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 2481)) ) )修改之后用lsnrctl停监听stop,后start之后你再看看! 检查oracle安装目录下的network\admin\tnsnames.ora文件里的配置.按照menxs的进行修改 listener中HOST修改为当前的IP或主机名 $ORACLE_HOME/network/admin/listener.ora文件 HOST=hostname,看看主机名是否正确,也可以是IPLISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ) )$ORACLE_HOME/network/admin/tnsnames.ora文件中HOST = 192.168.0.1,IP是否正确ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) 是主机无法使用,还是客户端无法使用?--------------------------------------------------------------一般情况下,修改IP是不会影响你的Oracle启动和关闭的,一旦修改IP,可以重新启动你的Oracle实例和监听即可,参考一下配置文件:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 机器名)(PORT = 1521)) ) ) )Oracle默认安装时,主机是按机器名走的,所以修改IP基本不会影响使用,但如果你的listener.ora文件中出现如下配置时才会发生无法监听:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521)) ) ) )++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++如果你修改的是机器名,那么就需要重新配置监听器 查看Listener.ora 以及 tnsnames.ora 安装Oracle10g出现的问题? 求一条oracle替换字符串的语句 怎么让 defaut sysdate 中让它不显示时间 有两个表,表结构都一样,我想把这两个表select *的结果集合并到一个结集中,请问如何写? ORA-01200错误的处理! ****为何以下语句运行不了,急急急急(分数不够可以在加)**** 什么样的语句可以不放在begin end块中 数据库移植问题? 关于pro*c中加入pl/sql trigger 触发器 编译错误问题 三个问题,谢谢! 100分求实现这样的查询的SQL语句怎么写 [散分]郁闷
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 2481))
)
)
修改之后用lsnrctl停监听stop,后start之后你再看看!
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)$ORACLE_HOME/network/admin/tnsnames.ora文件中HOST = 192.168.0.1,IP是否正确
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
一般情况下,修改IP是不会影响你的Oracle启动和关闭的,一旦修改IP,可以重新启动你的Oracle实例和监听即可,参考一下配置文件:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 机器名)(PORT = 1521))
)
)
)Oracle默认安装时,主机是按机器名走的,所以修改IP基本不会影响使用,但如果你的listener.ora文件中出现如下配置时才会发生无法监听:LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
)
)
)++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
如果你修改的是机器名,那么就需要重新配置监听器