Re: Creating new Oracle database on Solaris

Hi Jerry,

Thanks a lot for detaild reply. I will try this.

Regards
Bandoba

Jerry Gitomer wrote:
>
> Look in $ORACLE_HOME/rdbms/admin for a pair of scripts whose names begin
> with CR.
> If I remember correctly one is named crdb.sql and the other crdb2.sql.
> The first creates a database and the second creates the tablespaces,
> rollback segments, and the other essentials. Before you run them go in
> and do some editing. For example you will want to edit any references
> to init<SID>.ora and config<SID>.ora to match your new instance. Also
> make sure that the control files, log files, and archives are routed to
> a different set of diretories than those used by your existing
> instance. Oh yeah, while you are editing change the value for maximum
> files to somehting reasonable.
>
> Also, don't worry about screwing up. If necessary you can just delete
> any files that were created and rerun the scripts.
>
> hth
>
> Bandoba wrote:
>
> > Hi,
> >
> > I am using Oracle 8 running on Sun Solaris 2.6. I installed it with
> > default options and the installation created default database. Now I
> > want to create another database on the same server. Can anybody tell
> > me how to do that? On NT, I used Database Assistant tool, but on Unix
> > I didn't find it. Are there any scripts are tools which I should look
> > for?
> >
> > TIA
> > Bandoba
> >
> > --
> > Posted via CNET Help.com
> > http://www.help.com/
>
> --
> Once I figured out how to spell DBA I became one
> -- Jerry Gitomer

--
Posted via CNET Help.com
http://www.help.com/ Received on Tue Dec 28 1999 - 21:30:53 CST