오라클 명령어 모음

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}}
    -
제목 작성자 날짜
공대여자
공대여자
mins01
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자
공대여자