Oracle00113,Oracle Error:ORA-00119/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 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>