ORA-00130: invalid listener address
短信预约 -IT技能 免费直播动态提醒
一、环境描述
suse 11 企业版 SP3 ,Oracle 11gR2 单实例
二、问题
修改主机名后,数据库无法启动
三、问题处理
1、现象
mmpt-site:~ # su - oracle
oracle@mmpt-site:~> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 27 08:22:08 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=mmpt-site)(PORT=1521))'
SQL>
2、处理
修改主机名的同时,要修改IP与主机名对应关系。
mmpt-SRJ:~ # vi /etc/hosts
#
# hosts This file describes a number of hostname-to-address
# mappings for the TCP/IP subsystem. It is mostly
# used at boot time, when no name servers are running.
# On small systems, this file can be used instead of a
# "named" name server.
# Syntax:
#
# IP-Address Full-Qualified-Hostname Short-Hostname
#
127.0.0.1 localhost
# special IPv6 addresses
::1 localhost ipv6-localhost ipv6-loopback
fe00::0 ipv6-localnet
ff00::0 ipv6-mcastprefix
ff02::1 ipv6-allnodes
ff02::2 ipv6-allrouters
ff02::3 ipv6-allhosts
#192.168.1.11 suse11.site suse11
192.168.1.11 mmpt-SRJ mmpt-SRJ
~
"/etc/hosts" 24L, 718C written
mmpt-SRJ:~ # su - oracle
oracle@mmpt-SRJ:~> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 27 08:36:14 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 784998400 bytes
Fixed Size 2217464 bytes
Variable Size 465570312 bytes
Database Buffers 314572800 bytes
Redo Buffers 2637824 bytes
Database mounted.
Database opened.
SQL>
免责声明:
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341