Re: Create a database from scratch (When dbassist goes bad)

One thing you could do is to try dbassist on an NT machine where it appears to run more reliably. Go through all the configuration steps, but at the end instead of creating the database just build the files that would be needed to create the database later.

If you do this you will see a bat file with many other script files (13 others in the case I just ran) in the ORACLE_HOME/assistants/dbca directory. You will also see a set of directories for the trace files, pfile, and data files that were created in anticipation of running the master script file that would create the new database.

You could study these scripts to see what you need to prepare and have to run to create a database manually. If you modify these scripts where necessary to conform to the Linux environment and shell and the options you wish to install you might even be able to use them to create the database.

Although this solution does rely on a GUI tool to generate the scripts, you should not need such a tool to actually create the database.

Frank Hubeny

Scott Watson wrote:

> Group,
>
> I would like to create a database using good old svrmgrl. I recently did a
> fresh install of Oracle 8.1.6 on Red Hat 6.1 and when it came time to create
> a db, dbassist sat there doing nothing. I think it had thrown some Java IO
> expception, but nothing it could recover from. With dbassist out of the
> loop I thought I would create it from scratch, but I have no files (init.ora
> ...) or scripts for reference.
>
> I was hoping someone could post the necessary files and the SQL commands to
> get me started. If you prefer you can send them to my email
> scott.watson_at_videotron.ca (please don't assume someone has answered me and
> not send a reply. If you have the files and the time please send it to me
> as I am predicting not too many people will take the time to send me the
> info I need.)
>
> Otherwise can you post the steps to the group that outlines how to create a
> database or a link to someone who has already explained how to do this.
> Remeber no GUI tools!!!!
>
> Thanks,
> Scott.
Received on Tue Aug 22 2000 - 21:54:55 CDT