Database Administration (MOSC)

MOSC Banner

ADRCI "SHOW ALERT" does not work with ORACLE RDBMS 12.2

edited Oct 23, 2019 3:29AM in Database Administration (MOSC) 6 commentsAnswered ✓

Since the Upgrade to Oracle Release 12.2 the adrci command "show alert" won't show the alert.log.

"alert -tail" still works.

Tested on SLES and CentOS.

oracle@test11l:test01 ~> adrci

ADRCI: Release 12.2.0.1.0 - Production on Di Nov 13 10:21:52 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/db/oracle"

adrci> show home

ADR Homes:

diag/rdbms/test/test01

diag/clients/user_oracle/host_823146770_107

adrci> set home diag/rdbms/test/test01

adrci> show alert

ADR Home = /db/oracle/diag/rdbms/test/test01:

*************************************************************************

Output the results to file: /tmp/alert_14854_1399_test01_1.ado

adrci>

Has anyone had the same problem?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center