invalid specification for system parameter LOCAL_LISTENER

来源:互联网 发布:对网络教育的看法 编辑:程序博客网 时间:2024/05/18 13:47
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

0 0
原创粉丝点击