Help - Search - Members - Calendar
Full Version: help regarding creation of database manually on linux
Oracle DBA Forums > Oracle > Oracle Forum
shammi
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
aussie_dba
"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.
HAL9000
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.
shammi
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.
SteveC
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.
HAL9000
"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
jal
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,
dave
QUOTE (jal @ Jul 5 2008, 10:51 PM) *
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!
shammi
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
dave
no watch someone just go into that directory and delete the files

in no way shape or form should you use 777
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.