Re: What's the Solaris....

If creating a new database is where you're headed, then the database creation assistant is very much improved. These days we create every new database with the assistant, then tweak it afterwards. The assistant takes care of all the housekeeping for you - adding an entry in tnsnames.ora, stopping and restarting the listener, taking care of your intelligent agent, etc. etc.

Van

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3983768a_at_news.iprimus.com.au...
>
> "DataBog" <DataBog_at_monmouth.com> wrote in message
> news:g2Kg5.91628$lU5.655737_at_news1.rdc1.nj.home.com...
> > tool that is equivalent to NTs ORADIM80 to create a new database
 instance.
> > I know I deserve to get abused for this question but I can't find it any
> > where in the docs and I'm running out of time. The docs point to
 attaching
> > via enterprise manager via Windows to create the instance ID. But that
> > confuses me because in the old days (V6 and 7) we would have used
 sqldba.
> > What is the 'today' equiv. I have already created duplicate DBs in an
 NT
> > environment but would like to export one to a Solaris box to do some
> > performance comparisons.
> >
>
> There's no equivalent. ORADIM is the NT tool that is required to create
 the
> NT services associated with an Instance. Unix doesn't have those sorts of
> services, so ORADIM is not required.
>
> All you have to do to create an Instance (and I'm assuming you're using
> Oracle 8.0 of some sort, and that it's already been correctly installed)
 is:
> 1) export ORACLE_SID=xxx (ie, the name you want for your Instance)
> 2) fire up Server Manager (ie, 'svrmgrl' at the command line),
> 3) connect / as sysdba (assuming O/S authentication)
> 4) startup nomount pfile=initxxx.ora (assuming you've already got an
> appropriate init.ora file created and properly set -make sure especially
> that the db_name, control_file and db_block_size parameters are properly
> set)
>
> That gets you a bare Instance. You can now issue the 'create database xxx
 

> logfile group 1 'yyy' size 1M, group 2 'zzz' size 1M datafile 'aaa' size
> 100M' command, and you'll build yourself a database to go with it (the
> control file will be created wherever the control_files parameter in
> init.ora specifies).
>
> You then need to run catalog.sql and catproc.sql (usually found in
> $ORACLE_HOME/rdbms/admin) to make the new database fully functional.
>
> Hope that helps
> HJR
>
>
>
> > Thanks in advance for any feedback
> >
> >
> >
> >
>
>
Received on Sun Jul 30 2000 - 00:00:00 CDT