千家信息网

ORA-00130: invalid listener address

发表于:2024-11-18 作者:千家信息网编辑
千家信息网最后更新 2024年11月18日,一、环境描述suse 11 企业版 SP3 ,Oracle 11gR2 单实例二、问题修改主机名后,数据库无法启动三、问题处理1、现象mmpt-site:~ # su - oracleoracle@m
千家信息网最后更新 2024年11月18日ORA-00130: invalid listener address

一、环境描述
suse 11 企业版 SP3 ,Oracle 11gR2 单实例

二、问题
修改主机名后,数据库无法启动

三、问题处理

1、现象

mmpt-site:~ # su - oracleoracle@mmpt-site:~> sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 27 08:22:08 2018Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to an idle instance.SQL> SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-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-loopbackfe00::0         ipv6-localnetff00::0         ipv6-mcastprefixff02::1         ipv6-allnodesff02::2         ipv6-allroutersff02::3         ipv6-allhosts#192.168.1.11    suse11.site suse11192.168.1.11     mmpt-SRJ mmpt-SRJ~"/etc/hosts" 24L, 718C written                                                                         mmpt-SRJ:~ # su - oracleoracle@mmpt-SRJ:~> sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 27 08:36:14 2018Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to an idle instance.SQL> SQL> startupORACLE instance started.Total System Global Area  784998400 bytesFixed Size                  2217464 bytesVariable Size             465570312 bytesDatabase Buffers          314572800 bytesRedo Buffers                2637824 bytesDatabase mounted.Database opened.SQL> 
0