Re: Step by step instructions for making a database sans Enterprise Manager?

In 8.0.4 (UNIX platform) the scripts to create the basic database on install (which can be modified for your own use) are located in $ORACLE_HOME/rdbms/install/rdbms - they are crdb.orc and crdb2.orc

Alex

gremlin wrote:

> Thanks,
>
> I am running Oracle 8, and I didn't see any Build*.sql scripts. Did they get
> renamed? As a matter of fact I didn't see any scripts with CREATE DATABASE in
> them. Just CREATE DATABASE LINK. The directory names you (and others) have given
>
> me are NT directories aren't they? I don't think Unix puts the version (7.X) in
> the path. Perhaps these scripts just aren't there for unix?
>
> (I did find them on an Oracle 7.3 NT installation and printed them out, so I might
> be OK.)
>
> Thanks to all,
> Mike
>
> eswar_oracle_at_hotmail.com wrote:
>
> > Hi Mike
> >
> > You can find the scripts in
> >
> > 1. Oracle_home\rdbms7.X\Admin\Buildall.sql
> > 2. Oracle_home\rdbms7.X\Admin\Build_db.sql
> >
> > You can read the scripts. But make sure to change control file destinations
> > appropriately , otherwise your your system may crash.
> >
> > Step 1. Copy Init<sid>.ora file to the directory you want to keep the database
> >
> > Step 2. Edit the parameters (Contolfile,db_name,db_block_size etc). Point the
> > contolfile to the database directory .(Do not forget to do this step
> > otherwise everything will go hayway)
> >
> > Step 3. Run the scripts
> >
> > As jerry sugested you can follow those books alternativly you can also refer
> > to Steven Babroski book.
> >
> > Regards
> >
> > Eswar
> >
> > In article <eAXy2.3610$rs2.4524983_at_client.news.psi.net>,
> > "Jerry Gitomer" <jgitomer_at_ictgroup.com> wrote:
> > > Hi,
> > >
> > > Based on your question you should do a little research before you build
> > > a new database. The best reference for what you want to do and what you
> > > will need once you do it :-) is Kevin Loney's "The DBA Handbook" Oracle
> > > Press. Pick up the appropriate version (Oracle release 7 or Oracle release
> > > 8) and you will find complete scripts for building new database instances
> > > along with explanations.
> > >
> > > regards
> > >
> > > Jerry
> > >
> > > gremlin wrote in message <36CBAC55.B235B2A_at_ix.netcom.com>...
> > > >Hi:
> > > >
> > > >I am trying to create a new database on a unix box. I have the default
> > > >one (with Scott/tiger, etc.) but I want a new database. I don't have an
> > > >Enterprise Manager, etc. (or if I do I don't see how to run them!) and
> > > >the books usually end up saying, "bring up the EM and click on...". Or
> > > >the books mention to give the CREATE DATABASE some data files without
> > > >saying how you get/generate them, etc. Where can I find detailed
> > > >instructions on the entire process for doing it by hand?
> > > >
> > > >TIA,
> > > > Mike
> > > >
> > > >
> > > >--
> > > >-----------------------------------------------------
> > > >To reply to me via email, remove the "__NO_SPAM__" in
> > > >the header email address.
> > > >-----------------------------------------------------
> > > >
> > > >
> > >
> > >
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> --
> -----------------------------------------------------
> To reply to me via email, remove the "__NO_SPAM__" in
> the header email address.
> -----------------------------------------------------
Received on Mon Feb 22 1999 - 02:59:17 CST