Re: ACLS oracle 11 UTL_MAIL.

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 28 Feb 2013 14:19:45 -0600
Message-ID: <CAJvnOJYzqTBRoNU_6AaP-o1h+-3NRSMZPJGFD4kTLU9MenaGHQ_at_mail.gmail.com>

I was going to say its no big deal to drop and re-create xdb, but I see someone has already noted that it can be done. Just be sure to follow the notes exactly. By the way, on my blog I have a little database trigger I wrote a couple of years ago for creating or adding to the network acl when you grant execute on utl mail. Your pardon if my blog comments are a little snarky on this, its not my favorite feature of 11gR2. http://dbakerber.wordpress.com/2011/06/29/11gr2-network-acl-what-a-nice-feature/

On Thu, Feb 28, 2013 at 2:12 PM, Jorgensen, Finn < Finn.Jorgensen_at_constellation.com> wrote:

> Whenever I have this problem I drop XDB and recreate it but you will need
> to bounce the database between those 2 actions. There's a MOS note about
> the scripts to run to properly drop and recreate XDB.
>
> Thanks,
> Finn
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Howard Latham
> Sent: Thursday, February 28, 2013 2:59 PM
> To: ORACLE-L
> Subject: ACLS oracle 11 UTL_MAIL.
>
> 11.2 Redhat LInux.
> I've migrated to 11g . I use email. So I need to set up acls but the
> XDB portion of the database is invalid and was when it was a 10 db.
>
> What would you do? Can XDB be dropped and recreated?
>
> I will set up a SR but just wonderd if anyone had this problem and a quick
> way of sorting it.
>
> --
> Howard A. Latham
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> This e-mail and any attachments are confidential, may contain legal,
> professional or other privileged information, and are intended solely for
> the
> addressee. If you are not the intended recipient, do not use the
> information
> in this e-mail in any way, delete this e-mail and notify the sender. -EXCIP
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 28 2013 - 21:19:45 CET