Home » RDBMS Server » Server Administration » Adding datafile in ASM (Oracle 10g Rel2 )
Adding datafile in ASM [message #390249] Thu, 05 March 2009 11:06 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

I'm trying to add a datafile in a ASM diskgroup but unable to do so . Below is the syntax and the error.

1* alter tablespace iris_data add datafile '+FLASH/IRISSTG'
12:01:17 SYS@IRISSTG1 >/
alter tablespace iris_data add datafile '+FLASH/IRISSTG'
*
ERROR at line 1:
ORA-01119: error in creating database file '+FLASH/IRISSTG'
ORA-17502: ksfdcre:3 Failed to create file +FLASH/IRISSTG
ORA-15113: alias name 'IRISSTG' refers to a directory


The Tablespaces are using OMF structure.

There is space in that diskgroup also.

Kindly help me out.

Raj

[Updated on: Thu, 05 March 2009 11:08]

Report message to a moderator

Re: Adding datafile in ASM [message #390257 is a reply to message #390249] Thu, 05 March 2009 12:01 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

ORA-17502:	ksfdcre:string Failed to create file string
Cause:	file creation failed due to either insufficient OS permission or the file already exists
Action:	check additional error messages 
Re: Adding datafile in ASM [message #390260 is a reply to message #390257] Thu, 05 March 2009 12:05 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Thanks I could solve it
Re: Adding datafile in ASM [message #390264 is a reply to message #390260] Thu, 05 March 2009 12:12 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks.

What was the problem? How did you fix this issue..

Babu
Previous Topic: ORA-01000: maximum open cursors exceeded error
Next Topic: ORA-01555 caused by sql statement
Goto Forum:
  


Current Time: Tue Dec 06 08:23:40 CST 2016

Total time taken to generate the page: 0.14133 seconds