ORA-00130: invalid listener address

发布时间:2020-07-23 07:50:59 作者:roidba
来源:网络 阅读:928

一、环境描述
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> 
推荐阅读:
  1. Oracle_DataGuard
  2. ORA-00119&ORA-00130&主机名

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

ora-00130 listener address

上一篇:有关windows黑屏的解决办法

下一篇:前端完整详细学习路线

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》