好长没有安装oracle了，今天安装一套11g的库，启动报错如下：
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=kvm-image)(PORT=1521))'

解决方法很简单，不过也记录一下。

解决方法1：
在参数文件里面增加如下参数：
*.local_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.155.20.90)))'

SQL> startup nomount;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2215064 bytes
Variable Size 503317352 bytes
Database Buffers 1627389952 bytes
Redo Buffers 4964352 bytes

解决方法2：
在/etc/hosts 文件里增加IP与主机名的对应关系：
10.155.20.90 kvm-image

SQL> startup nomount;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2215064 bytes
Variable Size 503317352 bytes
Database Buffers 1627389952 bytes
Redo Buffers 4964352 bytes

ITPub博客

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

最新文章