由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - >lsnrctl status 不解,为什么我的service 会有两个instance(s) LSNRCTL for Linux: Version 10.2.0.1.0 - Produc
相关主题
Oracle problems请教一个sqlplus的问题
Sql developer connection issuesql server 面试题 (1)
Error Code 01034?这种insert怎么做
能把MS SQL2000的大小写敏感功能关掉吗?How to prevent primary key collision for replication
oem instance manager怎么备份?
Mysql中怎么解决添加大型数据产生的问题搞定了八个节点11个instances SQL Server 2008 R2
oracle db connection through firewall数据库讲座 ---- 得给Beijing mm 还债了
请教ORACLE数据库中如何从一个INSTANCE中COPY一个TABLE到另一个INSTANCE。谢谢!请教一个问题
相关话题的讨论汇总
话题: instance话题: service话题: orctest话题: lsnrctl话题: status
进入Database版参与讨论
1 (共1页)
s****y
发帖数: 581
1
>lsnrctl status
不解,为什么我的service 会有两个instance(s)
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 31-AUG-2011 13:51:15
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=I2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 31-AUG-2011 13:48:09
Uptime 0 days 0 hr. 3 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10/network/admin/listener.ora
Listener Log File /opt/oracle/product/10/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=I2)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orctest" has 2 instance(s).
Instance "orctest", status UNKNOWN, has 1 handler(s) for this service...
Instance "orctest", status READY, has 1 handler(s) for this service...
Service "orctestXDB" has 1 instance(s).
Instance "orctest", status READY, has 1 handler(s) for this service...
Service "orctest_XPT" has 1 instance(s).
Instance "orctest", status READY, has 1 handler(s) for this service...
The command completed successfully
v*****r
发帖数: 1119
2
Service "orctest" has 2 instance(s).
Instance "orctest", status UNKNOWN, has 1 handler(s) for this service...
Instance "orctest", status READY, has 1 handler(s) for this service...
The first instance is the one you manually configured in listener.ora file,
the second is dynamically registered.
Remove the manual entry for orctest from listener.ora file, you don't need
that.

Production

【在 s****y 的大作中提到】
: >lsnrctl status
: 不解,为什么我的service 会有两个instance(s)
: LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 31-AUG-2011 13:51:15
: Copyright (c) 1991, 2005, Oracle. All rights reserved.
: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=I2)(PORT=1521)))
: STATUS of the LISTENER
: ------------------------
: Alias LISTENER
: Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
: Start Date 31-AUG-2011 13:48:09

1 (共1页)
进入Database版参与讨论
相关主题
请教一个问题oem instance manager
问个mysql的游标问题Mysql中怎么解决添加大型数据产生的问题
Pluggable Databases vs Database Virtualizationoracle db connection through firewall
请问:如何从windows single instance migrate to linux RAC请教ORACLE数据库中如何从一个INSTANCE中COPY一个TABLE到另一个INSTANCE。谢谢!
Oracle problems请教一个sqlplus的问题
Sql developer connection issuesql server 面试题 (1)
Error Code 01034?这种insert怎么做
能把MS SQL2000的大小写敏感功能关掉吗?How to prevent primary key collision for replication
相关话题的讨论汇总
话题: instance话题: service话题: orctest话题: lsnrctl话题: status