OraFAQ Forum: Windows » Oracle External Directory

Home » Infrastructure » Windows » Oracle External Directory (Windows, 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle External Directory [message #653738]

Mon, 18 July 2016 02:08

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

Report message to a moderator

Re: Oracle External Directory [message #653740 is a reply to message #653738]

Mon, 18 July 2016 02:18

Littlefoot
Messages: 21715
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

Report message to a moderator

Re: Oracle External Directory [message #653741 is a reply to message #653740]

Mon, 18 July 2016 02:23

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.

Report message to a moderator

Re: Oracle External Directory [message #653743 is a reply to message #653741]

Mon, 18 July 2016 02:55

Michel Cadot
Messages: 68175
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.

Report message to a moderator

Re: Oracle External Directory [message #653759 is a reply to message #653738]

Mon, 18 July 2016 06:41

EdStevens
Messages: 1375
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.

Report message to a moderator

Re: Oracle External Directory [message #653950 is a reply to message #653759]

Sat, 23 July 2016 13:29

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.

Report message to a moderator

Re: Oracle External Directory [message #653951 is a reply to message #653950]

Sat, 23 July 2016 13:33

Michel Cadot
Messages: 68175
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 27 20:46:12 CDT 2022