この記事は約12分24秒で読むことができます。

sql oracle listener 起動・停止

参考文献

http://www.sql-dbtips.com/listener/lsnrctl/


[oracle@c75932116d78 ~]$ lsnrctl

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 14-JAN-2019 18:25:44

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

Welcome to LSNRCTL, type "help" for information.

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

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

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date                13-JAN-2019 17:50:11
Uptime                    1 days 0 hr. 35 min. 48 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/18c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/c75932116d78/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=c75932116d78)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/admin/ORCL/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "7f5425dc31710c7ce053030011ac3d6a" has 1 instance(s).
  Instance "ORCL", status READY, 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 "pdb1" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

Listener Parameter File   /opt/oracle/product/18c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/c75932116d78/listener/alert/log.xml

[oracle@c75932116d78 ~]$ vi /opt/oracle/product/18c/dbhome_1/network/admin/listener.ora

LISTENER =
(DESCRIPTION_LIST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
  )
)

DEDICATED_THROUGH_BROKER_LISTENER=ON
DIAG_ADR_ENABLED = off

Oraclellgで導入されたXML形式のリスナーログ


[oracle@c75932116d78 ~]$ cd /opt/oracle/diag/tnslsnr/c75932116d78/listener/
[oracle@c75932116d78 listener]$ ll -la
total 0
drwxr-xr-x. 14 oracle oinstall 179 Jan 13 17:50 .
drwxr-xr-x.  3 oracle oinstall  22 Jan 13 17:50 ..
drwxr-xr-x.  2 oracle oinstall  21 Jan 13 17:50 alert
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 cdump
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 incident
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 incpkg
drwxr-xr-x.  2 oracle oinstall 150 Jan 13 17:50 lck
drwxr-xr-x.  4 oracle oinstall  31 Jan 13 17:50 log
drwxr-xr-x.  2 oracle oinstall 117 Jan 13 17:50 metadata
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 metadata_dgif
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 metadata_pv
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 stage
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 sweep
drwxr-xr-x.  2 oracle oinstall  26 Jan 13 17:50 trace
[oracle@c75932116d78 listener]$ ll -lta
total 0
drwxr-xr-x.  2 oracle oinstall 117 Jan 13 17:50 metadata
drwxr-xr-x.  2 oracle oinstall 150 Jan 13 17:50 lck
drwxr-xr-x.  2 oracle oinstall  21 Jan 13 17:50 alert
drwxr-xr-x.  2 oracle oinstall  26 Jan 13 17:50 trace
drwxr-xr-x. 14 oracle oinstall 179 Jan 13 17:50 .
drwxr-xr-x.  3 oracle oinstall  22 Jan 13 17:50 ..
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 cdump
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 incident
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 incpkg
drwxr-xr-x.  4 oracle oinstall  31 Jan 13 17:50 log
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 metadata_dgif
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 metadata_pv
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 stage
drwxr-xr-x.  2 oracle oinstall   6 Jan 13 17:50 sweep
[oracle@c75932116d78 listener]$ cd trace
[oracle@c75932116d78 trace]$ ll
total 32
-rw-r-----. 1 oracle oinstall 32483 Jan 14 18:34 listener.log
[oracle@c75932116d78 trace]$ vi *.log
[oracle@c75932116d78 trace]$ cd ../alert
[oracle@c75932116d78 alert]$ ll
total 92
-rw-r-----. 1 oracle oinstall 89021 Jan 14 18:34 log.xml
[oracle@c75932116d78 alert]$ vi *.xml
[oracle@c75932116d78 alert]$ pwd
/opt/oracle/diag/tnslsnr/c75932116d78/listener/alert
[oracle@c75932116d78 alert]$ cd ../trace
[oracle@c75932116d78 trace]$ pwd
/opt/oracle/diag/tnslsnr/c75932116d78/listener/trace
[oracle@c75932116d78 trace]$ cd ../log
[oracle@c75932116d78 log]$ pwd
/opt/oracle/diag/tnslsnr/c75932116d78/listener/log

Leave a Reply

Your email address will not be published. Required fields are marked *