TIP :-How to know who and when someone connected to oracle through internal ?
In Unix
Oracle create a ora_<PID>.aud file whenever you connect to oracle
thorough internal. By default
this file is created in $ORACLE_HOME/rdbms/audit directory. There is no need to turn audit on.
In the
following example i connected to hpux
through my client. The ora_2147.aud file
is created
in my $ORACLE_HOME/rdbms/audit directory.
STEP 1: Execute following from client machine
SamSQL :> connect
internal/oracle@nghpuxl1k
Connected.
STEP 2: Looking for
file on the server at $ORACLE_HOME/rdbms/audit dir. check for latest
ora_<PID>.aud
file.
$ cat ora_2147.aud
Audit file
/app/oracle/product/8.1.6/rdbms/audit/ora_2147.aud
Oracle8i Enterprise
Edition Release 8.1.6.0.0, 64 bit - Production
With the
Partitioning option
JServer Release
8.1.6.0.0 - Production
ORACLE_HOME =
/app/oracle/product/8.1.6
System name: HP-UX
Node name: nghpux01
Release: B.11.00
Version: A
Machine: 9000/785
Instance name:
nguv5
Redo thread
mounted by this instance: 1
Oracle process
number: 8
Unix process pid:
2147, image: oracle@nghpux01 (TNS V1-V3)
Tue Jun 19
11:54:21 2001
ACTION : 'connect
internal' OSPRIV : DBA
CLIENT USER:
wadhwas
CLIENT TERMINAL:
MS032000D0009
The following file
generated when you connected to internal from the server.
$ cat ora_2107.aud
Audit file
/app/oracle/product/8.1.6/rdbms/audit/ora_2107.aud
Oracle8i
Enterprise Edition Release 8.1.6.0.0, 64 bit - Production
With the
Partitioning option
JServer Release
8.1.6.0.0 - Production
ORACLE_HOME =
/app/oracle/product/8.1.6
System name: HP-UX
Node name: nghpux01
Release: B.11.00
Version: A
Machine: 9000/785
Instance name:
nguv5
Redo thread
mounted by this instance: 1
Oracle process
number: 0
2107
Tue Jun 19
11:48:07 2001
ACTION : 'connect
INTERNAL' OSPRIV : OPER
CLIENT USER:
oracle
CLIENT TERMINAL:
pts/ta
Tue Jun 19
11:48:07 2001
ACTION : 'connect
internal' OSPRIV : DBA
CLIENT USER:
oracle
CLIENT TERMINAL:
pts/ta
Tue Jun 19
11:48:17 2001
ACTION : 'connect
internal' OSPRIV : DBA
CLIENT USER:
oracle
CLIENT TERMINAL:
pts/ta
End of Tip
|
Welcome
to send comments or feedback at Wadhwa_s@Hotmail.com |
|
|
Copyright © Oracle Techniques All Rights Reserved
|