ADRCI in 11g.

While i was trying to check the alert log in 11g. I knew that the .log was replaced by xml files. I tried to open the xml file in xml editor and notepad i recieved the error

=====================================
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
Only one top level element is allowed in an XML document. Error processing resource 'file:///C:/tmp/log.xml'. Line 8, Posi...

=======================================

on investigation i found that adcri is the tool which should be used to view logs in 11g..

"C:\Users\Sandeep>adrci"
ADRCI: Release 11.1.0.7.0 - Production on Sun Feb 21 10:48:29 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "d:\11gsoftware"
adrci>
adrci> show alert
Choose the alert log from the following homes to view:
1: diag\clients\user_system\host_3693351798_11
2: diag\rdbms\sandeep\sandeep
3: diag\tnslsnr\sandeep-pc\listener
Q: to quit

Please select option: 2 (For alert log)
Output the results to file: c:\users\sandeep\appdata\local\temp\alert_1364_7796_sandeep_1.ado


Related metalink notes: metalink notes 453125.1.,454927.1 and 422893.1

For more examples and to know more about this...
http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/adrci.htm

No comments:

Post a Comment