Re: Oracle 11g placement of the alert log

From: Mladen Gogala <>
Date: 13 Jan 2008 21:25:27 GMT
Message-ID: <478a81c6$0$1340$>

On Sun, 13 Jan 2008 07:47:32 -0800, DA Morgan wrote:

> I didn't think it appropriate to advertise what you posted but you are
> correct.

I tried to avoid posting the exact details, but I had to respond when challenged. Without deactivating ADR, my statement is patently untrue. If you remember, I was already scolded once on this group for posting exact details of a security flaw. I don't think this is as serious as that was.

> Unfortunately dinosaurs will now try to also create dictionary
> managed tablespaces, rollback segments, and find the source code for
> svrmgrl. <g>

Dan, I really do appreciate your work, I think you're doing a marvellous job but sometimes you're too harsh. I don't have any Oracle11 databases in production yet and I am intensly studying the product. If there are scripts to be preserved at all cost, setting that parameter is an option. It goes without saying that a person who would deactivate a major new feature should know what he or she is doing. I don't see any "dinosaurs" around, except maybe myself. I 47 years old as of January 10 and for a computer geek I do have a bit of a long tooth. I am, however, trying to stay in sync with the latest versions and technology.

> The entire ADR infrastructure is based on the log files being at a
> specific location, under ADR_BASE and ADR_HOME. If you move one piece of
> it your break the stack. I can't say from trying it but I would now
> expect some of the RMAN and DBMS_IR functionality to not work.

I agree. It will probably have similar effect as setting the compatibility to 10.2, but without rolling the optimizer features back. I do not recommend doing that, I simply said that it is possible. Whoever does so, must be aware of the implications. I am still trying to learn the product and I am doing so very thoroughly, trying to answer the specific questions that my management will ask me. Enabling and disabling features does fall into that category. Personally, I didn't do that on my testing databases.

Received on Sun Jan 13 2008 - 15:25:27 CST

Original text of this message