in 11g there is no alert.log instead there is alert.xml and view the contents of this file Oracle provides a utility called ADRI see below on how to use this utility:
HOST: /rman01/u0001/oracle/diag/rdbms/adm1p/ADM1P/alert
>adrci
ADRCI: Release 11.2.0.1.0 - Production on Fri Oct 22 09:35:01 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/rman01/u0001/oracle"
adrci>
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
adrci> show alert
ADR Home = /rman01/u0001/oracle/diag/rdbms/adm1p/ADM1P:
*************************************************************************
Output the results to file: /tmp/alert_7353_1_ADM1P_1.ado
"/tmp/alert_7353_1_ADM1P_1.ado" 2102 lines, 108992 characters
2010-08-25 16:59:50.107000 -04:00
Adjusting the default value of parameter parallel_max_servers
Experience: is what you get soon after you need it.
****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************
Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2020
**********************************************************************************
My Cloud Certifications:
AWS Certified Solutions Architect Associate
Azure Certified Architect
Azure Certified Administrator
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.

No comments:
Post a Comment