RE: Sparky auth file

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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] 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.
Received on Tue Jul 15 2003 - 04:35:36 CDT