不可轻言放弃,否则对不起自己!
local_listener监听配置取值
上一篇 /
下一篇 2013-08-12 16:24:36
/ 个人分类:数据库
LISTENER_ORA =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.83.17)(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
)
)
ADR_BASE_LISTENER_ORA = /opt/oracle
oracle@MMSG:~/product/11gR2/db/network/admin> more tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/11gR2/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
MMSGDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MMSG)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.83.17)(PORT = 1526))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mmsgdb)
)
)
LISTENER_MMSGDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MMSG)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.83.17)(PORT = 1526))
)
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 8月 13 00:22:29 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_MMSGDB
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
local_listener参数要正确设置,否则会出现业务
数据库用户使用sid标示连接db时报TNS-12514错误,不使用sid连接时,正常,能登陆到db中
收藏
举报
TAG: