| 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?
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
--
 |
 |