오라클 리스너 상태 확인 및 구동/정지 하기
[root@orcl bin]# su - oracle ----> 오라클 계정으로 변경
[oracle@orcl ~]$ lsnrctl status ----> 리스너 상태 확인
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 28-MAR-2018 05:41:49
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.mycompany.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 27-MAR-2018 16:48:48
Uptime 0 days 12 hr. 53 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.mycompany.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.mycompany.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@orcl ~]$ lsnrctl stop ----> 리스너 정지
[oracle@orcl ~]$ lsnrctl start ----> 리스너 실행
'배워서 남주자 > Data Base' 카테고리의 다른 글
[php-fpm] Oracle 연결 환경 변수 설정. (0) | 2018.03.30 |
---|---|
[oracle] 오라클 실행 / 중지 (1) | 2018.03.28 |
[Postgresql] 접속 제어 (0) | 2018.03.23 |
[Postgresql] 백업 / 복구 (0) | 2018.03.23 |
[postgresql] 초간단 명령어 설명. (0) | 2018.03.23 |