Re: OEM - 9i Windows XP -

"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message news:MPG.1b3bb5572f72bc9f989c6c_at_news.individual.net...
> OK here's a question - how do you add an additional parameter to the
> database using the Edit Database: Configuration screen?
>
> I have clicked into all "initialization paramaters" and see there e.g.
> UTL_FILE_DIR and I want to add an additional entry. But there doesn't
> appear to be a means of adding a new parameter.
>
> Is my vision defective or my knowledge lacking (the latter I suspect in
> this case). Upn until now, used to editing the init.ora file for 8i and
> earlier databases.
>
> --
>
> jeremy

I just quickly fired up OEM for my 9i Release 2 database on Windows, in standalone mode, and under the General Tab of the Instance - Configuration branch, the All Initialisation Parameters button does exactly what it says it will do and shows me *every* parameter (except the underscore ones, but as they're not supported anyway, I'm not surprised). All 257 of them (I counted). So it then becomes a question merely of editing the ones that are listed, not trying to add to them.

But reading your post again, I don't think you want to add a new parameter at all. You just want to add a new value to an existing parameter (UTL_FILE_DIR takes a comma-separated list of values as its argument, rather in the same way as CONTROL_FILES does).

Regards
HJR Received on Thu Jun 17 2004 - 14:14:49 CDT