create database [message #63342] |
Tue, 28 September 2004 06:22 |
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 |
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 |
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 #63563 is a reply to message #63342] |
Fri, 15 October 2004 19:53 |
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
|
|
|