Oracle 12c RAC查看ASM日志、grid日志和DB日志

展开

查看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
------------------------------------ -------------------