暂无图片
暂无图片
12
暂无图片
暂无图片
1
暂无图片
首页 / Oracle RAC 清理相关日志

Oracle RAC 清理相关日志

原创 晨辉 2022-08-22
8531

适用范围

Oracle 12C-19C

概述

RAC数据库运行时间久了发现本地磁盘剩余空间下降到了预警值，此时需要删除历史相关日志以释放磁盘空间，保障系统稳定运行。

操作步骤

注：以下操作在RAC多个节点都要执行。

1） 清理审计日志

审计日志位置

数据库实例审计日志位置：

可以登录数据库实例，show paramerter audit 查看audit_file_dest参数值

SYS@orcl1>show parameter audit;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/app/oracle/admin/orcl/adump
audit_sys_operations                 boolean     TRUE
audit_syslog_level                   string
audit_trail                          string      DB
unified_audit_common_systemlog       string
unified_audit_sga_queue_size         integer     1048576
unified_audit_systemlog              string

复制

ASM实例审计日志位置：

可以登录ASM实例，show paramerter audit 查看audit_file_dest参数值

SQL> show parameter audit;

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
audit_file_dest                      string                 /u01/app/19.3.0/grid/rdbms/audit
audit_sys_operations                 boolean                TRUE
audit_syslog_level                   string
audit_trail                          string                 NONE
unified_audit_sga_queue_size         integer                1048576

复制

清理数据库审计日志

#使用root用户或者oracle用户执行，-mtime +3 是清理3天前的日志文件，如需保留更多天数，可修改该值
cd /u01/app/oracle/admin/orcl/adump/   
ls |wc -l
ls -lrt|head -10 
find . -mtime +3 -type f -name "*.aud" |xargs rm -rf
ls |wc -l
ls -lrt|head -10

复制

示例：

[root@ora19crac1 audit]# cd /u01/app/oracle/admin/orcl/adump/
[root@ora19crac1 adump]# ls |wc -l                           
198
[root@ora19crac1 adump]# ls -lrt|head -10                    
total 13680
-rw-r----- 1 oracle asmadmin     867 Apr 27  2020 orcl1_ora_27093_20200427150323625841608381.aud
-rw-r----- 1 oracle asmadmin    8210 Apr 27  2020 orcl1_ora_28163_20200427150323944626945847.aud
-rw-r----- 1 oracle asmadmin    2678 Apr 27  2020 orcl1_ora_30656_20200427150437063733912438.aud
-rw-r----- 1 oracle asmadmin    2678 Apr 27  2020 orcl1_ora_30653_20200427150437065541988321.aud
-rw-r----- 1 oracle asmadmin    3046 Apr 27  2020 orcl1_ora_30658_20200427150437067309947251.aud
-rw-r----- 1 oracle asmadmin    3046 Apr 27  2020 orcl1_ora_30677_20200427150438739530264934.aud
-rw-r----- 1 oracle asmadmin    6933 Apr 27  2020 orcl1_ora_30670_20200427150438402792242906.aud
-rw-r----- 1 oracle asmadmin    3042 Apr 27  2020 orcl1_ora_554_20200427150526493620551772.aud
-rw-r----- 1 oracle asmadmin    3042 Apr 27  2020 orcl1_ora_685_20200427150527979655761360.aud
[root@ora19crac1 adump]# 
[root@ora19crac1 adump]# find . -mtime +3 -type f -name "*.aud" |xargs rm -rf
[root@ora19crac1 adump]# 
[root@ora19crac1 adump]# ls |wc -l   
14

复制

清理ASM审计日志

#使用root用户或者grid用户执行，-mtime +3 是清理3天前的日志文件，如需保留更多天数，可修改该值
cd /u01/app/19.3.0/grid/rdbms/audit/
ls |wc -l
ls -lrt|head -10
find . -mtime +3 -type f -name "*.aud" |xargs rm -rf
ls |wc -l
ls -lrt|head -10

复制

示例：

