problem audit in oracle9i [message #406037] |
Mon, 01 June 2009 20:36 |
aiznu
Messages: 24 Registered: May 2009
|
Junior Member |
|
|
hi
i have a problem. why when i query select * from dba_audit_session; i get no rows selected? it is my step is wrong.
my step is i conn /as sysdba
audit session;
conn user1/user1@bso;
conn user2/user2@bso;
conn /as sysdba;
and run this statement @D:\Book\audit01.sql;
in audit01.sql
COLUMN os_username FORMAT a15
COLUMN username FORMAT a15
COLUMN terminal FORMAT a15
COLUMN LOGON_TIME FORMAT a22
COLUMN LOGOFF_TIME FORMAT a22
SELECT os_username, username, terminal, returncode,
TO_CHAR(timestamp, 'DD-MON-YYYY HH24:MI:SS')
LOGON_TIME,
TO_CHAR(logoff_time, 'DD-MON-YYYY HH24:MI:SS')
LOGOFF_TIME
FROM dba_audit_session;
n i got no rows selected.
please help me..
|
|
|
|
|
|
Re: problem audit in oracle9i [message #406087 is a reply to message #406068] |
Tue, 02 June 2009 03:07 |
aiznu
Messages: 24 Registered: May 2009
|
Junior Member |
|
|
do you mean this?
DESC dba_audit_session;
Name Null? Type
OS_USERNAME VARCHAR2(255)
USERNAME VARCHAR2(30)
USERHOST VARCHAR2(128)
TERMINAL VARCHAR2(255)
TIMESTAMP NOT NULL DATE
ACTION_NAME VARCHAR2(27)
LOGOFF_TIME DATE
LOGOFF_LREAD NUMBER
LOGOFF_PREAD NUMBER
LOGOFF_LWRITE NUMBER
LOGOFF_DLOCK VARCHAR2(40)
SESSIONID NOT NULL NUMBER
RETURNCODE NOT NULL NUMBER
CLIENT_ID VARCHAR2(64)
SESSION_CPU NUMBER
|
|
|
|
Re: problem audit in oracle9i [message #406105 is a reply to message #406096] |
Tue, 02 June 2009 04:43 |
aiznu
Messages: 24 Registered: May 2009
|
Junior Member |
|
|
do u mean this? at D:\oracle\admin\dba\pfile\init.ora
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_count=16
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Database Identification
###########################################
db_domain=""
db_name=dba
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=D:\oracle\admin\dba\bdump
core_dump_dest=D:\oracle\admin\dba\cdump
timed_statistics=TRUE
user_dump_dest=D:\oracle\admin\dba\udump
###########################################
# File Configuration
###########################################
control_files=("D:\oracle\oradata\dba\CONTROL01.CTL", "D:\oracle\oradata\dba\CONTROL02.CTL", "D:\oracle\oradata\dba\CONTROL03.CTL")
###########################################
# Instance Identification
###########################################
instance_name=dba
###########################################
# Job Queues
###########################################
job_queue_processes=10
###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=dbaXDB)"
###########################################
# Miscellaneous
###########################################
aq_tm_processes=1
compatible=9.2.0.0.0
###########################################
# Optimizer
###########################################
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE
###########################################
# Pools
###########################################
java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=50331648
###########################################
# Processes and Sessions
###########################################
processes=150
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=EXCLUSIVE
audit_trail = true
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=25165824
sort_area_size=524288
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
i already add audit_trail=true or do you mean this:
show parameter audit_trail;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string NONE
[Updated on: Tue, 02 June 2009 04:47] Report message to a moderator
|
|
|
|
|
|
|
Re: problem audit in oracle9i [message #406155 is a reply to message #406126] |
Tue, 02 June 2009 10:24 |
aiznu
Messages: 24 Registered: May 2009
|
Junior Member |
|
|
i got the same result.i don't understand how to startup the pfile.because when i startup, i got this result
startup pfile='D:\oracle\ora92\database\initDBA.ora';
ORA-01081: cannot start already-running ORACLE - shut it down first
i don't know what step to do because i tried many step but the result is same.please help me to explain step by step.thanks
|
|
|
|
|
|