Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> i don't understand
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 bytesSVRMGR> @/home/franck/oracle/admin/create.sql national character set we8iso8859p1
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:14:07 CST