Oracle-L: RE: Sparky auth file

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Fri, 11 Jul 2003 19:54:24 -0800
Message-ID: <F001.005C46AB.20030711195424@fatcity.com>

Barb,

Hi, I wrote Sparky, but it's been so long that it's going to take me a little time to catch up with my own code. We have some users running fine on OpenVMS, so there's certainly hope :).

Would you mind privately sending me your whole trcfiled.log file? We can take it offline from here until we figure out the answer, and then one of us can post the list.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- Hotsos Clinic 101 in Washington, Denver, Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...

-----Original Message-----
Barbara Baker
Sent: Friday, July 11, 2003 6:35 PM
To: Multiple recipients of list ORACLE-L

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

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Barbara Baker
INET: barbarabbaker_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Cary Millsap
INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------