| ORACLE DBA (merged) [message #409823] |
Wed, 24 June 2009 03:34  |
mamillagp
Messages: 1
Registered: June 2009
|
Junior Member |
|
|
Hi all,
i am new to this forum as well to oracle DBA , i was facing an issue While creating the database in UNIX
Here is the error
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/opt/oracle
/oradata/MRSTLPRD/controlfile/control03.ctl'
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
Out of 3 control files 2 files has been created and third control file is errored out with the above error
I have checked the below options in order to solve the above error
1) unix path ,name of control file and every thing is correct
2) plenty of space is available
3) privileges are there to write the control files in that path(since 2 control files are already written there should not be any privilege issue there)
Can any one help any thing else needs to be changed in order to solve the above issue
|
|
|
|
|
|
| Re: ORACLE DBA (merged) [message #409835 is a reply to message #409823] |
Wed, 24 June 2009 03:58  |
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
|
Member |
|
|
1. Check out the permissions on the filesystem.
2. Check if there is space on the file system.
3. Verify if the file system is fine.
4. Verify if the file already exists in the filesystem.
Rgds
MOhammed
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
