注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

金生丽水,雨润轩德

 
 
 

日志

 
 

Oracle 数据库 主机名与hosts解析不一致导致数据库及监听无法启动  

2014-05-08 09:51:08|  分类: oracle |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

在修改IP之后,将主机名也进行了修改,但与/etc/hosts文件中的名称不一致,导致系统无法启动。

[oracle@SZSJ-OracleDB-5177 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-MAY-2014 09:09:08

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /oracle/11g/oracle/product/11.2.0/szsjdb/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Log messages written to /oracle/11g/oracle/diag/tnslsnr/SZSJ-OracleDB-5177/listener/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
   Linux Error: 111: Connection refused

Listener failed to start. See the error message(s) above...

[oracle@SZSJ-OracleDB-5177 ~]$


[oracle@SZSJ-OracleDB-5177 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-MAY-2014 09:10:41

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
   Linux Error: 111: Connection refused
[oracle@SZSJ-OracleDB-5177 ~]$

[oracle@SZSJ-OracleDB-5177 dbs]$
[oracle@SZSJ-OracleDB-5177 dbs]$ env | grep  SID
ORACLE_SID=hrmis
[oracle@SZSJ-OracleDB-5177 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 8 09:19:38 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=SZSJ-OracleDB-5177)(PORT=1521))'
SQL> exit
Disconnected
[oracle@SZSJ-OracleDB-5177 dbs]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       SZSJ-OracleDB-5177test SZSJ-OracleDB-5177test.localdomain DBserver localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
[oracle@SZSJ-OracleDB-5177 dbs]$
[oracle@SZSJ-OracleDB-5177 dbs]$ cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=SZSJ-OracleDB-5177
[oracle@SZSJ-OracleDB-5177 dbs]$

  评论这张
 
阅读(844)| 评论(0)
推荐

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018