Home » Infrastructure » Windows » Oracle External Directory (Windows, 11g)
Oracle External Directory [message #653738] Mon, 18 July 2016 02:08 Go to next message
ninan
Messages: 163
Registered: June 2011
Location: Noida
Senior Member
Hi,

Can we a directory in App server , and then use this directory location in CREATE directory command to point to this directory location, which resides outside Oracle DB server.


Thanks,
Nirmal
Re: Oracle External Directory [message #653740 is a reply to message #653738] Mon, 18 July 2016 02:18 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sure. Here's an example from my server:
SQL> select * From all_directories where directory_name = 'SLIKE_4001';

OWNER      DIRECTORY_NAME  DIRECTORY_PATH
---------- --------------- ----------------------------------------
SYS        SLIKE_4001      \\my_server\d$\Home\Slike_4001
Re: Oracle External Directory [message #653741 is a reply to message #653740] Mon, 18 July 2016 02:23 Go to previous messageGo to next message
ninan
Messages: 163
Registered: June 2011
Location: Noida
Senior Member
Do we need to create a mount point for the remote directory location in DB server and give permission to Oracle user? for this to work.
Re: Oracle External Directory [message #653743 is a reply to message #653741] Mon, 18 July 2016 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
give permission to Oracle user?


The instance owner (the account that started the Oracle instance service, see services.msc OracleService<SID>) must have network privileges which is not a good idea, for security reasons it should be strictly local.

Re: Oracle External Directory [message #653759 is a reply to message #653738] Mon, 18 July 2016 06:41 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
ninan wrote on Mon, 18 July 2016 02:08
Hi,

Can we a directory in App server , and then use this directory location in CREATE directory command to point to this directory location, which resides outside Oracle DB server.


Thanks,
Nirmal


An oracle directory object is merely a synonym, an abstraction, of a directory that exists on the database server.
Oracle does not know nor care if that directory is on local disks or mounted from a SAN or some other server.
Re: Oracle External Directory [message #653950 is a reply to message #653759] Sat, 23 July 2016 13:29 Go to previous messageGo to next message
ninan
Messages: 163
Registered: June 2011
Location: Noida
Senior Member
Hi,

Thanks for your reply. It means that we have to create a Network Mapped / mounted drive in the DB server and then Create the Oracle DIRECTORY object pointing to the Mapped drive / Mounted drive. Right?

Thanks,
Ninan.
Re: Oracle External Directory [message #653951 is a reply to message #653950] Sat, 23 July 2016 13:33 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And give the access rights to the Oracle instance owner which is a security problem in Windows world.

Previous Topic: oracle writes a lot to c:\windows\temp
Next Topic: Could not hotload ZoneInfoFile
Goto Forum:
  


Current Time: Thu Mar 28 15:21:52 CDT 2024