[root@ora19crac1 ~]# cd /u01/app/19.3.0/grid/rdbms/audit/
[root@ora19crac1 audit]# ls |wc -l
8490
[root@ora19crac1 audit]# ls -lrt|head -10
total 33964
-rw-r----- 1 grid oinstall  816 Apr 27  2020 +ASM1_ora_25395_20200427150209390706516328.aud
-rw-r----- 1 grid oinstall  850 Apr 27  2020 +ASM1_ora_25395_20200427150225057374055964.aud
-rw-r----- 1 grid oinstall  857 Apr 27  2020 +ASM1_ora_26023_20200427150225247909285932.aud
-rw-r----- 1 grid oinstall  857 Apr 27  2020 +ASM1_ora_26290_20200427150235496955889812.aud
-rw-r----- 1 grid oinstall  857 Apr 27  2020 +ASM1_ora_26295_20200427150235635170703067.aud
-rw-r----- 1 grid oinstall  857 Apr 27  2020 +ASM1_ora_26300_20200427150235732891454289.aud
-rw-r----- 1 grid oinstall  857 Apr 27  2020 +ASM1_ora_26328_20200427150237308635974561.aud
-rw-r----- 1 grid oinstall  857 Apr 27  2020 +ASM1_ora_26330_20200427150237339497010358.aud
-rw-r----- 1 grid oinstall  857 Apr 27  2020 +ASM1_ora_26542_20200427150244382973514557.aud
[root@ora19crac1 audit]# 
[root@ora19crac1 audit]# find . -mtime +3 -type f -name "*.aud" |xargs rm -rf
[root@ora19crac1 audit]# 
[root@ora19crac1 audit]# ls |wc -l
44
[root@ora19crac1 audit]# ls -lrt|head -10
total 176
-rw-r----- 1 grid oinstall 814 Aug 20 11:10 +ASM1_ora_6525_20220820111021894623958065.aud
-rw-r----- 1 grid oinstall 848 Aug 20 11:10 +ASM1_ora_6525_20220820111038056135557491.aud
-rw-r----- 1 grid oinstall 855 Aug 20 11:10 +ASM1_ora_6733_20220820111038134165027400.aud
-rw-r----- 1 grid oinstall 855 Aug 20 11:10 +ASM1_ora_6802_20220820111048347568507960.aud
-rw-r----- 1 grid oinstall 855 Aug 20 11:10 +ASM1_ora_6809_20220820111048626520514941.aud
-rw-r----- 1 grid oinstall 855 Aug 20 11:10 +ASM1_ora_6830_20220820111049858229622677.aud
-rw-r----- 1 grid oinstall 855 Aug 20 11:10 +ASM1_ora_6835_20220820111050097486164720.aud
-rw-r----- 1 grid oinstall 855 Aug 20 11:10 +ASM1_ora_6839_20220820111050289642832065.aud
-rw-r----- 1 grid oinstall 855 Aug 20 11:10 +ASM1_ora_6855_20220820111051924704643995.aud

复制

2） 清理trace日志

清理CRS trace日志

su - grid
cd $ORACLE_BASE/diag/crs/$HOSTNAME/crs/trace/
ls |wc -l
ls -lrt|head -10
find . -mtime +3 -type f -name "*.trm" |xargs rm -rf
find . -mtime +3 -type f -name "*.trc" |xargs rm -rf
ls |wc -l
ls -lrt|head -10

复制

示例：

[grid@ora19crac2 trace]$ cd 
[grid@ora19crac2 ~]$ cd $ORACLE_BASE/diag/crs/$HOSTNAME/crs/trace/
[grid@ora19crac2 trace]$ ls |wc -l
513
[grid@ora19crac2 trace]$ ls -lrt|head -10
total 1266184
-rw-rw---- 1 root   oinstall  2453379 Apr 27  2020 ologgerd.trm
-rw-rw---- 1 root   oinstall 14681557 Apr 27  2020 ologgerd.trc
-rw-rw---- 1 grid   oinstall  7266935 Apr 30  2020 ocssd_1.trm
-rw-rw---- 1 grid   oinstall 52438517 Apr 30  2020 ocssd_1.trc
-rw-rw---- 1 root   oinstall  4369015 Apr 30  2020 ohasd_orarootagent_root_1.trm
-rw-rw---- 1 root   oinstall 26215585 Apr 30  2020 ohasd_orarootagent_root_1.trc
-rw-rw---- 1 grid   oinstall  4528217 May 12  2020 crsd_oraagent_grid_1.trm
-rw-rw---- 1 grid   oinstall 26215285 May 12  2020 crsd_oraagent_grid_1.trc
-rw-rw---- 1 grid   oinstall  7365901 May 12  2020 ocssd_2.trm
[grid@ora19crac2 trace]$ find . -mtime +3 -type f -name "*.trm" |xargs rm -rf
[grid@ora19crac2 trace]$ find . -mtime +3 -type f -name "*.trc" |xargs rm -rf
[grid@ora19crac2 trace]$ ls |wc -l
189
[grid@ora19crac2 trace]$ ls -lrt|head -10
total 279236
-rw-rw---- 1 root   oinstall     1507 Aug 20 11:08 crsctl_4805.trm
-rw-rw---- 1 root   oinstall     8169 Aug 20 11:08 crsctl_4805.trc
-rw-rw---- 1 root   oinstall      864 Aug 20 11:09 acfsutil_5655.trm
-rw-rw---- 1 root   oinstall      365 Aug 20 11:09 acfsutil_5655.trc
-rw-rw---- 1 root   oinstall      863 Aug 20 11:09 acfsutil_5741.trm
-rw-rw---- 1 root   oinstall      365 Aug 20 11:09 acfsutil_5741.trc
-rw-rw---- 1 root   oinstall      905 Aug 20 11:09 crsctl_5913.trm
-rw-rw---- 1 root   oinstall     2400 Aug 20 11:09 crsctl_5913.trc
-rw-rw---- 1 root   oinstall      905 Aug 20 11:09 crsctl_5924.trm

