OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » OS 1326

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

OS 1326 [message #211960]

Wed, 03 January 2007 04:40

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Hii All

I am having datafile created on a server
and that server is now loaded
i am trying to create a new datafile on a new server
by using that code

 ALTER TABLESPACE "USERS"
     ADD
     DATAFILE '\\Intelss4ke\NAS\OracleDB\users08.ora';

but i got that error

ERROR at line 1:
ORA-01119: error in creating database file '\\Intelss4ke\NAS\OracleDB\users08.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 1326) Logon failure: unknown user name or bad password.

is there is any problem related to the permission on that server
and if it is related to the permission
what are the permission that oracle needs to create the new of on that server

N.B I Can copy and paste files on that server from another one

thanks for everyone helped and helping me

Report message to a moderator

Re: OS 1326 [message #211966 is a reply to message #211960]

Wed, 03 January 2007 04:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> '\\Intelss4ke\NAS\OracleDB\users08.ora
this should be visible from oracle server
It is just a very bad idea to do this.

Report message to a moderator

Re: OS 1326 [message #211984 is a reply to message #211960]

Wed, 03 January 2007 06:14

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Thanks for your reply
but what do you mean by

|this should be visible from oracle server

i just want to create a new datafile to another server

Report message to a moderator

Re: OS 1326 [message #211988 is a reply to message #211984]

Wed, 03 January 2007 06:52

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> i just want to create a new datafile to another server
This is very very bad idea. You are definately looking for trouble.
>>this should be visible from oracle server
Means you must be able to see the remote drive "locally" from the server you are running oracle.
You must share/map the drive to say

G:\..\..users08.ora

I am not a windows guy and have no idea what you call it/how you do it.
Historically oracle has problems with UNC naming and even if not,
having oracle datafiles in a network drive is just about doing things wrong.

[Updated on: Wed, 03 January 2007 06:55]

Report message to a moderator

Re: OS 1326 [message #211993 is a reply to message #211960]

Wed, 03 January 2007 07:04

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

by using maping i got the same error see that code

ALTER TABLESPACE "USERS"
     ADD
     DATAFILE 'z:\OracleDB\users08.ora';

i got the same error

ERROR at line 1:
ORA-01119: error in creating database file '\\Intelss4ke\NAS\OracleDB\users08.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 1326) Logon failure: unknown user name or bad password.

Report message to a moderator

Re: OS 1326 [message #211995 is a reply to message #211993]

Wed, 03 January 2007 07:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

the user in which you are logging has no rights on that share.
You can check that by checking the oracleservices in controlpanel.
Look into the properties. The account you are using might be a 'local system' account.
Change it to the account you are logged in as (assuming your account has rights on shared drive).

As note caution
1. Do this at your own risk.
2. Shutdown the services before doing any of this.
3. Goodluck and never call Oracle support if you have any problem Smile

Report message to a moderator

Re: OS 1326 [message #212149 is a reply to message #211960]

Thu, 04 January 2007 00:47

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

any other suggestion
because i don't want to try something under risk

Report message to a moderator

Re: OS 1326 [message #212205 is a reply to message #212149]

Thu, 04 January 2007 04:25

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You are kidding right?
It seems you are completely disregarding whatever we told you before and asking for more?
Be specific as we cannot generalize all the possible risks that ***you might take*** as we cannot ***read your mind***.
Regards~

[Updated on: Thu, 04 January 2007 07:07]

Report message to a moderator

Previous Topic:	ORA-01092 error:::please help urgent!
Next Topic:	LOGMINER PROBLEM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:40:53 CDT 2024