This was solved offline by examining the setup at one of my customers' site which has the same configuration of VMS, Oracle and Perl as Barb listed.
Barb changed the setting of user_dump_dest to point to the actual directory that was defined in the hotsos.auth file. For some reason the logical was not resolved correctly. I am not proficient enough in VMS to explain that behaviour further. To save any future users of Sparky and VMS a few minutes of frustration I'd like to point out that you must remember to quit your session before Sparky can pull the trace file over to your PC. VMS does not release the file lock on the trace file even if you stop tracing. Gudmundur > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Barbara Baker > Sent: 11. j�l� 2003 23:35 > To: Multiple recipients of list ORACLE-L > Subject: Sparky auth file > > > Ok, this is a REAL reach. > But does anyone out there know how to specify the dump > directory in the auth file for sparky > ... wait > ... I'm not there yet > on an OpenVMS system? > > OpenVMS 7.2-1 > Oracle 8.1.7.4 > Perl 5.6.1 > > The background dump desitnation from v$parameter is > ORA_DUMP. The system logical ORA_DUMP equates to > disk$dbtest11:[db_amdev.trace]. Sparky wants to append the > trace name file to the end of this. I've tried both > ORA_DUMP: and disk$dbtest11:[db_amdev.trace] in the aut file. > They don't work. > > if I use diskname: > > Authorized directory 'disk$dbtest11:[DB_AMDEV.TRACE]': > 16 of 16 '*.trc' files are readable > Fri Jul 11 16:20:48 2003 REQ 10.39.8.253 > version > Fri Jul 11 16:20:48 2003 ACK 10.39.8.253 > 0 3.04 > Fri Jul 11 16:21:30 2003 REQ 10.39.8.253 > trcname 'ORA_DUMP', '20c02d0a', 'AMDEV', '16' > Fri Jul 11 16:21:30 2003 ACK 10.39.8.253 > 1 not authorized to > read 'ORA_DUMP' (trcfiled.pl v3.04 line 536) > > if I use ORA_DUMP > > Fri Jul 11 16:18:34 2003 INFO > spid('[.ORA_DUMP]drax11_amdev_fg_oracle_016.trc')='-1' > Fri Jul 11 16:18:34 2003 WSVR > can't read '[.ORA_DUMP]drax11_amdev_fg_oracle_017.trc' > (no such file or directory) > > I get the error message "trace file server daemon has > denied your request. Check the trcfiled logfile on > 'DRAX11' (ip) at port 2297 for details. > > I'd be most grateful for any ideas. > > Thanks!! > Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
