Home » RDBMS Server » Server Administration » OS 1326
OS 1326 [message #211960] Wed, 03 January 2007 04:40 Go to next message
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
Re: OS 1326 [message #211966 is a reply to message #211960] Wed, 03 January 2007 04:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.


Re: OS 1326 [message #211984 is a reply to message #211960] Wed, 03 January 2007 06:14 Go to previous messageGo to next message
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
Re: OS 1326 [message #211988 is a reply to message #211984] Wed, 03 January 2007 06:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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.

Re: OS 1326 [message #211995 is a reply to message #211993] Wed, 03 January 2007 07:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: OS 1326 [message #212149 is a reply to message #211960] Thu, 04 January 2007 00:47 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

any other suggestion
because i don't want to try something under risk
Re: OS 1326 [message #212205 is a reply to message #212149] Thu, 04 January 2007 04:25 Go to previous message
Mahesh Rajendran
Messages: 10672
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:
  


Current Time: Thu Dec 08 14:49:17 CST 2016

Total time taken to generate the page: 0.10890 seconds