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
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
- invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119,ORA-00132 invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- 升级日志20120327_ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- 改主机名后:ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- 解决oracle11g ORA-00119 ORA-00132方法 invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unre
- oracle 11g 报 ORA-00119: invalid specification for system parameter LOCAL_LISTENER错误
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unre
- ORA-00119: invalid specification for system parameter 错误解决办法
- ORA-00119: invalid specification for system parameter REMOTE_LISTENER
- ORA-00119: invalid specification for system parameter 解决
- SEO中TDK写法的意思以及注意事项
- oracle 内部错误参考信息
- ruby on rails mac 基本配置
- 代码洁癖
- android加载网页隐藏某些内容
- invalid specification for system parameter LOCAL_LISTENER
- iOS使用Xcode7的Instruments检测解决iOS内存泄露
- MyEclipse 2015优化技巧
- 选择排序
- Spaly选讲……哦不,Splay
- 深入理解Javascript面向对象编程
- C++操作符重载 友元基础教程
- Java Lambda表达式入门
- Arraylist