更换了服务器的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 sysdba
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=oracledbtest20)(PORT=1521))'
SQL>
解决方法如下：
1. 修改LOCAL_LISTENER参数
1.1 创建pfile
SQL> conn / as sysdba
Connected to an idle instance.
SQL> create pfile from spfile;
File created.
SQL> quit
Disconnected
1.2 修改pfile内容(如没有相关内容则添加至文件末尾)
*.local_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Your IP)))'
1.3 使用pfile启动Oracle服务
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup pfile='$ORACLE_HOME/dbs/init$ORACLE_SID.ora';
ORACLE instance started.
……
Database mounted.
Database opened.
1.4 根据pfile建立新的spfile
SQL> create spfile from pfile;
File created.
SQL> quit
2. 重启
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
……
Database mounted.
Database opened.
SQL>
--------------------------------------分割线 --------------------------------------
Oracle Error:ORA-12514
在CentOS 6.4下安装Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虚拟机中安装步骤
Debian 下 安装 Oracle 11g XE R2
--------------------------------------分割线 --------------------------------------
：