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

In article <dischner-ya02408000R2606971747080001_at_news.lrz-muenchen.de>, Anton Dischner wrote:

Carlo,

Creating by hand is not that difficult, but you must get the steps correct:

Set your ORACLE_SID to the name of your new database Do the CREATE DATABASE command, including all of the parameters Catalog the Oracle internals
Catalog any other bits and pieces you may need (e.g. PL/SQL) Create additional tablespaces
Create a rollback segment in the SYSTEM tablespace and on-line it Create other rollback segments in RBS tablespace, and off-line  and drop the one you created in SYSTEM
Create users.

There are cr_db* scripts, and I would recommend that you look at them

If you drop me an e-mail, I will send you the 'standard' scripts that I use. All I do is modify these for each instance I require

As for reading, get The Oracle DBA Handbook IBSN:0-07-881182-1 ($35) as it is a bit easer going than manuals

regs

Neil Chandler.
Neil_Chandler_at_Stratus.com

>Hi Carlo,
>
>you need several years of experience.
>Why do you want to do it by hand ?
>
>My strong advice is not to do so.
>
>Maybe you do it with the installer, examine the 'cr_db...' scripts
>drop the database and modify the scripts.
>
>Kind regards,
>
>Toni
>
>In article <ECDtMq.61w_at_news.cern.ch>, cdv_at_cern.ch (Carlo De Vecchi) 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?
>>
>> Thanks.
>>
>> Carlo De Vecchi.
>
>--
>A. Dischner, SGI&AIX sysadmin, Oracle DBA | Don't let friends
>Institut fuer Klinische Chemie | use WinDose
>Klinikum Grosshadern | Just say NO.
>Ludwig Maximilians Universitaet Muenchen, GER | Please remove
>Marchioninistr.15 81366 Muenchen 49-89-70953202 | _NO_SPAM for email.
Received on Fri Jun 27 1997 - 00:00:00 CDT