Oracle Error:ORA-00119/ORA-00130

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>

--------------------------------------分割线 --------------------------------------

Oracle Error:ORA-12514

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

--------------------------------------分割线 --------------------------------------