Read Flat files in RAC
We have RAC with 2 nodes with Active/Active configuration. The application reads flat files which is located in one node (/u001/app/oracle/myfiles), but due to load balancing when user connects to other node and try to read from flat file, he is getting error as File not found because the file is on node1.
How to solve this issue? The OS is Solaris.
you can use either cluster filesystem or NFS to share files
How to use cluster file system? (Do you mean storage)
And How to use NFS.
Please check with your storage admin or system admin.
If you are using cluster file system to store the flat files then both the nodes in the RAC can see the file system.
If you are using NFS you need to mount the same file system in both the servers.
If you are using ASM, you could use the "asmcmd" utility to copy the flat files to an ASM disk.
UTL_FILE with ASM is not supported
in 11gR2 you can try with ACFS
But external tables are...
Originally Posted by pando