Administrace komentářů

Dakujem za nasmerovanie. Upravil som initTEST01.ora a zda sa, ze som sa trochu posunul. Problem mam s vytvorenim databazy.
spustim sqlplus /nolog a potom spustim start CreateDB.sql
v CreateDB.sql mam prikaz na vygenerovanie databazy - vysledok je takyto:

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 52053052 bytes
Fixed Size 451644 bytes
Variable Size 50331648 bytes
Database Buffers 1126400 bytes
Redo Buffers 143360 bytes
SQL> spool /home/oracle/admin/TEST01/create/CreateDB.log
SQL>
SQL> CREATE DATABASE TEST01
2 USER SYS IDENTIFIED BY stefan
3 USER SYSTEM IDENTIFIED BY pista
4 LOGFILE GROUP 1 ('/usr2/oradata/TEST01/redo01.log') SIZE 100M,
5 GROUP 2 ('/usr2/oradata/TEST01/redo02.log') SIZE 100M,
6 GROUP 3 ('/usr2/oradata/TEST01/redo03.log') SIZE 100M
7 MAXLOGFILES 5
8 MAXLOGMEMBERS 5
9 MAXLOGHISTORY 1
10 MAXDATAFILES 100
11 MAXINSTANCES 1
12 CHARACTER SET UTF8
13 NATIONAL CHARACTER SET UTF8
14 DATAFILE '/usr2/oradata/TEST01/system01.dbf' SIZE 125M REUSE
15 EXTENT MANAGEMENT LOCAL
16 DEFAULT TEMPORARY TABLESPACE tempts1
17 UNDO TABLESPACE undotbs
18 DATAFILE '/usr2/oradata/TEST01/undotbs01.dbf'
19 SIZE 150M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
CREATE DATABASE TEST01
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

Ak mi niekto poradi, co s tym, budem mu velmi povdacny.