If using plsql native code, the plsql_native_library_dir needs to be defined. In RAC environement, must the directory be in the shared storage?
In RAC configuration, this parameter must be set in each instance. The instances are not required to have a shared file system. On each instance the plsql_native_library_dir can be set to point to an instance local directory. Alternately, if the RAC configuration supports a shared (cluster) file system, you can use a common directory (on the shared file system) for all instances.