ORA-3113 원인 진단법 관련 문의

1.서버/클라이언트 로그기록

2.테스트 프로그램 로그기록(truss)

3.DB login/logout 로그기록(audit)

-client 요청에 의한 logout 인지 pmon에 의한 logout 인지 확인가능

4.event trace

 

1.trace 및 로그기록

 

Client | sqlnet.ora
----------------------------------

TRACE_LEVEL_CLIENT=ADMIN
TRACE_FILE_CLIENT=client.trc
TRACE_DIRECTORY_CLIENT=/user1/ora9i/dbConn
TRACE_UNIQUE_CLIENT=on

 

Server | sqlnet.ora
----------------------------------

TRACE_LEVEL_SERVER=ADMIN
TRACE_FILE_SERVER=server.trc
TRACE_DIRECTORY_SERVER =/data1/oracle/app/oracle/product/817/network/log/200710
LOG_FILE_SERVER=server.log
LOG_DIRECTORY_SERVER = /data1/oracle/app/oracle/product/817/network/log 

 

# listener.ora
----------------------------------

TRACE_LEVEL_mercury=support
TRACE_DIRECTORY_mercury=/data1/oracle/app/oracle/product/817/network/log/200710
TRACE_FILE_mercury=dbSrv
TRACE_TIMESTAMP_mercury=ON
TRACE_FILENO_mercury=3
TRACE_FILELEN_mercury=1024768

 

2.Client

$>truss -aeof <output> <execute>

 

3.audit

sql>audit create session username by access;

 

4.event trace(서버 alert.log에는 아무것도 안남습니다만 혹시나해서~)
alter system set event="3113 trace name errorstack level 3"
alter system set max_dump_file_size=unlimited;
alter system set events '3113 trace name errorstack level 3';

->'3113 trace name errorstack level 3'; => '03113 trace name ...  이렇게 해야되는가요? '0' 없어도 되죠?