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' 없어도 되죠?
