Read Flat files in RAC
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Read Flat files in RAC

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    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.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can use either cluster filesystem or NFS to share files

  3. #3
    Join Date
    Mar 2008
    Posts
    140
    How to use cluster file system? (Do you mean storage)

    And How to use NFS.

    thanks,

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Cool

    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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    UTL_FILE with ASM is not supported

    in 11gR2 you can try with ACFS

  7. #7
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480
    Quote Originally Posted by pando View Post
    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
  •  


Click Here to Expand Forum to Full Width