添加监听修改local_listener时报错ORA-00119、ORA-00132
系统:windows server 2008 r2
数据库:oracle 11.2.0.1
问题描述:在添加监听修改local_listener时报错ORA-00119、ORA-00132,如下所示:
SQL> show parameter local_list
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
local_listener string LISTENER_ORCL
SQL> alter system set local_listener='LISTENER_ORCL,LISTENER2';
alter system set local_listener='LISTENER_ORCL,LISTENER2'
*
第 1 行出现错误:
ORA-02097: 无法修改参数, 因为指定的值无效
ORA-00119: 系统参数 LOCAL_LISTENER 的说明无效
ORA-00132: 语法错误或无法解析的网络名称 'LISTENER_ORCL,LISTENER2'
解决方案:
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.192)(PORT = 1521))','(ADDRESS = (PR
OTOCOL = TCP)(HOST = 192.168.133.192)(PORT = 1561))';
系统已更改。
以下为tnsnames.ora文件.
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.192)(PORT = 1521))
LISTENER2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.192)(PORT = 1561))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.192)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
说明:LISTENER2为新添加监听.
版权声明
本文仅代表作者观点,不代表博信信息网立场。