whither user trace file?

From: EdStevens <quetico_man_at_yahoo.com>
Date: 3 Aug 2005 07:50:02 -0700
Message-ID: <1123080602.757796.117300@g44g2000cwa.googlegroups.com>

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

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> Received on Wed Aug 03 2005 - 09:50:02 CDT