오라클 명령어 모음

lsnrctl help [명령어]
lsnrctl start [시작]
lsnrctl stop [종료]작
lsnrctl status [상태]
lsnrctl services [서비스]
lsnrctl version [버전]
lsnrctl reload [재시작]


$ lsnrctl help

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 12-DEC-2012 16:28:33

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

The following operations are available
An asterisk (*) denotes a modifier or extended command:

start               stop                status              
services            version             reload              
save_config         trace               spawn               
change_password     quit                exit                
set*                show*               


$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 12-DEC-2012 16:29:05

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date                06-JUL-2012 01:09:49
Uptime                    159 days 15 hr. 19 min. 17 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   생략/listener.ora
Listener Log File         /oracle/diag/tnslsnr/ㅌㅌㅌㅌ/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ㅌㅌㅌ)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ㅌㅌㅌ" has 2 instance(s).
  Instance "ㅌㅌㅌ", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ㅌㅌㅌ", status READY, has 11 handler(s) for this service...
The command completed successfully

댓글
  • No Nickname
    No Comment
  • 권한이 없습니다.
    {{m_row.m_nick}}
    -
목록형 📷 갤러리형
제목
[기본형] HTML (with 부트스트랩5.3 , jquery 3.7, vue.js)
유용한 리눅스(LINUX) 명령어
[공지] 기술 게시판
3.31
4.1
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.10
4.11
4.12
4.13
4.14
4.15
4.16
4.18
4.19
4.20
4.21
4.22
4.23
4.24
4.25
4.26
4.27
4.28
4.29
4.30
5.1
5.2
5.3
5.4