Home » RDBMS Server » Server Administration » ORACLE DBA (merged)
ORACLE DBA (merged) [message #409823] Wed, 24 June 2009 03:34 Go to next message
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 #409833 is a reply to message #409823] Wed, 24 June 2009 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is there a line feed in your path name?

Please read OraFAQ Forum Guide and
* Do not post your title in UPPER case
* Post a meaningful title
* Format your post
* Always post your Oracle version (with 4 decimals)
...

Regards
Michel
Re: ORACLE DBA (merged) [message #409835 is a reply to message #409823] Wed, 24 June 2009 03:58 Go to previous messageGo to next message
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
Re: ORACLE DBA (merged) [message #409842 is a reply to message #409835] Wed, 24 June 2009 04:16 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Also

Quote:
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 you proof all the details.
Previous Topic: Error while enabling database_tab_monitoring
Next Topic: Dedicated USR1234 to instance1 only
Goto Forum:
  


Current Time: Fri Dec 02 23:03:08 CST 2016

Total time taken to generate the page: 0.24871 seconds