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

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 Received on Thu Feb 18 1999 - 23:26:54 CST