Re: i don't understand

On Fri, 05 Dec 2003 23:14:07 +0100, "Speed Shutter" <nospam_at_wanadoo.fr> wrote:

>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

Please do not multi- or crosspost

--
Sybrand Bakker, Senior Oracle DBA