Re: Some feedback creating a database with 9i on Solaris8

From: Jesus M. Salvo Jr. <jmsalvo_at_ihug.com.au>
Date: Tue, 14 Aug 2001 06:28:27 +1000
Message-ID: <9l9d01$a4t$1@bugstomper.ihug.com.au>

Okay, deduced the problem to the oracle password file not being created just before CREATE DATABASE. When that happens, you get the missing oracle password file in the alert log.

If you then create the oracle password after CREATE DATABASE, you then get the ORA 12701 in the alert log.

In short, you HAVE to create the password file BEFORE the database is created.

Jesus M. Salvo Jr. wrote:

> 1) Missing Oracle password file.
>
> 2) ORA 12701 CREATE DATABASE character set is not known
>
> 3) Missing DEFAULT TEMPORARY TABLESPACE clause in the CREATE DATABASE
> command. This was not obvious because of the ORA 12701 at the end of the
> alert log, and this warning message about the default temporary tablespace
> is way further up in the alert log.
>
Received on Mon Aug 13 2001 - 15:28:27 CDT