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

First make a initXXX.ora in $ORACLE_HOME/dbs (make sure it does not explicitly call out any rollback segments and that you have already set the /etc/system parameters have been set).

then

svrmgrl

  connect internal

  startup nomount

  create database XXX
  logfile '/redo_logs/redo_1.dbf' size 1M,   '/redo_logs/redo_2.dbf' size 1M,
  '/redo_logs/redo_3.dbf' size 1M
  datafile '/data/system_1.dbf' size 50M   archivelog;

  Then of course you will have to set up tablespace, non-system rollback segs., etc, etc.

-- 
	Scott Kelley (skelley_at_online.disney.com)
	Webmaster/Database Administrator for Disney Online



# THIS IS A DISCLAIMER: The above statements were written by Elves.

# The above is not the position or opinion of the Walt Disney Company.