-
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.
thanks,
-
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.
Regards,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
If you are using ASM, you could use the "asmcmd" utility to copy the flat files to an ASM disk.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
UTL_FILE with ASM is not supported
in 11gR2 you can try with ACFS
-
Originally Posted by pando
UTL_FILE with ASM is not supported
in 11gR2 you can try with ACFS
But external tables are...
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|