Oralce 11g 로그 보기

오라클 11g 부터 log를 하나의 툴에서 관리합니다.

adrci 에서 관리하는거죠

로그위치는 대략 아래의 결로에 있습니다.

  디렉터리: C:\Users\Administrator\Oracle\oradiag_사용자계정\diag\clients\user_사용자계정

#################################################################################

C:\Users\Administrator> adrci

ADRCI: Release 11.2.0.1.0 - Production on 月 3月 9 15:13:32 2015

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

ADR base = "d:\oracle"

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

Choose the alert log from the following homes to view:

1: diag\clients\user_system\host_2609190404_76

2: diag\rdbms\ora11\ora11

3: diag\tnslsnr\ywtc-db\listener

Q: to quit