i don't understand

From: Speed Shutter <nospam_at_wanadoo.fr>
Date: Fri, 05 Dec 2003 23:13:55 +0100
Message-ID: <pan.2003.12.05.22.13.55.928342@wanadoo.fr>

I made a sql script to make database but I have an error who could help me ?
thanks

my script :

create database base

controlfile reuse
logfile group 1 ('/home/oracle/franck/data/disk1/logbase.ora',

'/home/oracle/franck/data/disk2/logbase.ora',
'/home/oracle/franck/data/disk3/logbase.ora',
'/home/oracle/franck/data/disk4/logbase.ora') size 256k,

        group 2 ('/home/oracle/franck/data/disk1/logbase2.ora',


                '/home/oracle/franck/data/disk2/logbase2.ora',

                '/home/oracle/franck/data/disk3/logbase2.ora',

                '/home/oracle/franck/data/disk4/logbase2.ora') size 256k,

        group 3 ('/home/franck/oracle/data/disk1/logbase3.ora',


                '/home/franck/oracle/data/disk2/logbase3.ora',

                '/home/franck/oracle/data/disk3/logbase3.ora',

                '/home/franck/oracle/data/disk4/logbase3.ora') size 256k

maxlogfiles 4
maxlogmembers 4
maxloghistory 100
maxdatafiles 20
maxinstances 1

datafile '/home/oracle/franck/data/disk1/sysbase.ora' size 100M autoextend off

noarchivelog

character set we8iso8859p1
national character set we8iso8859p1;

my error :
SVRMGR> connect internal
Connected.
SVRMGR> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SVRMGR> startup nomount pfile=/home/franck/oracle/817/dbs/initbase.ora ORACLE instance started.

Total System Global Area                         59465888 bytes
Fixed Size                                          73888 bytes
Variable Size                                    33005568 bytes
Database Buffers                                 26214400 bytes
Redo Buffers                                       172032 bytes

SVRMGR> @/home/franck/oracle/admin/create.sql national character set we8iso8859p1
*
ORA-12701: CREATE DATABASE character set is not known

I understand oracle doesn't understand character set but it seems to be ok, no ?
I have Oracle 8i ver 8.1.7 donwloaded on http://otn.oracle.com/software/products/8i_personal/index.html

Thanks Received on Fri Dec 05 2003 - 16:13:55 CST