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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle DB create script for Linux

RE: Oracle DB create script for Linux

From: Michael Fontana <mfontana_at_verio.net>
Date: Fri, 4 Jun 2004 14:29:16 -0500
Message-ID: <001601c44a6a$3983bc20$380b0a0a@corp.verio.net>


Yes, but then after you're done, wipe that verification instance off the face of the earth. In Oracle 9i, you will end up with a boatload of unnecessary schemas and system objects supporting schemas for Oracle products and features you will unlikely want and never use. Worse still, they cannot be removed! One example of this is Oracle Wallet Manager.

We like to run a generic database creation script, which precreates all of our standard utility tablespaces (such as TOOLS and USERS and one called "SMALL_DATA" which is as it's name implies. We then create administrative objects to configure and management the instance with some homegrown monitoring tools that we know work on all platforms.

Good luck!

Michael Fontana
Sr. DBA
NTT/Verio

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of jtesta_at_dmc-it.com Sent: Friday, June 04, 2004 2:09 PM
To: oracle-l_at_freelists.org
Subject: Re: Oracle DB create script for Linux

Ron, truthfully as much as I hate the GUI tools, for any new version or platform, i run the dbca or dbassist or whatever the heck they call it now. Have oracle build (but not run) all of the scripts out of the tool and use it as a baseline when doing experimentation on a new platform or OS.

Joe

> I am trying to create my first 9i database on Linux 2.1.
>
> Does anyone have a sample create script and init file that I can use
> as a sample?
>
> Thanks!
> Ron



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Jun 04 2004 - 14:26:33 CDT

Original text of this message

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