hi.

i m facing problem while creating database manually on linux.. i m using oracle10g on satndalone pc...My problem is this wen i execute create database command i got these errors:


ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: controlfile
ORA-27040: file create error, unable to create file
Linux error: 13: Permission Denied


Also wen i try to create database through DBCA on linux it give these errors:

Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified


please help

THANKS IN ADVANCE

"i m facing problem while creating database manually on linux"

How could this possibly be urgent?

Urgent request go on MetaLink:

metalink.oracle.com


"My problem is this wen i execute create database command"

Did you bother to look up your error message?

"ORA-00200: control file could not be created"

Obviously, you did not read the pre-install documentation either, since this error means that you did not set up your filesystem properly:

ORA-00200: control file could not be created

Cause: It was not possible to create the control file.

Action: Check that there is sufficient disk space and no conflicts in filenames and try to create the control file again.

Here is a minimal database creation checklist.

http://www.dba-oracle.com/oracle_create_database.htm

Just make sure that yoiu have set up the "oracle" LINUX user, and that all Oracle directories have 770 permissions.

hi HAL9000

script is fine i checked. i thk there is some permission error as i hav little knowledge of linux
please tell me tell me how to give or check 770 permissions.

Buy a book on UNIX, search the Internet for freebie tutorials, do some leg work on your own. You may as well be asking how to turn on a computer, that is the level you are asking help about.

"please tell me tell me how to give or check 770 permissions."

You use the chmod command.

You cannot learn Linux in a week, or even a month. If you want to learn Linux for Oracle fast, get Jon Emmon's book "Oracle Easy Linux":

http://www.rampant-books.com/book_2005_1_linux_commands.htm

Hi,
Which user is running the manual database creation script ?

To use the oracle database creation script (dbca) you will need to run it in graphical mode (init 5) on the server
or use the forwarding facility from a client.


Regards,

its quite clear he is using the create database command, not dbca - please read!

THANKS TO ALL PEOPLE WHO GIV ME THEIR VALUABLE SUGGESTIONS.....

MY PROBLEM HAS BEEN SOLVED.....I GIV 777 PERMISSION ON DIRECTORIES N THE PROBLEM IS FINISHED


SPECIAL THX TO HAL9000

no watch someone just go into that directory and delete the files

in no way shape or form should you use 777