ORA-00130

更换了服务器的IP与主机名后启动Oracle服务报错：SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 14 13:51:39 2012 Copyright （c） 1982, 2010, Oracle. All rights reserved. SQL> conn / as sysdbaConnected to an idle instance.SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address "（ADDRESS=（PROTOCOL=TCP）（HOST=oracledbtest20）（PORT=1521））"SQL>解决方法如下：
1. 修改LOCAL_LISTENER参数
1.1 创建pfileSQL> conn / as sysdbaConnected to an idle instance.SQL> create pfile from spfile;File created.SQL> quitDisconnected1.2 修改pfile内容（如没有相关内容则添加至文件末尾）*.local_listener="（ADDRESS_LIST=（ADDRESS=（PROTOCOL=TCP）（HOST=Your IP）））"1.3 使用pfile启动Oracle服务SQL> conn / as sysdbaConnected to an idle instance.SQL> startup pfile="$ORACLE_HOME/dbs/init$ORACLE_SID.ora";ORACLE instance started.……Database mounted.Database opened.1.4 根据pfile建立新的spfileSQL> create spfile from pfile;File created.SQL> quit2. 重启SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.……Database mounted.Database opened.SQL>--------------------------------------分割线 --------------------------------------Oracle Error:ORA-12514 http://www.linuxidc.com/Linux/2014-09/107259.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址