我的编程空间,编程开发者的网络收藏夹
学习永远不晚

ORA-00130: invalid listener address

短信预约 -IT技能 免费直播动态提醒
省份

北京

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团
手机号立即预约

请填写图片验证码后获取短信验证码

看不清楚,换张图片

免费获取短信验证码

ORA-00130: invalid listener address

一、环境描述
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

ORA-00130: invalid listener address

下载Word文档到电脑,方便收藏和打印~

下载Word文档

猜你喜欢

ORA-24045: invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE

文档解释ORA-24045: invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]Cause: An
ORA-24045: invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE
2023-11-05

ORA-08234: smsget: cannot get instance listener address ORACLE 报错 故障修复 远程处理

文档解释ORA-08234: smsget: cannot get instance listener addressCause: The instance listener address cannot be read from the
ORA-08234: smsget: cannot get instance listener address ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-24915: Cannot start Listener at specified IP address ORACLE 报错 故障修复 远程处理

文档解释ORA-24915: Cannot start Listener at specified IP addressCause: Thread was already listening at a different IP
ORA-24915: Cannot start Listener at specified IP address ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-12074: invalid memory address ORACLE 报错 故障修复 远程处理

文档解释ORA-12074: invalid memory addressCause: An attempt was made to access an invalid memory region.Action: Reconnect
ORA-12074: invalid memory address ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-13838: invalid ADDRESS value ORACLE 报错 故障修复 远程处理

文档解释ORA-13838: invalid ADDRESS valueCause: An invalid ADDRESS value was passed to a create SQL profile
ORA-13838: invalid ADDRESS value ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-31146: Invalid listener source string.string ORACLE 报错 故障修复 远程处理

文档解释ORA-31146: Invalid listener source string.stringCause: The listener source specified in the resource configuration
ORA-31146: Invalid listener source string.string ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-56865: Invalid IP address in CELLINIT.ORA ORACLE 报错 故障修复 远程处理

文档解释ORA-56865: Invalid IP address in CELLINIT.ORACause: One or more of the specified IP addresses in CELLINIT.ORA is
ORA-56865: Invalid IP address in CELLINIT.ORA ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-48138: invalid directory name input for client address ORACLE 报错 故障修复 远程处理

文档解释ORA-48138: invalid directory name input for client addressCause: An invalid directory name was specified as part of
ORA-48138: invalid directory name input for client address ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-25163: Invalid tablespace number or relative data block address ORACLE 报错 故障修复 远程处理

文档解释ORA-25163: Invalid tablespace number or relative data block addressCause: The relative data block adress is invalid
ORA-25163: Invalid tablespace number or relative data block address ORACLE 报错 故障修复 远程处理
2023-11-04

ORA-25216: invalid recipient, either NAME or ADDRESS must be specified ORACLE 报错 故障修复 远程处理

文档解释ORA-25216: invalid recipient, either NAME or ADDRESS must be specifiedCause: Both attributes, NAME and ADDRESS,
ORA-25216: invalid recipient, either NAME or ADDRESS must be specified ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-30154: The memory address given as buffer for OCIFileRead/Write is invalid ORACLE 报错 故障修复 远程处理

文档解释ORA-30154: The memory address given as buffer for OCIFileRead/Write is invalidCause: An invalid memory address is
ORA-30154: The memory address given as buffer for OCIFileRead/Write is invalid ORACLE 报错 故障修复 远程处理
2023-11-04

编程热搜

目录