Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with database creation: Oracle 9.2.0

Re: Help with database creation: Oracle 9.2.0

From: Chuckster <chuckycarson_at_networkcloud.com>
Date: Tue, 30 Jul 2002 22:46:18 -0700
Message-ID: <3D4779AA.3000503@networkcloud.com>

I did not know this was possible. How can I fire up the database creation assistant once oracle is installed?

Thanks,
CC

Thomas Hesse wrote:

> Why don't you use the database assistant, store the create scripts and 
> edit them ?
> 
> Chuckster wrote:
> 

>>
>> I have pieced together this script but it gives me ORA-30014 at line1.
>> Metalink wasn't too helpful. I am pretty solid with Oracle 8.1.7 but
>> some of the terminology in this script is new to me. I found this
>> script on google. (I merely changed the mount points and instance name)
>>
>> I start the script as follows:
>> $ORACLE_HOME/bin/sqlplus /nolog @create_database.sql
>>
>> Here is the script (create_database.sql):
>>
>> connect SYS/change_on_install as SYSDBA
>>
>> spool create_RHUGGA_database.log
>>
>> startup nomount
>>
>> SELECT 'START TIME: ' || TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') as
>> Start_Time
>> FROM dual;
>>
>> CREATE DATABASE "RHUGGA" NOARCHIVELOG
>> MAXLOGFILES 32
>> MAXLOGMEMBERS 5
>> MAXDATAFILES 600
>> MAXINSTANCES 10
>> MAXLOGHISTORY 1000
>> DATAFILE
>> '/u01/oradata/RHUGGA/system01.dbf' size 200M
>> REUSE
>> AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
>> DEFAULT TEMPORARY TABLESPACE temp
>> TEMPFILE '/u01/oradata/RHUGGA/temp01.dbf' SIZE 100M REUSE
>> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 500K
>> UNDO TABLESPACE "UNDOTBS" DATAFILE
>> '/u01/oradata/RHUGGA/undotbs01.dbf' SIZE 100M
>> REUSE
>> AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
>> CHARACTER SET WE8ISO8859P1
>> NATIONAL CHARACTER SET UTF8
>> LOGFILE
>> GROUP 1
>> ('/u01/oradata/RHUGGA/redo_g01a.log',
>> '/u02/oradata/RHUGGA/redo_g01b.log',
>> '/u03/oradata/RHUGGA/redo_g01c.log') SIZE 5M,
>> GROUP 2
>> ( '/u01/oradata/RHUGGA/redo_g02a.log',
>> '/u02/oradata/RHUGGA/redo_g02b.log',
>> '/u03/oradata/RHUGGA/redo_g02c.log') SIZE 5M,
>> GROUP 3
>> ( '/u01/oradata/RHUGGA/redo_g03a.log',
>> '/u02/oradata/RHUGGA/redo_g03b.log',
>> '/u03/oradata/RHUGGA/redo_g03c.log') SIZE 5M
>> /
>>
>> <SNIP>
>>
>>
>>
>> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
>> ==----------
>> http://www.newsfeed.com The #1 Newsgroup Service in the World!
>> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
>> =-----

>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Jul 31 2002 - 00:46:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US