Re: Creating a DB from scratch on UNIX (AIX)

Alex Cheung (alexcheung_at_onramp.ca) wrote:
: I would like to know the exact sequece of operations
: to do if, after having installed an Oracle server on AIX
: without the option for the automatic DB creation, I would
: like to create the DB by hand.
: The oracle documentation say that it is not easy but doesn't
: explain how to do it...
:
: Can somebody help me?
: Some suggested reading?

I went through this earlier this year, but I had the advantage of having done a test installation where I did do the goofy database creation during the install process and I used the files it created as a starting point. But even with that, it was difficult because there are no clear instructions anywhere on this process.

You need a "create database" script along with an init.ora and config.ora files. You also need directory structures and/or file systems for log/trace files, tablespace data files, control files, etc.

Send me email if you want my create script to use as a dart board. The only caveat is that you don't laugh at it because I have no doubts that anyone with serious Oracle experience will be able to recognize the work of an amateur. :-)

The good news is that once you've worked your way through it once, it's a very repeatable process. But getting it done that first time can be a bear.

				Good luck,
				Teresa Larson

     _________________________________________________________________
    /  Teresa A. Larson                 http://www2.ari.net/jmasino/ /
   /  Bell Atlantic                          Voice: (301) 282-0224  /
  /  13100 Columbia Pike, A-3-3              Fax:   (301) 282-9416 /
 /  Silver Spring, MD  20904         Teresa.A.Larson_at_bell-atl.com /
/________________________________________________________________/
                      #include <std_disclaimer>