复制

清理数据库实例 trace日志

#使用root或者oracle 用户
cd $ORACLE_BASE/diag/rdbms/{dbname}/{ORACLE_SID}/trace
ls -lrt|head -10
find . -mtime +3 -type f -name "*.trm" |xargs rm -rf
find . -mtime +3 -type f -name "*.trc" |xargs rm -rf
ls |wc -l

复制

示例：

[oracle@ora19crac2 ~]$  cd $ORACLE_BASE/diag/rdbms/orcl/orcl2/trace
[oracle@ora19crac2 trace]$ ls -lrt|head -10
total 22400
-rw-r----- 1 oracle asmadmin     878 Aug 20 11:14 orcl2_vktm_16958.trm
-rw-r----- 1 oracle asmadmin    1131 Aug 20 11:14 orcl2_vktm_16958.trc
-rw-r----- 1 oracle asmadmin     868 Aug 20 11:14 orcl2_ofsd_17018_17031.trm
-rw-r----- 1 oracle asmadmin     966 Aug 20 11:14 orcl2_ofsd_17018_17031.trc
-rw-r----- 1 oracle asmadmin     860 Aug 20 11:14 orcl2_vkrm_17041.trm
-rw-r----- 1 oracle asmadmin    1086 Aug 20 11:14 orcl2_vkrm_17041.trc
-rw-r----- 1 oracle asmadmin     875 Aug 20 11:14 orcl2_dia0_17074.trm
-rw-r----- 1 oracle asmadmin    1212 Aug 20 11:14 orcl2_dia0_17074.trc
-rw-r----- 1 oracle asmadmin     862 Aug 20 11:14 orcl2_gen0_16980.trm
[oracle@ora19crac2 trace]$ find . -mtime +3 -type f -name "*.trm" |xargs rm -rf
[oracle@ora19crac2 trace]$ find . -mtime +3 -type f -name "*.trc" |xargs rm -rf
[oracle@ora19crac2 trace]$ ls |wc -l
243

复制

3） 清理监听日志

检查监听数量
RAC的每个节点会有多个监听
监听配置路径：

su - grid
$ORACLE_BASE/diag/tnslsnr/$HOSTNAME/{监听名}

复制
[grid@12cdb01~]$ps -ef|grep lsnr|grep -v grep
grid      9722     1  0 Apr25 ?        00:10:48 /u01/app/12c/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid      9777     1  0 Apr25 ?        00:10:05 /u01/app/12c/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
[grid@12cdb01~]$lsnrctl status ASMNET1LSNR_ASM

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 24-MAY-2022 16:13:26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))
STATUS of the LISTENER
------------------------
Alias                     ASMNET1LSNR_ASM
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                25-APR-2022 16:36:11
Uptime                    28 days 23 hr. 37 min. 14 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12c/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ASMNET1LSNR_ASM)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.37.210)(PORT=1526)))
Services Summary...
Service "+ASM" has 2 instance(s).
  Instance "+ASM1", status READY, has 2 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_DATADG" has 2 instance(s).
  Instance "+ASM1", status READY, has 2 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_MGMTDG" has 2 instance(s).
  Instance "+ASM1", status READY, has 2 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_OCRDG" has 2 instance(s).
  Instance "+ASM1", status READY, has 2 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
The command completed successfully

复制

