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: Oracle 9i DB creation

Re: Oracle 9i DB creation

From: Howard Rogers <Howard.Rogers_at_oracle.com>
Date: Wed, 17 Apr 2002 13:45:41 +1000
Message-ID: <4c6v8.27$tV6.254@news.oracle.com>


And your O/S would be....... ???

Two thoughts spring to mind: one is, yes, there are manual methods of creating a database, but they are somewhat different depending on whether you are using NT or Unix (on NT, you need to create services, on Unix you don't).

The second is: let the Wizard have its way with respect to the 30Mb settings. Create the database in its default, RAM-bloated, state. And then, when its successfully created, get in there and edit the init.ora to bring it back to something approaching reasonableness by adjusting the shared_pool_size, java_pool_size and db_cache_size parameters (not forgetting, of course, sga_max_size). The initial creation might then cause a vast amount of swapping and dreadful performance, but one edit of the relevant files later, and you've the small and compact instance you want.

If you take the second approach, don't forget that the wizard tends to create 9i database with an SPFILE as well as a PFILE. Therefore, you edit the PFILE to get the memory components smaller, but if you just say 'startup' afterwards, nothing changes -because Oracle's using the SPFILE to build the instance, not the freshly-edited pfile. Therefore, you have to force startup to use the pfile by including the "pfile=" parameter, and then use the 'create spfile from pfile' command to make sure all subsequent startups use the smaller parameters.

Regards
HJR "Tintin" <nospam_at_nospam.com> wrote in message news:bu5v8.30218$Rw2.2270522_at_bgtnsc05-news.ops.worldnet.att.net...
> In Oracle 9i, using the database wizard, I created a database. Three of
the
> settings on one of the tabs wants a memory size of at least 30MB. I think
> it's "shared pool size", "java pool size" and the other one escapes me.
>
> If I specify a number less than 30MB, at the end of the wizard it stops
you
> creating the database. Is there any other way to create a database in
> Oracle other than using their wizard? For now until I get more RAM, I
would
> like to create a smaller database using less RAM.
>
> Thanks.
>
> ~ !T
>
>
Received on Tue Apr 16 2002 - 22:45:41 CDT

Original text of this message

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