오라클 명령어 모음
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