Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle DB create script for Linux
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
-- 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