Re: create database fatal error

On Fri, 04 Jul 2008 15:55:26 +0100, Tommy Halsbrekk <tommy@[EMAIL PROTECTED]
>
wrote:

>Hi
>
>I am having some serious problems with my create data procedure. After 
>the CREATE DATABASE statement i run the catalog.sql and catproc.sql 
>scripts. During the catproc script it after a while encounters a massive 
>amounts of errors ending up in a fatal error whihc terminates the 
>session. All statements after that do not complete because its not 
>connected to oracle.
>
>Does anybody know what the problem is? I am running 10.2 on solaris 10.

Surely. You are using the wrong tools for the wrong job.
Tools like OUI (Oracle Universal Installer) and DBCA (Database
Creation Assistant) all come with a silent mode.
Using silent mode, you would need to set up a template only once, and
you can use dbca from the commandline to create your database.

Your second problem is you don't even try to understand error
messages.
If you would have done so, you would have noticed your SYSTEM
tablespace is out of space.
Which is not surprising as a SYSTEM tablespace of 100M is a joke.
It needs to be 250M minimum.

Finally: I don't think any serious DBA would like to see third party
software create a database. DBAs need to decide where to host the
data.
Forcing your customers to create a separate database for your
application is unacceptable.

-- 
Sybrand Bakker
Senior Oracle DBA