荣耀彩票代理

IT技术互动交流平台

The listener supports no services The command completed successfully

作者:一起走过的日子  来源:IT165收集  发布日期:2016-11-24 21:07:55

荣耀彩票代理QIDONGJIANTINGCHUXIANYIXIACUOWUXINXI,ZHAOBUDAOFUWU.CUOWUXINXIRUXIA:

[oracle@dg1 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-NOV-2016 11:17:54

荣耀彩票代理Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

荣耀彩票代理STATUS of the LISTENER

荣耀彩票代理------------------------

荣耀彩票代理Alias                     LISTENER

Version                   TNSLSNR for Linux荣耀彩票代理: Version 11.2.0.1.0 - Production

Start Date                18-NOV-2016 11:15:22

Uptime                    0 days 0 hr. 2 min. 31 sec

Trace Level               off

荣耀彩票代理Security                  ON: Local OS Authentication

荣耀彩票代理SNMP                      OFF

Listener Parameter File   /u01/product/11.2.0.1/db_1/network/admin/listener.ora

Listener Log File         /u01/diag/tnslsnr/dg1/listener/alert/log.xml

荣耀彩票代理Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg1)(PORT=1521)))

荣耀彩票代理The listener supports no services

The command completed successfully

荣耀彩票代理[oracle@dg1 admin]$ 


JIEJUEFANGFA1:

荣耀彩票代理[oracle@dg1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 18 11:19:06 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

荣耀彩票代理Connected to an idle instance.

SQL> startup


Total System Global Area  830930944 bytes

Fixed Size                  2217912 bytes

Variable Size             545261640 bytes

荣耀彩票代理Database Buffers          281018368 bytes

Redo Buffers                2433024 bytes

荣耀彩票代理Database mounted.

Database opened.

荣耀彩票代理SQL> show parameter service_names

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

service_names                        string      tong

SQL> alter system register;    --QIANGXINGZHUCEJIANTING

System altered.

SQL> 

[oracle@dg1 admin]$ lsnrctl start    --QIDONGJIANTING


JIEJUEFANGFA2:

荣耀彩票代理[oracle@dg2 ~]$ vim /u01/product/11.2.0.1/db_1/network/admin/listener.ora

LISTENER =

荣耀彩票代理  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

荣耀彩票代理      (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))

    )

  )

荣耀彩票代理SID_LIST_LISTENER =          --TIANJIAYIXIAXING

(SID_LIST =

荣耀彩票代理  (SID_DESC =

荣耀彩票代理  (GLOBAL_DBNAME = orcl)

荣耀彩票代理  (SID_NAME = orcl)

  )

)

ADR_BASE_LISTENER = /u01

荣耀彩票代理[oracle@dg2 ~]$ lsnrctl start


Tag标签:                        
  • 专题推荐

About IT165 - 广告服务 - 隐私声明 - 版权申明 - 免责条款 - 网站地图 - 网友投稿 - 联系方式
本站内容来自于互联网,仅供用于网络技术学习,学习中请遵循相关法律法规