Re: OEM - 9i Windows XP -

Part of your post shows you do not yet understand the difference between a pfile and an spfile. Your system appears to be running from an spfile. It is probably in c:\oracle\ora92\database as "spfile||SID||.ora" like spfilesr9i.ora or something similar.

You can use OEM (menu Object) and create a pfile from your existing spfile. Don't try editing your spfile directly oracle won't like it. But you can edit your pfile (created from spfile) and make the multiple line entries for multiple utl_file_dir locations that you want to there.

You can go back and forth creating pfiles from spfiles and vice versa.

Then you can start your oracle instance from the pfile instead of the spfile if you proceed carefully. Check out the doc on startup if doing it from command line otherwise OEM can be used to OPEN a database from a pfile ... (if you select the checkbox (use spfile for startup) then oracle will only use the spfile that it finds in the order that it searches just be careful there).

It looks like oracle has some bugs in this area as after I put multiple lines in the pfile with utl_file_dir then created spfile's from it, the create spfile works fine but oracle doesn't seem happy with the results. Also several attempts to use alter system set utl_file_dir scope=spfile were accepted with variations there trying to put in multiple destinations ... but the instance then had problems using that spfile even though the alter system set (appeared to) work ok. (All just playing around on windows on my desktop not real unix oracle!).

Make a copy of your spfile before you do anything then play around some. Received on Fri Jun 18 2004 - 12:19:38 CDT