| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Step by step instructions for making a database sans Enterprise Manager?
Thank you very much for your help. I will look for the identical files under the
Oracle 8 directories. I'll also be looking for that book!
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
--
 |
 |