Re: ACLS oracle 11 UTL_MAIL.

From: De DBA <dedba_at_tpg.com.au>
Date: Mon, 04 Mar 2013 11:18:27 +1000
Message-ID: <5133F663.9060207_at_tpg.com.au>

Must be an epidemic ;) I have a similar problem with using UTL_SMTP in XE. In my case the error I get when creating the ACLs says that the stylesheets have not been loaded correctly. The problem with XE is that no supporting files are included, so reloading the stylesheets is not possible.

I don't have an 11.2.0.2 database to get them from - anyone knows if it is valid to grab the stylesheet directory from a 11.2.0.1 installation and load those?

Cheers,
Tony

On 01/03/13 06:17, Freeman CTR Donald wrote:
> Amazingly I had to do just this thing this morning. Yes, you can remove and replace xdb. The steps are pretty simple. There are several links telling precisely how to set up the ACLs once you have replaced xdb. You can message me off list if you like.
> R/
>
> -----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 14:59
> 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.
>

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

Received on Mon Mar 04 2013 - 02:18:27 CET