Re: utl_file_dir in RAC

The spfile format does support associating a parameter value to a specific RAC instance so in theory you could have different values in the utl_file parameter for the two instances. But you will have to make sure that code that uses a specific directory always runs on the correct server or an error will result.

I do not understand why you would want this unless you were on a platform without a shared file system in which case the most common solution would probably be to NFS mount a file so that all db servers could access one common structure.

But from experience I know you can add a file that exists on only one node to a RAC system and it will run just fine until such time as another instance attempts to access something allocated to the file. Not a good thing.

The "in theory" part means I have not tested this. The utl_file parameter still exists in 10.2 but like Daniel said you should really be using CREATE DIRECTORY.

HTH -- Mark D Powell -- Received on Thu Mar 30 2006 - 14:20:24 CST