Re: whither user trace file?

EdStevens schrieb:
> Platform: Oracle 9.2 on Solaris
>
> Playing around with Tom Kyte's techniques for setting traceing on
> sessions. Everything went as advertised except that I can't find the
> trace file. Yes, I know it should be in the udump directory. In
> digging around for an answer, I found a comment in a msg in the ng
> archives that if connection is by shared server (which it is in this
> case) the trace will go to bdump destination. But my trace is not
> there either. Here is a session log:
>
> <begin log>
> oracle_at_ncens181: echo $ORACLE_SID
> VITXD01
> oracle_at_ncens181: sqlplus system
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 3 08:41:42 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter password:
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
>
> SQL> create or replace trigger logon_trigger
> 2 after logon on database
> 3 begin
> 4 if (user = 'orcluser' ) then
> 5 execute immediate
> 6 'ALTER SESSION SET TRACEFILE_IDENTIFIER=''ORCLUSER''';
> 7 execute immediate
> 8 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER,
> LEVEL 12''';
> 9 end if;
> 10 end;
> 11 /
>
> Trigger created.
>
> SQL> show parameter user_dump
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> user_dump_dest string
> /u01/app/oracle/admin/VITXD01/
> udump
> SQL> connect orcluser
> Enter password:
> Connected.
> SQL> select count(*) from all_tables;
>
> COUNT(*)
> ----------
> 1090
>
> SQL> select to_char(sysdate,'dd-mon-yyyy hh24:mi:ss') from dual;
>
> TO_CHAR(SYSDATE,'DD-
> --------------------
> 03-aug-2005 08:44:45
>
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit
> Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
>
> oracle_at_ncens181: pwd
> /u01/app/oracle/admin/VITXD01
>
> oracle_at_ncens181: ls -l
> total 76
> drwxr-x--- 2 oracle dba 2560 Aug 2 14:59 bdump
> drwxr-x--- 3 oracle dba 512 May 3 22:28 cdump
> drwxr-x--- 2 oracle dba 512 Dec 28 2004 create
> drwxr-x--- 2 oracle dba 11264 Aug 2 21:50 logs
> drwxr-x--- 2 oracle dba 512 May 13 15:51 pfile
> drwxr-x--- 2 oracle dba 512 Jan 7 2005 scripts
> drwxr-x--- 2 oracle dba 512 Nov 6 2004 trace
> drwxr-x--- 2 oracle dba 18944 Aug 3 07:09 udump
>
> oracle_at_ncens181: ls -l bdump
> total 2254
> -rw-r----- 1 oracle dba 69829 Aug 2 23:03 alert_VITXD01.log
> -r--r----- 1 oracle dba 62917 Jul 21 03:42
> alert_VITXD01.log.1
> -r--r----- 1 oracle dba 119289 Jul 7 00:11
> alert_VITXD01.log.2
> -r--r----- 1 oracle dba 83447 Jun 20 23:02
> alert_VITXD01.log.3
> -r--r----- 1 oracle dba 157802 Jun 6 23:03
> alert_VITXD01.log.4
> -r--r----- 1 oracle dba 103040 May 20 23:02
> alert_VITXD01.log.5
> -r--r----- 1 oracle dba 87441 May 6 23:03
> alert_VITXD01.log.6
> -r--r----- 1 oracle dba 98308 Apr 21 02:36
> alert_VITXD01.log.7
> -r--r----- 1 oracle dba 205076 Apr 6 23:03
> alert_VITXD01.log.8
> -r--r----- 1 oracle dba 58058 Mar 20 23:02
> alert_VITXD01.log.9
> -rw-r----- 1 oracle dba 746 Aug 2 21:30
> vitxd01_arc0_1101.trc
> -rw-r----- 1 oracle dba 680 Jul 27 15:16
> vitxd01_arc1_1103.trc
> -rw-r----- 1 oracle dba 7993 Jul 26 15:56
> vitxd01_s000_16118.trc
> -rw-r----- 1 oracle dba 22641 Aug 3 07:06
> vitxd01_s000_29793.trc
> -rw-r----- 1 oracle dba 1511 Jul 27 09:40
> vitxd01_s001_2841.trc
>
> oracle_at_ncens181: ls -l cdump
> total 2
> drwxr-x--- 2 oracle dba 512 May 3 22:28 core_26269
>
> oracle_at_ncens181: ls -l udump
> total 0
>
> <end log>
>

I suppose , your trigger doesn't fire, try to change your code from

   4 if (user = 'orcluser' ) then
to

   4 if (user='ORCLUSER') then

Best regards

Maxim Received on Wed Aug 03 2005 - 09:56:15 CDT