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

Hi Jesus,

When I created my database with dbca the last section didn't include the option to save to a script. I downloaded my version of 9i from technet (for Solaris). Is your media downloaded or did you order the CDs??

-Dirk

"Jesus M. Salvo Jr." wrote:
>
> Just recently installed Oracle9i software on Solaris8 without a problem.
>
> The problem is with the database creation. Using the Database Configuration
> Assistant ( dbca ) I created a custom template, then created a database
> using that tempalte but told it to write to a script. I then exited
> dbca and ran each of the .sql files called by the script so I can see
> exactly what's happening.
>
> Here are a few problems that I have encountered:
>
> 1) Missing Oracle password file.
>
> Executing the CreateDB.sql script was fine, but when it came to opening the
> database, it complained of a missing password file. This was recorded in
> the alert log.
>
> 2) ORA 12701 CREATE DATABASE character set is not known
>
> This is with either US7ASCII ( the default ) , WE8ISO88591P1, and UT8.
>
> 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.
>
> I was able to have a successful database creation by doing the following,
> although I am not sure which of the combinations below really solved it:
>
> * Ensure ORA_NLS33 is set, even though it is not required.
>
> * Add the DEFAULT TEMPORARY TABLESPACE clause in the CREATE DATABASE
> command in the CreateDB.sql script. This will of course make the
> CreateFiles.sql partially fail since it will try to creat the tabelspace
> TEMP again.
>
> * Create the orapw file and save it in $ORACLE_HOME/dbs using the orapwd
> command.
>
> From here, running the CreateDB.sql script works fine and so does the rest.
>
> John Salvo
Received on Tue Aug 14 2001 - 15:13:49 CDT