Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where to find alert log path in 12c

Beauty_and_dBestJun 16 2017 — edited Jun 16 2017

Hi ALL,

In 11g, I just run show parameter dump, and it will show the path where alert log is located.

But now in 12c

[oratest1@a6dd6a ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jun 16 02:57:25 2017

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show parameter dump

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

background_core_dump                 string      partial

background_dump_dest                 string      /u03/oratest1/TEST1/12.1.0/rdbms/log

core_dump_dest                             string      /u03/oratest1/TEST1/12.1.0/adm in/TEST1_a6dd6a/diag/rdbms/test1/TEST1/cdump

max_dump_file_size                       string      20480

shadow_core_dump                       string      partial

user_dump_dest                             string      /u03/oratest1/TEST1/12.1.0/rdbms/log

SQL>

Can you show which folder is it under now?

Kind regards,

jc

This post has been answered by SUPRIYO DEY on Jun 16 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2017
Added on Jun 16 2017
3 comments
13,027 views