This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Aug 29, 2013 8:38 AM by Richard Harrison . Go to original post RSS
  • 15. Re: ORA-31645: unable to read from dump file
    Richard Harrison . Expert
    Currently Being Moderated

    Hi Maggie,

    i think what is happening is you have the files on the node where the instance db01 is running, when you connect to user/pass@db it doesn't necessarily connect to db01 even if you run it from the node where the db01 instance is running. What was likely happening was the connection was made to db02 where the directory containing the files wasn;t visible (the files were not created on a cluster filesystem which is visible on all nodes). Even with cluster=n this can happen all that means then is that the job would still start on db02 say but would not attempt to run on any other node than that.

     

    If you use ASM the file is visible on all nodes and you get no issue, also if you use a cluster file system it is visible on all nodes.

     

    Hope that explains it?

     

    Cheers,

    Harry

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points