OraFAQ Forum: Windows » access denied

Home » Infrastructure » Windows » access denied

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

access denied [message #262250]

Sat, 25 August 2007 11:51

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

hi!
I am using oracle 9i on windows 2000, I am trying to create a tablespace on another server which is on windows 2000 in the same network, but it gives the error as OSD -04002 UNABLE TO OPEN FILE
O/S ERROR (OS 5) ACCES IS DENIED
I am loged in as administrator, I also shared the drive on the server that I am trying to create the tablespace.
Then I also mapped the drive but it showed the same message.
Can somebody please tell what permissions need to be given.

Report message to a moderator

Re: access denied [message #262251 is a reply to message #262250]

Sat, 25 August 2007 11:55

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Check this thread that deals with mapped drives on Windows.

Report message to a moderator

Re: access denied [message #262252 is a reply to message #262250]

Sat, 25 August 2007 11:55

Michel Cadot
Messages: 68777
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I am loged in as administrator

This is useless, this is not you that creates the tablespace files, this is Oracle instance owner.

Quote:

I also shared the drive on the server that I am trying to create the tablespace

This Oracle instance owner is a local user (generally system) and has no access to network drive.
Btw, it is a bad idea to create tablespace with remote files.

Regards
Michel

Report message to a moderator

Re: access denied [message #262325 is a reply to message #262250]

Sun, 26 August 2007 03:21

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

it is fine that remote creation of tablespace is not supported, but I still would like to know how to do this.
The owner for oracle instance is sys

Report message to a moderator

Re: access denied [message #262330 is a reply to message #262325]

Sun, 26 August 2007 03:33

Michel Cadot
Messages: 68777
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I still would like to know how to do this.

Does the link that posted Brian not answer this question?

Quote:

The owner for oracle instance is sys

You have an OS user named sys?

Regards
Michel

Report message to a moderator

Previous Topic:	Error while connecting Oracle 10gr2 on 64 bit windows , from 32 bit windows application
Next Topic:	How to display oracle BLOB image in VB6 ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 02 08:50:56 CDT 2026