Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2783150
  • 博文数量: 423
  • 博客积分: 7770
  • 博客等级: 少将
  • 技术积分: 4766
  • 用 户 组: 普通用户
  • 注册时间: 2006-11-09 11:58
个人简介

Oracle/DB2/Postgresql/Mysql/Hadoop/Greenplum/Postgres-xl/Mongodb

文章分类

全部博文(423)

文章存档

2019年(3)

2018年(6)

2017年(27)

2016年(23)

2015年(30)

2014年(16)

2013年(31)

2012年(73)

2011年(45)

2010年(14)

2009年(30)

2008年(30)

2007年(63)

2006年(32)

分类: Oracle

2015-12-10 14:16:32

[oracle@localhost admin]$ more listener.ora
# listener.ora Network Configuration File: /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )


SID_LIST_LISTENER2 =
  ( SID_LIST =
      (SID_DESC =
         (GLOBAL_DBNAME = Ora10)
         (SID_NAME = orcl)
      )
  )




LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 108.88.3.93)(PORT = 1522))
      )
  )




LISTENER2 =
  ( DESCRIPTION =
     (ADDRESS = (HOST = 108.88.3.93)(PROTOCOL = TCP)(PORT = 1523))
  )
[oracle@localhost admin]$ 

[oracle@localhost admin]$ lsnrctl


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2015 06:05:37


Copyright (c) 1991, 2005, Oracle.  All rights reserved.


Welcome to LSNRCTL, type "help" for information.


LSNRCTL> start LISTENER2
Starting /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...


TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523)))


Connecting to (DESCRIPTION=(ADDRESS=(HOST=108.88.3.93)(PROTOCOL=TCP)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER2
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                10-DEC-2015 06:05:44
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523)))
Services Summary...
Service "Ora10" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status LISTENER2
Connecting to (DESCRIPTION=(ADDRESS=(HOST=108.88.3.93)(PROTOCOL=TCP)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER2
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                10-DEC-2015 06:05:44
Uptime                    0 days 0 hr. 0 min. 8 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523)))
Services Summary...
Service "Ora10" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> 


阅读(3090) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~