每个监听有两个监听日志文件
1）.xml文件在alert目录下，会自动归档的，清理时只需要直接删除老的文件即可
如下最早的监听日志还是2020年的，每天一个.xml文件

[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/alert]$ls -lrth|head -10
total 5.4G
-rw-r----- 1 grid oinstall  11M Nov 27  2020 log_1.xml
-rw-r----- 1 grid oinstall  11M Nov 28  2020 log_2.xml
-rw-r----- 1 grid oinstall  11M Nov 29  2020 log_3.xml
-rw-r----- 1 grid oinstall  11M Nov 30  2020 log_4.xml
-rw-r----- 1 grid oinstall  11M Dec  1  2020 log_5.xml
-rw-r----- 1 grid oinstall  11M Dec  2  2020 log_6.xml
-rw-r----- 1 grid oinstall  11M Dec  3  2020 log_7.xml
-rw-r----- 1 grid oinstall  11M Dec  4  2020 log_8.xml
-rw-r----- 1 grid oinstall  11M Dec  5  2020 log_9.xml
[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/alert]$ls -lrth|tail -10
-rw-r----- 1 grid oinstall  11M May 15 21:04 log_536.xml
-rw-r----- 1 grid oinstall  11M May 16 20:54 log_537.xml
-rw-r----- 1 grid oinstall  11M May 17 20:57 log_538.xml
-rw-r----- 1 grid oinstall  11M May 18 21:01 log_539.xml
-rw-r----- 1 grid oinstall  11M May 19 21:06 log_540.xml
-rw-r----- 1 grid oinstall  11M May 20 21:11 log_541.xml
-rw-r----- 1 grid oinstall  11M May 21 21:16 log_542.xml
-rw-r----- 1 grid oinstall  11M May 22 21:24 log_543.xml
-rw-r----- 1 grid oinstall  11M May 23 21:30 log_544.xml
-rw-r----- 1 grid oinstall 7.8M May 24 16:17 log.xml
进行清理：
清理一周前的.xml文件）
检查监听
[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01]$ll
total 0
drwxr-xr-x 14 grid oinstall 179 Nov 26  2020 asmnet1lsnr_asm
drwxr-xr-x 14 grid oinstall 179 Nov 26  2020 listener
drwxr-xr-x 14 grid oinstall 179 Nov 26  2020 listener_scan1
drwxr-xr-x 14 grid oinstall 179 Jan 18  2021 lsnr1523
drwxr-xr-x 14 grid oinstall 179 Apr 11 19:05 mgmtlistener
drwxr-xr-x 14 grid oinstall 179 Nov 26  2020 mgmtlsnr

清理asmnet1lsnr_asm
find /u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/alert -mtime +7 -type f -name "*.xml" |xargs rm -rf
[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/alert]$find /u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/alert -mtime +7 -type f -name "*.xml" |xargs rm -rf
[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/alert]$ls -lrth|head -10
total 89M
-rw-r----- 1 grid oinstall  11M May 16 20:54 log_537.xml
-rw-r----- 1 grid oinstall  11M May 17 20:57 log_538.xml
-rw-r----- 1 grid oinstall  11M May 18 21:01 log_539.xml
-rw-r----- 1 grid oinstall  11M May 19 21:06 log_540.xml
-rw-r----- 1 grid oinstall  11M May 20 21:11 log_541.xml
-rw-r----- 1 grid oinstall  11M May 21 21:16 log_542.xml
-rw-r----- 1 grid oinstall  11M May 22 21:24 log_543.xml
-rw-r----- 1 grid oinstall  11M May 23 21:30 log_544.xml
-rw-r----- 1 grid oinstall 8.0M May 24 16:38 log.xml

复制

清理listener\listener_scan1\lsnr1523。。。 监听.xml文件同上一样。

2）.log文件在trace目录下，这个不会自动归档，清理时不能直接删除原文件，如需mv原文件需要关闭监听日志输出
清理.log文件
1）清理ASMNET1LSNR_ASM 监听.log文件

[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/trace]$lsnrctl

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 24-MAY-2022 17:09:42

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

