Solved

ORA-01119/ORA-27040 Datafile Creation Error

Posted on 2004-09-17
5
4,262 Views
Last Modified: 2008-01-09
Hello,

I am trying to create a new Datafile using OEM on my Linux Red Hat Enterprise 3 (ES) server.
When trying to create a new Object of type Datafile and specifying the name and size attributes, I get the following error:

ORA-01119: error in creating database file '/Disk/oradata/alcieind1.dbf'
ORA-27040: skgfrcre: create error, unable to create file
Linux Error 2: no such file or directory

Please advice ?

PT
0
Comment
Question by:ptreves
  • 3
5 Comments
 
LVL 23

Expert Comment

by:seazodiac
ID: 12086254
make sure that you have the correct file path '/Disk/oradata/alcieind1.dbf'?

do you really have '/Disk/oradata/' directory?

can you post the results of the following commands back?

$df -k


and

$ls -R /Disk
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 12086295
I'm guessing that you've already checked and the filesystem '/Disk/oradata' exists?
Also check that the 'oracle' user has write access to the directory
0
 

Author Comment

by:ptreves
ID: 12091964
Hello,

How can I make sure that the oracle user has write access to the
/DISK1/ORADATA directory ?

PT

PS: Does the case realy matter, upper or lower case ?
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12091980
Case does matter in UNIX system.

can you do this and post the results back?

$ ls -al /DISK1/ORADATA          --or whatever the directory is...
0
 
LVL 23

Accepted Solution

by:
seazodiac earned 500 total points
ID: 12092002
so you have to be careful with the letter case when you are trying to create data file ...

you can change the permission of the directory like this:

say if your oracle user account is "oracle" and it's in dba group

then you have to log in as ROOT into the LINUX OS:

$ chown -R oracle:dba    /Disk1/oradata
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now