OraFAQ Forum: Server Administration » DATAFILE IN NETWORK PATH

Home » RDBMS Server » Server Administration » DATAFILE IN NETWORK PATH (10G WIN)

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

DATAFILE IN NETWORK PATH [message #326395]

Wed, 11 June 2008 06:17

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

hello
i install new instance in my pc
i have all of DB in my NETWORK PATH

i do this:

\\....\oracle

now i see drive Z:\

i succed to startup mount
but in create control file
i get this error:

"ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file 'z:\CRP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

but its actualy the rigth path
please help

Report message to a moderator

Re: DATAFILE IN NETWORK PATH [message #326397 is a reply to message #326395]

Wed, 11 June 2008 06:21

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

Senior Member
Account Moderator

Windows Network/UNC drive are not supported by Oracle.

Regards
Michel

Report message to a moderator

Re: DATAFILE IN NETWORK PATH [message #326398 is a reply to message #326395]

Wed, 11 June 2008 06:23

varu123
Messages: 754
Registered: October 2007

Senior Member

What is system.data1?
The extension should be .dbf.

Report message to a moderator

Re: DATAFILE IN NETWORK PATH [message #326405 is a reply to message #326398]

Wed, 11 June 2008 06:31

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

also i i see its
drive Z:
?

Report message to a moderator

Re: DATAFILE IN NETWORK PATH [message #326415 is a reply to message #326398]

Wed, 11 June 2008 06:37

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

Senior Member
Account Moderator

varu123 wrote on Wed, 11 June 2008 13:23

What is system.data1?
The extension should be .dbf.

Wrong! It can be what you want.

Regards
Michel

[Updated on: Wed, 11 June 2008 06:38]

Report message to a moderator

Re: DATAFILE IN NETWORK PATH [message #326416 is a reply to message #326405]

Wed, 11 June 2008 06:38

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

Senior Member
Account Moderator

lioracle wrote on Wed, 11 June 2008 13:31

also i i see its
drive Z:
?

What does this mean? Question

Regards
Michel

Report message to a moderator

Re: DATAFILE IN NETWORK PATH [message #326417 is a reply to message #326395]

Wed, 11 June 2008 06:41

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

i have the right name and path

and i have drive letter named Z
and its network path

cant oracle startup with network path
not like this \\server\\...

just Z:

mean MAP NETWORK

Report message to a moderator