展开
查看ASM日志
[root@cn-db-01 ~]# su - grid
[grid@cn-db-01 ~]$ sqlplus / as sysasm
SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 8 17:12:31 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show parameter dump
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
background_core_dump string
partial
background_dump_dest string
/u01/app/12.2.0/grid/rdbms/log
core_dump_dest string
/u01/app/grid/diag/asm/+asm/+A
SM1/cdump
max_dump_file_size string
unlimited
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
shadow_core_dump string
partial
user_dump_dest string
/u01/app/12.2.0/grid/rdbms/log
SQL> select * from v$diag_info;
INST_ID NAME VALUE
---------- ---------------------------------------------------------------- ---------------------------------------------------------