ORA-00119: invalid specification for system parameter LOCAL_LISTENER
来源:互联网 发布:淘宝最新photoshop 编辑:程序博客网 时间:2024/05/18 11:46
Today morning, when i tried to startup our production database, it shows following errors
SQL> STARTUP
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’
I was struggled with these erros and finally i was fixed this errors with help of Mr.Surachart opunhttp://surachartopun.com . He given solutions and fixed easily. Thanks Mr.Surachart.
How was i did it?
My tnsnames file :
BROKER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BROKER)
)
)
and My listener.ora file.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress )(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
and now i tired to startup my db, the below error shown.
SQL> STARTUP
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’
So i fixed in tnsnames.ora file and then now its working.
LISTENER_BROKER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BROKER)
)
)
After i fixed this listener_broker in tnsnames.ora file, the database up sucessfully.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 1912602624 bytes
Fixed Size 2005192 bytes
Variable Size 369100600 bytes
Database Buffers 1526726656 bytes
Redo Buffers 14770176 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
———
BROKER
- 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
- 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
- 解决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
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unre
- invalid specification for system parameter LOCAL_LISTENER
- 改主机名后:ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- oracle 11g 报 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 错误解决办法
- ORA-00119: invalid specification for system parameter REMOTE_LISTENER
- ORA-00119: invalid specification for system parameter 解决
- qt excel 网站链接
- 80后男生:女友薪水越来越高怎么办(你还会爱我吗)
- 取消某内置输入法
- 什么是软件架构?
- java.math.BigDecimal使用示例
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- Cannot open include file: 'd3dx9.h' 错误
- lable picturebox等控件背景颜色透明
- python算法--置换选择排序详细实现
- JAVA客户端调用memcached比较
- Understanding Factory Method and Abstract Factory Patterns(理解工厂方法模式和抽象工厂模式)
- Java内存溢出的详细解决方案
- 修改不能预置开关机动画问题
- 软件加壳的简易实现方式