Some feedback creating a database with 9i on Solaris8

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 Sat Aug 11 2001 - 02:30:04 CDT