找日志路径:/u01/app/oracle/diag/rdbms/itgs/itgs1/trace/itgs1_ora_15432.trc
查询oarcle的日志文件路径sql:
SQL> show parameter dump;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /u01/app/oracle/diag/rdbms/itgs/itgs1/trace
core_dump_dest string /u01/app/oracle/diag/rdbms/itgs/itgs1/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /u01/app/oracle/diag/rdbms/itgs/itgs1/trace
先查询lalert文件夹下的og文件;
/u01/app/oracle/diag/rdbms/itgs/itgs1/alert路径下的文件:
再根据log下的trace路径,找到log路径
打开文件查看输出详情:
/u01/app/oracle/diag/rdbms/itgs/itgs1/trace/itgs1_ora_15432.trc路径
再根据log下的trace路径,找到log路径
打开文件查看输出详情: