Skip to Main Content
  • Questions

  • How to check if oracle directory points to the right location?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Mario.

Asked: October 20, 2016 - 7:42 am UTC

Last updated: October 21, 2016 - 2:16 am UTC

Version: 11.2.0.4.0

Viewed 1000+ times

You Asked

Hello!

Is there a way to check if my directories look at the right folders on my network?
ALL_DIRECTORIES view says the directory path is something like /d01/data/xfer/BLA/BLABLA/IN.
The actual network location is something like \\xyz14311.bla.com\AIX\UAT\BLA\BLABLA\IN.
How do i know for sure that this is setup correctly? I'm getting an error no such file or directory when trying to open a file.
How are those two paths connected?

and Connor said...

There is no magic going on here. It is just like normal file directory access. One thing that *is* important is access privileges. The actual network location you mention suggests you want to write to the *remote* storage location ? If that is the case, then the oracle software needs access to that.

More details in this post

https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:241814624807

In terms of "How are those two paths connected?" this is outside of Oracle. It could be symbolic links on Unix, NFS mounts, or Windows shares etc etc...But we dont do any magic inside the database. We just access files as per normal.

Hope this helps.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.