lunes, 20 de junio de 2016

Deshabilitar Log_File LISTENER

Si no es necesario en la función del servidor es mejor deshabilitar la función de log listener para evitar que la partición /u01 llegue al 100%.

En el log de listener se guardan todas las sesiones que ingresaron al servidor por el puerto que se tiene establecido por lo que no es tan recomendable quitar esta opción en ambientes productivos.


1)Validar ruta del log listener

bash-4.2$ lsnrctl show log_file;

LSNRCTL for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production on 20-JUN-2016 11:50:46

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(PORT=1521)))
LISTENER parameter "log_file" set to /u01/app/grid/diag/tnslsnr/<HOSTNAME>/listener/alert/log.xml
The command completed successfully

2) Deshabilitar el estado del log a OFF

bash-4.2$ lsnrctl set log_status off

LSNRCTL for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production on 20-JUN-2016 11:51:31

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(PORT=10521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully


3) Validar

bash-4.2$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production on 20-JUN-2016 11:51:35

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production
Start Date                20-JUN-2016 11:41:13
Uptime                    0 days 0 hr. 10 min. 21 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/app/grid/product/12.1.0/network/admin/listener.ora
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<HOSTNAME>)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<HOSTNAME>)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service......
The command completed successfully


No hay comentarios:

Publicar un comentario