RE: Oracle DB create script for Linux
- From: "Michael Fontana" <mfontana@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 4 Jun 2004 14:29:16 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of jtesta@xxxxxxxxxx
Sent: Friday, June 04, 2004 2:09 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
