Skip to Main Content
  • Questions
  • catalog database gets shutdown frequently

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, sanjiv.

Asked: September 07, 2017 - 6:49 am UTC

Last updated: September 07, 2017 - 11:43 am UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Greetings,
A catalog database is present. It gets automatically shutdown freqently and we need to start it up manually. How should i know the
reason behind the shutdown. Are there any logfiles or trace files i should refer to?
Your's Sincerely,
Sanjiv Ranjit

and Connor said...

Check the alert.log

It will be in the location as per below

SQL> select  value from V$DIAG_INFO where name = 'Diag Trace';

VALUE
--------------------------------------------------------------------
C:\ORACLE\diag\rdbms\db122\db122\trace




Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database