Home » RDBMS Server » Server Administration » create database
create database [message #63342] Tue, 28 September 2004 06:22 Go to next message
sidd
Messages: 130
Registered: May 2003
Senior Member
What all I need to create before creating database? Is there any step by step guide to create a database?  Version oracle 9i on unix
Re: create database [message #63347 is a reply to message #63342] Tue, 28 September 2004 09:25 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
First, take a look at the readme file in order for installation requeriments.
Then, on Oracle9i Database Administrator's Guide
take a look at chapter 2.

Best luck.
Oracle Consultant and remote DBA for hire.
Re: create database [message #63349 is a reply to message #63347] Tue, 28 September 2004 09:49 Go to previous messageGo to next message
sidd
Messages: 130
Registered: May 2003
Senior Member
Thank you sir, I am reading the docs, if you can give me some information about:
What permissions do I need to have to create a db in unix environment, like to what directories I should be able to write into, what user I should login(unix) as to create a db and stuff like that. Appreciate your response
Re: create database [message #63353 is a reply to message #63349] Tue, 28 September 2004 21:46 Go to previous messageGo to next message
hm joshi
Messages: 5
Registered: September 2004
Junior Member
log on with system/manager or sys/change_on_install
Re: create database [message #63563 is a reply to message #63342] Fri, 15 October 2004 19:53 Go to previous message
Balaji
Messages: 102
Registered: October 2000
Senior Member
hi

1. first install the oracle software and oracle_home should be having the rwx permissions for the oracle user on unix.
others can have the rx permissions

the same goes for those datafiles that hold the ser data .

take care to see that all enviromnent variables are not available to other than the oracle,oraclegroup.

to install read the readme available in the first disc.

2 .to create a database u can use the dbassist utility that is bundled with oracle

when u log on as oracle on ur host

$ oemapp dbassist

the above command will start the utility that is a gui
based tool that takes all input from u and creates the database for u .

with best wishes
balaji
Previous Topic: re: old_datafiles_deletion_for additional diskspace
Next Topic: creation of new database in already running server
Goto Forum:
  


Current Time: Fri Jan 24 18:41:46 CST 2025