- 论坛徽章:
- 0
|
脚本如下:
connect SYS/change_on_install as SYSDBA
set echo on
spool /ora_inst/admin/yddb/create/CreateDB.log
startup nomount pfile="/ora_inst/product/9.2.0/dbs/init.ora";
CREATE DATABASE yddb
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/dev/vg00/rora_system' SIZE 1024M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/vg00/rora_temp' SIZE 1024M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/dev/vg00/rora_undo1' SIZE 256M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/dev/vg00/rora_redolog1') SIZE 256000K,
GROUP 2 ('/dev/vg00/rora_redolog2') SIZE 256000K,
GROUP 3 ('/dev/vg00/rora_redolog3') SIZE 256000K;
spool off
exit;
错误信息:
CREATE DATABASE yddb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced |
|