Welcome to LSNRCTL, type "help" for information.
LSNRCTL> set current_listener asmnet1lsnr_asm
Current Listener is asmnet1lsnr_asm
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))
STATUS of the LISTENER
------------------------
Alias                     ASMNET1LSNR_ASM
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                25-APR-2022 16:36:11
Uptime                    29 days 0 hr. 34 min. 25 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12c/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ASMNET1LSNR_ASM)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.37.210)(PORT=1526)))
Services Summary...
Service "+ASM" has 2 instance(s).
  Instance "+ASM1", status READY, has 2 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_DATADG" has 2 instance(s).
  Instance "+ASM1", status READY, has 2 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_MGMTDG" has 2 instance(s).
  Instance "+ASM1", status READY, has 2 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_OCRDG" has 2 instance(s).
  Instance "+ASM1", status READY, has 2 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> show log_status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))
asmnet1lsnr_asm parameter "log_status" set to ON
The command completed successfully
LSNRCTL> set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))
asmnet1lsnr_asm parameter "log_status" set to OFF
The command completed successfully
LSNRCTL> show log_status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))
asmnet1lsnr_asm parameter "log_status" set to OFF
The command completed successfully

关闭日志输出后，在另一个会话将asmnet1lsnr_asm.log 进行mv操作或者rm操作
[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/trace]$mv asmnet1lsnr_asm.log asmnet1lsnr_asm.log.bak
[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/trace]$ll
total 3108300
-rw-r----- 1 grid oinstall 3178705934 May 24 17:17 asmnet1lsnr_asm.log.bak


开启日志输出
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))
asmnet1lsnr_asm parameter "log_status" set to ON
The command completed successfully
LSNRCTL> show log_status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))
asmnet1lsnr_asm parameter "log_status" set to ON
The command completed successfully
LSNRCTL>

可以看到新的log文件已经生成，并且监听日志已经写到新的文件里了，asmnet1lsnr_asm.log.bak可以移走或者删除了
[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/trace]$ll
total 3108304
-rw-r----- 1 grid oinstall        709 May 24 17:18 asmnet1lsnr_asm.log
-rw-r----- 1 grid oinstall 3178705934 May 24 17:17 asmnet1lsnr_asm.log.bak
[grid@12cdb01/u01/app/grid/diag/tnslsnr/12cdb01/asmnet1lsnr_asm/trace]$tail -f asmnet1lsnr_asm.log
24-MAY-2022 17:18:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=12cdb01)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=ASMNET1LSNR_ASM)(VERSION=203424000)) * status * 0
24-MAY-2022 17:18:10 * log_status * 0
2022-05-24T17:18:12.607752+08:00
24-MAY-2022 17:18:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=12cdb01)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=ASMNET1LSNR_ASM)(VERSION=203424000)) * status * 0
2022-05-24T17:18:15.610104+08:00
24-MAY-2022 17:18:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=12cdb01)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=ASMNET1LSNR_ASM)(VERSION=203424000)) * status * 0
2022-05-24T17:18:18.605210+08:00
24-MAY-2022 17:18:18 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=12cdb01)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=ASMNET1LSNR_ASM)(VERSION=203424000)) * status * 0
2022-05-24T17:18:21.602345+08:00
24-MAY-2022 17:18:21 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=12cdb01)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=ASMNET1LSNR_ASM)(VERSION=203424000)) * status * 0

复制

清理listener\listener_scan1\lsnr1523。。。 监听.log文件同上一样。

墨力计划oracle
最后修改时间：2022-08-25 15:03:29
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论

NorId
暂无图片
1年前
评论
暂无图片 0
直接妊操作系统命令总是在危险的，有其它好的方法吗
1年前
暂无图片 点赞
评论

相关阅读

Oracle DataGuard高可用性解决方案详解
孙莹
563次阅读
2025-03-26 23:27:33
Oracle RAC 一键安装翻车？手把手教你如何排错！
Lucifer三思而后行
522次阅读
2025-04-15 17:24:06
【纯干货】Oracle 19C RU 19.27 发布，如何快速升级和安装？
Lucifer三思而后行
424次阅读
2025-04-18 14:18:38
墨天轮个人数说知识点合集
JiekeXu
424次阅读
2025-04-01 15:56:03
XTTS跨版本迁移升级方案（11g to 19c RAC for Linux）
zwtian
423次阅读
2025-04-08 09:12:48
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
418次阅读
2025-04-22 00:20:37
Oracle SQL 执行计划分析与优化指南
Digital Observer
418次阅读
2025-04-01 11:08:44
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
400次阅读
2025-04-22 00:13:51
Oracle数据库一键巡检并生成HTML结果，免费脚本速来下载!
陈举超
383次阅读
2025-04-20 10:07:02
Oracle 19c RAC更换IP实战，运维必看！
szrsu
361次阅读
2025-04-08 23:57:08