Friday, July 27, 2007

How to check alert.log in Oracle 11g

Virag Sharma virag123@gmail.com

Oracle 11g introduce new tool/utility called ADRCI known as ADR command line tool.
This tool allow user to interact with ADR ,check alert log, check health monitor(HM) status ,

Package incident and problem information into a zip file for send to Oracle Support. Etc.

No username/password need to log in to ADRCI, ADRCI interact with file system and ADR data is secured only by operating system permissions on the ADR directories.

$adrci
adrci> set editor vi
adrci> show alert ( it will open alert in vi editor )
adrci> show alert -tail ( Similar to Unix tail command )
adrci> show alert -tail 200 ( Similar to Unix Command tail -200 )
adrci> show alert -tail -f ( Similar to Unix command tail -f )

adrci> show alert -tail 100 -f ( Similar to tail -100f )


Too list all the "ORA-" error run following command

$adrci
adrci>
show alert -P "MESSAGE_TEXT LIKE '%ORA-%'"

>


In 11g alert file is saved in 2 location, one is in alert directory ( in XML format log.xml ) and
old style alert file in trace directory. Both these directory reside inside ADR HOME. ADR (
Automatic Diagnostic Repository ) is a file system based directory structure outside of the database, So you can have access of diagnostic data even database is down.

New initialization parameter
DIAGNOSTIC_DEST decide where to store ADR data ( i.e diagnostic data). In oracle 11g parameter background_dump_dest, core_dump_dest, user_dump_dest is replaced by DIAGNOSTIC_DEST. Even you set background_dump_dest, core_dump_dest, user_dump_dest it not going to used i.e. 11g ignore these parameters.

SQL> show parameter diagnostic_dest

NAME TYPE VALUE
--------------- --------------------------- -------------------------

diagnostic_dest string /u01/app/oracle



More Oracle Database 11g New Features

  1. Oracle SQL REPLAY

  2. IPS ( Incident Packaging Service)
  3. Automatic Diagnostic Repository (ADR)

  4. Database Replay [Click for Detail]

TAG = > Oracle 11g New Features , Oracle 11g tips and tricks , Oracle Database 11g New Features for DBA , Oracle Database 11g New Features

6 comments:

  1. Where will be the trace of control file saved in this case?

    ReplyDelete
  2. How can we diffrentiate that which one is the trace file and which is error alert?

    ReplyDelete
  3. can u explain me difference between trace file and alert log file and location of both files....

    ReplyDelete
  4. The most up to date propensities show that advanced software development clients are slowly moving from the building of their own in-house development teams to the administrations of an offshore development center. Indeed, it is another sort of far off work, which somewhat contrasts from the standard outsourcing. This technique assists with saving expenses while keeping own distant group. The conspicuous distinction between these two models is the area of the colleagues: in the primary case, they are not sitting in your office. Be that as it may, there are other little peculiarities, which make participation fundamentally contrast. What's more, in the event that you disregard these peculiarities, you may confront more troubles during the work. The contrasts between these two models of work may appear to be exceptional yet when you start work, you will see – software development outsourcing is straightforward as a piece of cake. The thing is to find an expert and solid specialist co-op. It is difficult to tell the number of ODCs we have on the planet or even in one nation, cause IT organizations to open and close each day. However, the industry of offshore development develops and turns out to be more famous. Numerous organizations are looking for an ODC group to enlist. Such development occurs because of the propensities in business: each organization needs a website for association with the clients. A significant number of them need to have portable applications to arrive at the intended interest group and quest for an ODC organization to employ. As a response to the growing interest, the inventory likewise raises. It is hard to tell, what amount does the ODC cost: the pricing relies upon the experts you need, their capability, and number. To get a picture of the costs, settle on which experts do you need and the number of them you are prepared to employ. Offshore development center expenses additionally include the costs for the workplace maintenance – add them to the rundown.

    ReplyDelete
  5. Supplier plays an important role in business functioning. When goods are delivered at time with no delay, there is no comnplies from customers. By the way, on-demand app development can help business to manage its warehouse and improve the products availability control.

    ReplyDelete
  6. With automated workflows and lead scoring, businesses can streamline their sales and marketing efforts, saving time and resources. To achieve this, you should think about dynamics crm implementation. This process is quite complicated, but in the future it will bring many advantages, so at least it is worth getting to get acquainted with this.

    ReplyDelete

Google